Excel in Microsoft Excel 2: Intermediate to Expert advanced

Get Expert certified! Levels 6-10 for Microsoft Excel 2010, 2013, 2016 and Excel 2019. Covers 77-728, 77-427 & 77-428.

Created by: Phillip Burton • 880000+ students so far
Best Selling Instructor - over 880,000 students so far

Created by: I Do Data Limited
Improve your skills in SQL, Office, Tableau, Power BI + more

What Will I Learn?

• Manage workbooks and workbook review
• Create and manage PivotTables
• Present data visually, using PivotCharts and advanced charts
• Perform data analysis and business intelligence
• Troubleshoot formulas
• Manage and reference defined names and custom workbook elements
• And learn lots of formulas, including VLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT

Requirements

• Before beginning, you need to use Microsoft Excel to an intermediate standard.
• This includes Conditional Formatting, Tables, filtering, sorting and creating charts
• If you have taken the course "Excel in Microsoft Excel - Beginner to Specialist certificate", or taken a Microsoft Office Specialist exam in Excel, then you will have the relevant prerequisites.
• This course is for the PC version of Excel. There are a lot of differences with the Mac version, so menu items are in different places.

Target audience

• 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).