• 8 hours
  • Easy

Free online content available in this course.



Got it!

Last updated on 12/9/22

Course introduction

Hi, I'm Emily! I've been harnessing the power of spreadsheets for the last twenty years and have taught many others how to as well.

Whether you plan to use Excel, LibreOffice Calc, Numbers on Mac, or Google Sheets on Drive, follow this course to master the basics of spreadsheets. I'll take you through all the main features they have to offer and teach you how to enter, format, analyze, and visualize basic data.

  • In Part 1 of this course, we'll take a tour of a spreadsheet and cover basic fundamental features like entering and copying data. You can skip ahead to the quiz if this isn't your first time using one!

  • In Part 2, we'll look at how to format your data and the layout of your spreadsheet. One helpful feature we'll cover is conditional formatting, which highlights data automatically.

  • In Part 3, we will go over basic data analysis features including filtering, sorting, formulas and functions, and VLOOKUP.

  • In Part 4, we'll introduce you to data visualization, including how to create pivot tables and charts. You'll also learn how to share them as a PDF or publish them to the web.

If you want to be organized or start making sense of your data, then you are in the right place! Let's get started!

Table of contents

Example of certificate of achievement
Example of certificate of achievement