Training: Excel – Preparing for data analysis

Module 1: Data tables

• Use the Table function
• Convert a table into a data range
• Using the Fill button
• Using the Flash Fill button
• Performing simple, multi-criteria and custom sorting
• Removing duplicates

Module 2: Importing and exporting data

• Import external data (txt, csv files, data from the web)
• Configure the imported columns
• Export and share data

Module 3: Data entry in a table

• Create and manage drop-down lists
• Mastering data validation
• Identify erroneous data in a table