Data Preparation in Excel

This course is ideal for data consumers and analysts who need to prepare and manipulate data using Excel's functions and features. It is also beneficial for professionals in various industries, such as retail, finance, marketing, and sales, who rely on Excel for data analysis and reporting.

A basic understanding of Excel is required before taking this course. Familiarity with Excel's basic functions and features, such as data entry, simple formulas, and basic formatting, will help you grasp the more advanced topics covered in this course. It is recommended that you have completed the Introduction to Excel course before starting this course.

This course focuses exclusively on Microsoft Excel. You will use various Excel functions and features, such as Flash Fill, text and date functions (e.g., MID, LEN, NOW), logical functions (e.g., IF, AND, OR), lookup functions (e.g., VLOOKUP, HLOOKUP), and PivotTables.

You'll need an active Excel instance on your computer. Under the course materials on the landing page, you'll find a link to download Excel and the necessary files. It is best to use Excel from Office 365 from Microsoft, as this version allows you to use all supported functionalities. Older versions, such as Excel 2021, Excel 2019, or Excel 2016, will support most of the functions introduced in this course but will be too limited for more advanced Excel courses on DataCamp.