Table Of Contents: Unit 1: Logical and statistical functions Topic A: Logical functions Topic B: Math and statistical functions Unit 2: Financial and date functions Topic A: Financial functions Topic B: Date and time functions Topic C: Array formulas Topic D: Displaying and printing formulas Unit 3: Lookups and data tables Topic A: Using lookup functions Topic B: Using MATCH and INDEX Topic C: Creating data tables Unit 4: Advanced data management Topic A: Validating cell entries Topic B: Exploring database functions Unit 5: Exporting and importing Topic A: Exporting and importing text files Topic B: Exporting and importing XML data Topic C: Getting external data Unit 6: Analytical tools Topic A: Goal Seek and Solver Topic B: The Analysis ToolPak Topic C: Scenarios Unit 7: Macros and custom functions Topic A: Running and recording a macro Topic B: Working with VBA code Topic C: Creating functions
Friday Mar 24, 2017
9:00 AM - 4:30 PM EDT
March 24, 2017 9:00 a.m. - 4:30 p.m.
Roane State Oak Ridge Campus
$179
Alicia Hall
Send Email
Printed courtesy of www.oakridgechamber.org/ – Contact the Oak Ridge Chamber of Commerce for more information.
1400 Oak Ridge Turnpike, Oak Ridge, TN 37830 – (865) 483-1321 – info@orcc.org