Data Analytics Fundamentals with Excel

This course explores foundational Excel functionalities with exercises of increasing complexity that will develop skills in data handling and manipulation.

By the end of this course, you will be able to use Excel to calculate and automate simple data tasks as well as illustrate data in more meaningful ways. 

Course duration
Next start date
Recommended for learners who are fairly new or have minimal experience with Excel, looking to learn foundational Excel functionalities.
Topic areas covered include:
  • Formatting and editing tables
  • Changing data types
  • Performing simple calculations
  • Updating a line graph
  • Creating a pivot table
  • Performing simple sorting functions
  • Using unique identifiers across multiple tables
  • Displaying cells based on criteria (VLOOKUP)
  • Counting based on multiple criteria (COUNTIF)
Technical requirements
  • Microsoft Excel (Desktop version preferred)
Recommended prerequisite courses
  • N/A
Recommended prerequisite skills
  • N/A
Data Analytics Fundamentals with Excel