Add to basket or enquireEnquire now
Our Microsoft Excel Advanced course will push your Microsoft Excel skills to a new level.
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.
Grouping & Outlining and Subtotals
- Outlining and Grouping Data
- Using the Subtotals Tool
- Exploring Scenarios
- Goal Seek and Data Tables
- Using Solver
- Getting Started with PivotTables
- Displaying Data in a PivotTable
- Formatting a PivotTable
- Using the Classic PivotTable Layout
Charting Pivoted Data
- Getting Started with PivotCharts
- Using the PivotChart Tools Tabs
- Formatting a PivotChart
Advanced Excel Tasks
- Excel and Hyperlinks
- Using Custom AutoFill Lists
- Sharing Workbooks
Creating HLOOKUP and VLOOKUP Functions
- Using the VLOOKUP Function
- Using the LOOKUP Function
Introduction to Macros in Excel
- Recording and Playing Macros
- Copying and Deleting Macros
- Visual Basic and Macros
Who is this course for?
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. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Questions and answers
Rating and reviews
There haven't been any reviews for this course yet.Leave a review
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.