365 | 2019 | 2016
This instructor-led course covers more advanced formulas that include relative and absolute cell references. Incorporate advanced functions such as IF, VLOOKUP, and ISERROR into your formulas. Learn tools, such as the PivotTable, to analyze and summarize your data. It is geared for users who have experience with Microsoft Excel and need to learn these more intermediate/advanced features.
Working with Statistical and Logical Functions
Using Text Functions and Features
Creating VLOOKUP Formulas
Using PivotTable Reports to Summarize Data
Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9:00 am to 12:00 pm and 1:00 pm to 4:00 pm).
|Public Course at Softek||Private Course at Your Office||Private Course at Softek|
|This class is||$500 flat fee up to 8 students||$575 flat fee up to 8 students|
|only offered||$550 flat fee up to 12 students||$625 flat fee up to 12 students|
|for private groups.||$35 per additional student||$35 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.