Master Office 2010/2013

• 1

• 3

• 30

  weeks

Effectively use Microsoft Office 2010/2013 word processing applications (Word), spreadsheets (Excel), multimedia presentations (PowerPoint) and databases (Access), being able to produce highly professional and competitive documents.

• 1

• 3

• 30

  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 · Microsoft Access, – Exploring Access, – Create a database, – Populate a database, – Share and reuse information, – Simplify data entry using forms, – Locate specific information, – Do keep your information accurate, – Work with reports, – Make the database easy to use, – Protect and share information Microsoft PowerPoint, – Explore PowerPoint, – Start a new presentation, – Work with presentation text slide, – Adjust the layout and appearance of slides, – Add tables, graphs, and diagrams, – Enhance slides with chart, – Add animation, audio, and movies, – Review and share a presentation, – Create your own presentation elements, – Electronically display a presentation, – Set up a presentation for the web, – Customize PowerPoint · Microsoft Outlook, – Get started with Outlook, – Manage contact items, – Send email messages, – Work with your inbox, – Work with appointments, events and meetings, – Calendar management, – Tasks, – Gather information, – Work from outside the office, – Customize and configure Outlook

• 1

• 3

• 30

  weeks

2