Mastering Excel 2016 – Basics
Course details
- No. of Lessons: 27
- Duration: 4:08:47
- Skill level: Basic
- 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!
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 |
