Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

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

via Skillshare

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

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.

Syllabus

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

Taught by

Ruben Wollerich

Reviews

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.