Progressive

What you will learn

• Word: format a document in an advanced way, manage the arrangement of texts in relation to the graphic elements, format paragraphs by customizing the values ​​and appearance of elements; use Styles, applying those available and creating them in a personalized way; manage References in the document, such as captions, they notice pie page and closure, citations and bibliography, the indices, bookmarks and cross-references, use Word's automatic features: insert and modify fields, create forms to share, use mail merge, connect and insert data into the document and manage macros.
• Excel: customize the data format, applying custom number formats, text and dates; use conditional formatting, setting and managing formatting rules; manage spreadsheets with ease, acting on rows and columns; insert functions into formulas; use the finance functions, the logical functions, text functions, search and reference functions, for dates and times, mathematical and statistical functions; create, edit and manage charts; analyze data with pivot tables; sort the data, according to certain criteria and to filter them; know the advanced functions, such as macros, data validation, verifying formulas, data connection and data protection.
• PowerPoint: design presentation slides in an advanced way, setting a pattern, inserting layouts into the schema and formatting it; create custom templates and themes; format graphic objects, disposing them in a homogeneous manner; set the background of the slides; insert and manage graphics and smart art in an advanced way; insert multimedia content, such as audio and video, and set animations; connect, enter and transfer files; create custom presentations, start them and automate them; export, share project a presentation correctly; know the basic rules for designing a presentation based on the speech and the audience.
• Access: design a database, create a table, view in Structure mode, relate the tables; use queries, such as table creation ones, queuing, updating and deleting; create queries and use them to filter database records; create masks and format them; understand reports and know how to create them from scratch.