Microsoft Word Expert – Excel 2010/2013

• 1

• 2

• 12

  weeks

Optimize time and results in work with the Word application to make memos, reports and letters, achieving a completely professional appearance including graphs, tables, managing documents and work groups. Master Excel skills (cell, sheet and workbook), such as inserting and working with different types of data, creating formulas, working with ranges, inserting functions, working with databases, pivot tables and creating, recording and running macros.

• 1

• 2

• 12

  weeks

· Microsoft Word, – Exploring Word, – Edit and review documents, – Change the appearance of text, – Change the appearance of the document, – Display information in tables and columns, – Work with graphs, symbols, and equations, – Work with diagrams and charts, – Work with longer documents, – Create templates for letters, emails, and labels, – Collaborate with others, – Create documents for use outside of Word, – Customize the application · Microsoft Excel, – What's new in Excel 2010/2013?, – Create an Excel workbook, – Work with data and data tables, – Perform calculations with data, – Change the appearance of documents, – Focus on specific data using filters, – Reorder and summarize data , – Combine data from multiple sources, – Analyze alternative data groups, – Create dynamic lists with pivot tables, – Create dynamic charts using pivot tables, – Print, – Automate repetitive tasks using macros, – Work with other programs in the Microsoft Office system – Collaborate with others

• 1

• 2

• 12

  weeks

1