Mastering Excel 2016 – Basics

Mastering Excel 2016 - Basics

# of Lessons

27

Duration

4:08:47

Skill Level

Basic

MSRP

$30

Instructor(s)

Barbara Evers

Available Captions

English, Spanish

Also Included

Handout, Practice Files, Knowledge Check, BrainBot Booster, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style! 

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 multi-layered, 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.   This is our most requested training course!  If you learn to use Excel 2016, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are just getting started with Excel, let our Microsoft Certified Trainers, Barbara Evers and Christina Tankersley, walk you through the basics of what you need to know about Microsoft Excel 2016.    Topics covered include: 

  • Navigating around Excel 
  • Creating and saving a workbook 
  • Using basic Office features including Undo, Redo, and Office clipboard 
  • The basics of functions and formulas 
  • Applying formatting 
  • Managing workbook properties 

 Quickly search for and find the skills you want to master– then just point, click, and learn.  Over 4 hours of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style!  Note: When combined with the Intermediate and Advanced versions of this course, these cover all the objectives required in the Microsoft Office Specialist exam 77-727 

Course Contents:

#  Lesson  Length 
1  Intro  8:53 
2  Selecting and Navigating   7:55 
3  Keyboard Navigation and Basic Data Entry   9:18 
4  The Ribbon   5:23 
5  The Quick Access Toolbar   4:28 
6  Creating a New Spreadsheet   9:08 
7  Compatibility Issues   5:26 
8  Cell Data & Data Types   12:41 
9  Accessing Help   3:11 
10  Creating Worksheet Formulas   11:11 
11  Insert Functions   11:28 
12  Re-using Formulas and Functions   12:00 
13  Insert, Delete, & Adjust Columns & Rows   7:22 
14  Find and Replace   9:52 
15  Use Proofing and Research Tools   11:21 
16  Apply Text Formats   14:14 
17  Apply Number Formats   7:00 
18  Align Cell Contents   8:45 
19  Applying Styles and Themes   11:43 
20  Conditional Formatting   11:42 
21  Creating and Using Templates   6:13 
22  Preview and Print a Notebook   8:48 
23  Page Layout   15:44 
24  Configure Headers and Footers   12:37 
25  Managing Worksheets   6:32 
26  View Options   10:54 
27  Managing Workbook Properties   4:58 

Related Course Recommendations:

Mastering Excel 2016 - Intermediate
Mastering Excel 2016 - Advanced
Whats New in Excel 2019?

Catalog Request

Login Logo