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 

 

When you master Microsoft Excel 2016, you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet expert can work wonders – from organizing lists, to creating multi-layered, interactive reports. Spreadsheets can help businesses make decisions regarding critical issues involving accounting, budget allocations, expenditures, and inventory. This course is your first step towards getting started with Microsoft Excel and turning it into your most powerful productivity tool. 

Excel is our most requested training course!  Once you learn Excel, you’ll quickly 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 Trainer Barbara Evers walk you through the basics of what you need to know about Microsoft Excel 2016.  

 

Topics covered include: 

  • Navigating Excel’s interface 
  • Creating and saving a workbook 
  • Formatting text, numbers, and cells 
  • Learning the basics of functions and formulas 
  • Managing workbook properties 
  • Applying styes and themes 
  • Creating and using templates 
  • Previewing and printing a notebook 

 

Quickly search and find the skills you want to master– then just point, click, and learn. 

 

Enjoy 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, you will 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:

Catalog Request

Login Logo

Get course updates, Learning and Development ideas, and Information on how to use Bigger Brains!