365 | 2019 | 2016
1 Day, 9:00-4:00
This instructor-led course, through hands-on exploration, will teach students the skills needed to work with large lists of data, PivotTables, outlining, named ranges, conditional formatting, macros, data validation, and protection. Students will also learn how to write additional formulas that use the VLOOKUP function.
Working with Large Lists of Data
Creating PivotTables to Analyze Data
Using Data Analysis Tools
Automating Tasks with Conditional Formatting and Macros
Using VLOOKUP to Locate Values
Setting Data Validation and Protection
|Public Course at Softek||Private Course at Your Office||Private Course at Softek|
|$275 per student||$850 flat fee up to 8 students||$1000 flat fee up to 8 students|
|or 1 voucher||$950 flat fee up to 12 students||$1100 flat fee up to 12 students|
|10% discount when 3+ attend||$50 per additional student||$50 per additional student|
Private group courses are cost effective when you have a group of students who need the same course. Pricing is based on the maximum number of students anticipated per day per course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your office, you are responsible for the classroom setup, including student computers, instructor station, LCD projector, and software installation. For courses conducted at Softek, we take care of classroom setup.