The Basics of Data Analytics in Excel: Sort, Filter & Pivots

In this class, you’ll learn the basic tools and functions that Microsoft Excel offers to do a Data Analysis. While Excel has an endless set of tools and features, this class will help you understand the most useful features that will allow you to convert data into insights. 

Whether you’re a beginner Excel user looking for an easy way to learn the basics or you’re a marketing, finance, or business operations professional looking to brush up on your Excel skills, this is a great class for you!

This class has been designed to be easy to follow and straightforward - no fluff. The material is not too complex and it’s been divided into bite-sized lessons. All versions of Microsoft Excel can be used for this class and the learnings in the class can also be translated to users of Google Sheets! The formulas are in English, so if you’re using a version of Excel in another language, you might have to look up the formula names in the language of your Excel.

• Introduction
• Class Outline & Project Description
• Introduction to Data Analytics
• Data Preparation
• Filtering
• Sorting
• Pivot Tables
• Pivot Charts
• Key Formulas
• Project Review
• Outro