Microsoft Excel

Course Description

Microsoft Excel is the world's best-know data application and a core part of the Microsoft Office suite, along with Microsoft Word and Microsoft PowerPoint. In this introductory course, you'll learn how you can use the desktop version of the Microsoft Excel spreadsheets to enter, organize, refine, analyze, and visualize your data to present your story.

Course Information

  • Introductory level
  • 42 streaming video tutorials
  • 3 hours 2 minutes of instruction
  • Created by Barton Poulson
  • Published 25 May 2018 
  • Videos are shared freely with a Creative Commons Attribution license
  • Download the free course files here

Note. To navigate the videos, click on the menu icon (☰) in the top left of the video.

Table of Contents

GETTING STARTED

  • Welcome {5:02}
  • Downloads {4:58}
  • Pictures first {2:37}
  • Anatomy of a spreadsheet {2:31}
  • Data types {7:34}
  • Formatting cells {7:16}
  • Tidy data {0:00}

SHARING WORK

  • Sharing files {3:07}
  • Sharing folders {2:31}
  • Notes {2:06}
  • Comments {3:34}
  • Chat {2:36}
  • Publishing files {2:33}
  • Version history {2:18}

PREPARING DATA

  • Entering data {4:44}
  • Importing data {3:10}
  • Copying & pasting data {5:02}
  • Selecting & moving data {4:58}
  • Sorting data {2:37}
  • Filtering data {2:31}
  • Filter views {3:15}

MAKING CHARTS

  • REPT charts {2:41}
  • Bar charts with table data {3:42}
  • Bar charts with raw data {1:56}
  • Grouped bar charts {6:37}
  • Bar charts with highlighting {2:24}
  • Pie charts {8:13}
  • Histograms {5:34}
  • Line charts {9:15}
  • Timelines {3:30}
  • Sparklines {7:30}
  • Scatterplots {3:44}
  • Scatterplots with highlighting {2:15}
  • Automatic charts with Explore {3:23}
  • Publishing charts {3:30}

USING FORMULAS

  • Cell references {7:02}
  • Counts, sums, & means {4:48}
  • Dates & times {11:34}
  • Selecting text {6:47}
  • Combining text & data {5:51}
  • Conditional formatting {5:28}

WRAPPING UP

  • Next steps {2:15}