PREREQUISITE: Must have knowledge of Excel Intermediate or equivalent.
Many businesses require individuals to possess advanced Excel skills. In this course, learn how to use What If Analysis tools such as Scenarios and Solver. Record and run macros, create advanced charts and use complex functions. Learn about Vlookup, Match, Index, Importing/Exporting Data, Analytical Tools, Goal Seek, Scenario, Solver, Running and Recording a Macro, Buttons, Shortcuts, Combo Charts, and more.
INSTRUCTOR: Bret Babich
Mon & Wed, Aug 19 & 21, 9 a.m.-1 p.m.
Remote-Live
2 sessions: 8 hrs, CEU 0.8