Microsoft Excel Advanced
- 3 hours on-demand video
- 2 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010, 2013 or 2016 tools and concepts in order to increase their knowledge and productivity.
- Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
MODULE 1: Grouping & Outlining and Subtotals
Learning outcomes: Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.
Outlining and Grouping Data
Using the Subtotals Tool
MODULE 2: What-If Analysis
Learning outcomes: Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet's data and formulas.
Goal Seek and Data Tables
MODULE 3: PivotTables
Learning outcomes: Creating Pivot Tables in order to display and summarise large quantities of data effectively.
Getting Started with PivotTables
Displaying Data in a PivotTable
Formatting a PivotTable
Using the Classic PivotTable Layout
MODULE 4: Charting Pivoted Data
Learning outcomes: Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.
Getting Started with PivotCharts
Using the PivotChart Tools Tabs
Formatting a PivotChart
MODULE 5: Advanced Excel Tasks
Learning outcomes: Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.
Excel and Hyperlinks
Using Custom AutoFill Lists
MODULE 6: Creating HLOOKUP and VLOOKUP Functions
Learning outcomes: Exploring the different Lookup functions, and how to add further functionality to a spreadsheet to reference particular data quickly and effectively.
Using the VLOOKUP Function
Using the LOOKUP Function
MODULE 7: Introduction to Macros in Excel
Learning outcomes: Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.
Recording and Playing Macros
Copying and Deleting Macros
Visual Basic and Macros
- Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time.