Courses

In this course, students will learn how to use Excel to perform advanced calculations to facilitate decision-making and the acquisition of insight.

Topics covered include Power Pivot, descriptive statistics, logic functions, VLOOKUP and HLOOKUP, and data simulations (Goal Seek, What-If Analysis, and Solver).

In this course students will gain the skills necessary to create and use pivot tables and charts, audit and analyze worksheet data, trace precedents and dependents, utilize data tools, collaborate with others by protecting worksheets and books, import and export data; convert text and validate and consolidate data; create and manage macros.