Search
Search
Close this search box.
All   >   Mastering Excel 2016 – Basics

Mastering Excel 2016 – 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 

$30 USD

Suggested price per user, ask about bundle discounts

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! 

 

Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives, and include captions and transcripts in 29 languages, downloadable handouts, and optional LinkedIn digital badges on course completion.

 

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 

$30 USD

Suggested price per user, ask about bundle discounts

Related Course Recommendations

Mastering Excel 2016 – Intermediate

Mastering Excel 2016 – Advanced

What’s New in Excel 2019?

Bigger Brains Course Catalog and Pricing

Fill out the information below to receive a download link for our latest course catalog.

I am getting training for…