Duration: 1 day
Remote Attendance: Click here for more information.
Course Description: This course covers how to create and use advanced formulas, analyze data, organize worksheet data with tables, create macros, navigate the VBA development environment, and enhance workbooks. By the end of this course students should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, recording macros, using the VBA environment to execute custom code, and enhancing workbooks.
Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
Course Prerequisites: Knowledge equivalent to attending the Introduction to Excel 2016 course.
|Applying Range Names
||Using Specialized Functions
|Using Text Functions
||Using Logical Functions
|Using Lookup Functions
||Using Date Functions
|Using Financial Functions
||Creating and Modifying Tables
|Sorting and Filtering Data
||Using Subtotal and Database Functions to Calculate Data
|Creating a PivotTable
||Analyze Data with PivotCharts
|Creating and Using Templates
|Preparing a Workbook for Multiple Audiences
||Automating Tasks Using Macros
|Visual Basic for Applications (VBA)
Individual training passes: save up to 43%! For complete discount options » click here «
|# Courses||Total Cost||Cost Per Course||% Savings|