Introduction to MS Excel: Basics

Attached you'll find the slide deck and sample worksheet that was used during the April 20th training. In the video below, you can navigate the various learning objectives by clicking on the Up Arrow found at the bottom center of the video.

Learning Objectives and minute markers:

  • The Difference Between Excel, Smartsheets and Google Sheets 4:28
  • Learning Objectives 5:38
  • Creating a New Sheet, Renaming Tabs, Moving Tabs 7:08
  • Formatting Cells 9:38
  • Adding Columns or Rows 13:52
  • Filtering and How to Sort Data 14:40
  • Formatting Cells to Display Correct Values 15:04
  • Adding Filters 15:33
  • Sorting Filtered Data 16:25
  • Formulas 17:24
  • Absolute Cell References 22:01
  • Questions? 24:32