Advanced Data Manipulation in Excel

Course details

This course covers advanced data manipulation techniques for spreadsheet analysis and modeling.  These are "power techniques" which, once internalized, can enable you to manipulate data and information with speed and agility in your spreadsheets.

The major content areas of this course are:

1. Lookup Functions and Absolute/Relative/Mixed Reference - The Must-Know Techniques for Data Manipulation in Excel
2. Text and Date Manipulation
3. Arrays and Ranges
4. Working With External Data Sources (Optional Material)
5. The Excel Data Ribbon (Optional Material)

For this course, we have hand-selected some of the most important data manipulation skills needed for analysis and modeling using Excel, and we present them to you using realistic business-oriented examples.  Each of the key concepts has an exercise in Excel for you to gain immediate practice implement it within an example business context, complete with solutions and solution walk-through videos for you to check your work. If you are currently working in or seeking a role in finance, accounting, planning, forecasting, procurement, supply chain management, or other business operations functions, and you wish to continue building your abilities to manipulate data and build spreadsheets, then this is the course for you!

This course covers advanced techniques.  In order to understand the material in this course, students will need to have proficiency entering in data and formulas in Excel, and have some experience using Excel functions.  Students will also benefit from having some exposure to nested functions and creating and working with Pivot Tables.  If you are not familiar with these topics, please consider our preceding course, Fundamentals of Data Manipulation and Visualization in Excel.

Including the lecture content and the exercises, this course should take about 5-8 hours to complete.