Microsoft Office Specialist Excel 2013 Expert

Course details

Excel 2013 is a spreadsheet program. Excel is a smart way of seeing your important information and understanding them with great depth. Giving you charts and tables based on your data, it simply makes your workload lighter.

Excel can be used for books, mailing lists, grocery lists, tracking expenses, creating increating addressvoices and bills, doing financial accounting, balancing checkbooks, as well as any other purpose that requires a spreadsheet or table.

Teaches you how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.

Office 2013 combines cloud and web technologies to extend the way you create and consume information and introduces a new cloud app model for you to build secure and flexible apps—all discoverable from the familiar Office interface.

The World's Largest IT Certification

Excel 2013 Office Certification Series covers Excel  2013 Microsoft Office Specialist Exam #77-420, #77-427, #77-428 from Microsoft. By passing this exam and getting a Microsoft Certification, you become part of the MCP (Microsoft Certified Professional) Network. Microsoft Office Specialist certification is a great entry point. Certification increases your visibility, differentiate you from your peers and bring you recognition for your knowledge and skills.

Training and certification play an essential role in preparing IT professionals for the evolving IT organisation.

Entrance Criteria

•  Grade 10
•  Learners must be at least 16 years of age
•  The ability to read and write in English
•  Access to the internet AND Access to a computer
•  Access to Microsoft Office Software
•  Exam fees are not included in your course fees

Course Structure

Core:

• Introducing Excel
• Constructing Cell Data
• Using Formulas
• Formatting the Worsheet
• Viewing and Printing Workbooks
• Working with Charts and Graphics
• Organising Data
• Macros, Importing and Exporting Data

Expert: 

• Advanced Functions and PivotTables
• Advanced Charts, Conditional Formatting and Checking Formulas
• Filtering and sharing Workbooks
• Custom Formatting and What-If Analysis
• Pivot Charts and Advanced Formulas
• Protecting and confirguring workbooks