Microsoft Excel for Mac 2: Intermediate to Expert advanced

Elevate your Microsoft Excel skills with Levels 6-9! Building upon the foundation of "Microsoft Excel for Mac 1," this comprehensive course equips you with the expertise needed to conquer the official Microsoft Excel Expert exam. Imagine the impact on your resume!

Note: This course is independent of, and not endorsed by, Microsoft.

What Students Are Saying:

"Well thought out and explained in a way which makes it easy to learn & understand." - Arnold Schwartz
"This course is very well structured and the teachers knowledge is very good. His teaching style is capturing and he is very structured. The small tests after each section is great, and even greater is that he takes time to show his thoughts on how is should have been done, not just leaving one to wonder if it was right or not. The resources used in this course is also very suitable. Highly recommend this one" - Daniel Sandberg

Most Excel users operate at Level 3 in some areas and Level 2 in others. Ready to reach the pinnacle? This course takes you all the way to Microsoft Excel Level 9.

You will learn how to:

• Manage Workbooks: Master workbook options, settings, and review processes. Learn to apply workbook settings, properties, and data options effectively.
• Advanced Data Visualization: Create sophisticated charts and Excel tables for insightful data representation.
• PivotTable Mastery: Create and manage powerful PivotTables and PivotCharts for data analysis.
• Advanced Formatting: Utilize advanced formatting techniques to enhance your spreadsheets.
• Formula Expertise: Prepare for advanced formulas, troubleshoot complex Excel formulas, manage defined names, and utilize array formulas.
• Data Manipulation: Look up data using functions like VLOOKUP, HLOOKUP, MATCH, INDEX, TRANSPOSE, and INDIRECT – including translation capabilities for 15 different languages.
• Automation & Accessibility: Create and modify custom workbook elements, and prepare workbooks for internationalization and accessibility.

Exam Preparation:

This course covers all the skills Microsoft emphasizes for the Excel Expert exams (77-728 for Excel 2016 Expert), including PC-specific aspects. It's an invaluable resource whether you're aiming for certification or simply seeking to deepen your Microsoft Excel knowledge. We cover the core skills tested in the exam, ensuring you're prepared for what Microsoft wants you to know.

Course Structure:

Each module is structured logically with sub-topics, and each sub-topic features a concise 5-7 minute lecture. The course is designed to take approximately 8 hours to complete, with additional time recommended for self-assessment.

Who Should Take This Course?

• Individuals seeking to expand their Microsoft Excel skills.
• Those aiming to achieve Microsoft Office Specialist Expert certification.
• Anyone wanting to move beyond basic Excel proficiency, regardless of whether they use Excel 2016, 365, or 2011.

This course will help you achieve an advanced level of competency and unlock the full potential of Microsoft Excel.