Microsoft Excel 2016/2019/O365 - Level 3 / Advanced
Learn advance Excel skills.
GK# 6745
Learn advance Excel skills.
GK# 6745
This course will teach you how to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes.
You will also learn how to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions that will put the full power of Excel right at your fingertips.
The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates.
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Enhancing Workbooks
Customize Workbooks
Manage Themes
Create and Use Templates
Protect Files
Preparing a Workbook for Multiple Audiences
Auditing Worksheets
Trace Cells
Watch and Evaluate Formulas
Create a Data List Outline
VLOOKUP Review
Working with Multiple Worksheets and Workbooks
Consolidate Data
Link Cells in Different Workbooks
Merge Workbooks
Exporting Excel Data
Export Excel Data
• The Export Process
Import a Delimited Text File
Integrate Excel Data with the Web
Create a Web Query
Analyzing Data with PivotTables, Slicers, and PivotCharts
Create a PivotTable
Filter Data by Using Slicers
Analyze Data with PivotCharts
Automating Worksheet Functionality
Update Workbook Properties
Create and Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2016. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment.
To meet these prerequisites, students can take the following:
This course is intended for students who are experienced Excel 2016 users and 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.
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.