Fundamentals of Data Manipulation and Visualization in Excel

Course details

This course seeks to help beginning to intermediate users enhance their skills in both the manipulation and visualization of data in Microsoft Excel.

 The course will focus on key functionalities of the program like using formulas and functions, manipulating data using sorting, filtering, lookup functions and Pivot Tables, and visualizing data using conditional formatting, charts, and Pivot Charts.

 The 4 major content areas of this course are:

1) Formulas and Functions

2) Fundamental Techniques of Data Manipulation

3) Charting and Formatting

4) Pivot Tables

For this course, we have hand-selected some of the most important skills needed for business modeling, and we present them to you in a way that leans heavily on realistic business examples. Each lecture video has an exercise in Excel for you to immediately practice its techniques within an example business context, complete with solutions and solution walk-through videos for you to check your work. If you are currently working or seeking a role in finance, accounting, planning, forecasting, procurement, supply chain management, or other business operations functions, and you wish to build the skills needed to use spreadsheets to manipulate data and build models, then this is the course for you!

Each of these sections has 20 to 30 minutes of video lecture material. The course has been adapted from an in person training course that was a day long. Including the lecture content and the exercises, it should take about 5-8 hours to complete.