Excel in Microsoft Excel 2: Intermediate to Expert advanced
153
Lessons
All
Skill Level
11:04h
course Duration
English
Audio
Eng
Subtitles
Overview
This course series has been recorded on Excel 2016 and Excel 2010, but the content also covers Excel 2013 and 2019.
There are two separate courses, one for Excel for PC and one for Excel for Mac.
Building on the skills learnt in “Excel in Microsoft Excel 1”, here’s levels 6-10. By the end of this course, you will have the skills needed for the official Microsoft Excel Expert exam. How would that look on your resume?
Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 10?
This course teaches all the skills that Microsoft want you to know for the Expert exams. Specifically, they are the skills required to undertake the Microsoft Certificate 77-851 (for Excel 2007 Expert), 77-888 (for Excel 2010 Expert), 77-427 and 77-428 (for Excel 2013 Expert) and 77-728 (for Excel 2016 Expert) and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel
The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.
Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.
Completing this course will help you:
- Manage workbooks and workbook review
- Create and manage PivotTables
- Present data visually, using PivotCharts and advanced charts
- Perform data analysis and business intelligence (only usable in the PC version)
- Troubleshoot formulas
- Manage and reference defined names and custom workbook elements
- And learn lots of formulas, including VLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT
Who is the course for?
This is for you if you want to develop your Excel skills to an Expert level.
This is also for you if you want to take the Microsoft Office Specialist Expert Exams.
This may not be for you if you are not already at least at an Intermediate level (already done levels 1-5 or equivalent).
Learning Path
- Manage workbooks
- Protect documents and Manage workbook review
- Using Logical and Statistical Functions
- Creating PivotTables
- Advanced Formatting
- Creating PivotCharts and advanced charts
- Apply advanced date and time and financial functions
- Troubleshoot formulas
- Prepare a workbook for internationalisation + accessibility
- Manage and reference defined names
- Formula Arrays
- Perform data analysis and business intelligence (PC only)
- The Data Model and PowerPivot (PC only)
- Create and modify custom workbook elements
- Create advanced formulas
- Link form controls to cells
- Visual Basic for Applications (VBA)