Excel in Microsoft Excel 2: Intermediate to Expert advanced

Master Advanced Excel Skills: Excel Expert Certification Prep

Elevate your Excel proficiency with this comprehensive course series, designed to take you from intermediate to expert level. While recorded on Excel 2016 and Excel 2010 for PC, the concepts are applicable to Excel 2013, Excel 2019, and even Excel 365. Building upon the foundational skills learned in "Excel in Microsoft Excel 1", this series covers levels 6-10, equipping you with the skills needed to confidently tackle the Microsoft Excel Expert exam. Imagine the impact this would have on your resume!

What You'll Learn:

• Workbook Management: Master workbook options, settings, and review features. Learn to apply settings, properties, and data options for optimal performance.
• Advanced Charting & Tables: Create compelling and insightful Excel charts and Excel tables to visualize your data effectively.
• PivotTable Mastery: Become proficient in creating and managing PivotTables and PivotCharts for powerful data analysis.
• Advanced Formatting: Refine your workbooks with advanced formatting techniques.
• Advanced Formulas & Functions: Prepare for complex formulas, troubleshoot errors, manage defined names, and utilize array formulas.
• Data Analysis & Business Intelligence: Apply data analysis techniques and gain insights for informed decision-making using Excel.
• VBA Automation: Explore Visual Basic for Applications (VBA) macros and form controls to automate tasks and customize your workbooks.
• Lookup Functions: Efficiently retrieve data using functions like VLOOKUP, HLOOKUP, MATCH, INDEX, TRANSPOSE, and INDIRECT.
• Internationalization & Accessibility: Prepare workbooks for global use and ensure accessibility for all users.

Exam Preparation:

This course directly aligns with the skills tested in the official Microsoft Excel Expert exams. It covers the requirements for the following certifications:

• Microsoft Certificate 77-851 (Excel 2007 Expert)
• Microsoft Certificate 77-888 (Excel 2010 Expert)
• Microsoft Certificate 77-427 & 77-428 (Excel 2013 Expert)
• Microsoft Certificate 77-728 (Excel 2016 Expert)

Whether you're aiming to pass the exam or simply expand your Microsoft Excel knowledge, this course is an invaluable resource.

Course Structure:

The course is structured with modular lessons, each divided into manageable sub-topics. Each sub-topic features a concise lecture (5-7 minutes). The modules are presented in a logical order, ensuring a smooth learning progression.

Time Commitment:

The course requires approximately 8 hours to complete, with additional time recommended for practice and self-assessment.

Who Should Take This Course?

This course is ideal for:

• Individuals seeking to deepen their Excel skills.
• Those aiming to achieve Microsoft Office Specialist Expert certification.
• Anyone wanting to leverage Excel for advanced data analysis and business intelligence.
• Users of Excel 2007, Excel 2010, Excel 2013, Excel 2016, or Excel 365.

What Others 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

Learn Excel for Data Analysis, Business Intelligence, and Automation. This course will help you reach a new level of proficiency in Microsoft Excel. The skills taught are the core skills Microsoft wants you to know. The course is translated into 15 different languages.