Mastering Excel – The Basics

The world is filled with two kinds of people: a handful of people who are masters of Excel, and the millions of others who wish they were. If you’ve mastered Microsoft Excel 2016, then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders from organizing lists, to creating multilayered, interactive reports, to revealing answers to businesses’ critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your first step towards getting started with Microsoft Excel


What Will I Learn?

  • Navigating Excel
  • Navigating the Ribbon
  • Discuss compatibility issues between Excel 2016 and older versions of Excel
  • Cell Data & Data Types
  • Create worksheet formulas
  • Copy formulas and functions to multiple cells
  • Assemble templates for use on future spreadsheets

Topics for this course

27 Lessons4h

Topic 1

Lesson 1: Intro00:08:54
Lesson 2: Selecting and Navigating00:07:55
Lesson 3: Keyboard Navigation and Basic Data Entry00:09:18
Lesson 4: The Ribbon00:05:22
Lesson 5: The Quick Access Toolbar00:04:27
Topic 1 Quiz

Topic 2

Topic 3

Topic 4

Topic 5

Final Quiz


Material Includes

  • Quick Tips Handout
  • 24 Practice Files that follow the videos

Target Audience

  • Any person working with Microsoft Office
  • Secretaries
  • Corporate Employees

Includes course videos

About the instructors

0 (0 ratings)

2 Courses

5 students

Shopping Cart
Scroll to Top