Microsoft Excel 2013 - Level 3 / Advanced
Learn to use VLookup, create PivotTables, and develop macros with this advanced Excel course.
GK# 6743
Learn to use VLookup, create PivotTables, and develop macros with this advanced Excel course.
GK# 6743
Students will learn more of the advanced features of Excel. They will acquire upper-level skills, which will allow them to get the most bang for their buck from this powerful software. Attendees will look at working with scenarios, using Solver, VLookup, the Analysis ToolPak, PivotTable features and developing macros. Other features such as conditional formatting, slicers, the Inquire Add-In, and tracking changes are also covered. If time allows, an introductory lesson on Power Pivot and Power View will be covered.
Students will learn how to:
Working with Scenarios
Using Goal Seek, Solver and VLookup
Analyzing Data
Managing Data
Working with Slicers
Introduction to PivotTable (covered more in-depth in Excel 2013 PivotTable)
Using the Inquire Add-In
Tracking Changes
Using Macros
Course prerequisites include taking Excel 2013 Level 2 or an equivalent in working knowledge of the software.
This course is intended for students who are experienced Excel 2010 users who have a desire or need to advance their skills in working with some of the more advanced Excel features.
Advance specific Excel skills with courses on PivotTables, Spreadsheet Analysis and Data List Management.
Excellent instructor who taught us well, giving us tips to quicken our tasks in Excel.
This Office course comes with extended access to the following benefits:
This course is available in the following formats:
Receive face-to-face instruction at one of our training center locations.
Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.