Master Excel 2016 For Complete Beginners In This Helpful, Info-Packed Video Course

  • Easily learn Excel 2016 for complete beginners
  • How to get Excel and installation requirements
  • Helpful discussion of new features in 2016
  • Getting started with a Workbook
  • Entering and editing data
  • All lessons in easy step-by-step format
  • Practice with included exercise files

Excel 2016 From The Beginning

This course assumes you've never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer will start you from the very beginning from installing the program to creating your first Workbook and entering data. Before you know it, you're using Excel 2016 like a pro with advanced functions. You will have the expertise you need to impress the boss at work. You can also use this essential application to accomplish all kinds of tasks for your personal life or business.

If most Excel courses seem to be designed for people who already have experience with the program, this course will be a breath of fresh air. The videos keep things simple and carefully step you through each process.

Contents and Overview

This course starts with where to find Microsoft Excel and installing the program. Then you learn step-by-step, simple 1-2-3 methods for getting up and running with Excel 2016. Watch just the first few videos to have a basic knowledge of Excel. Then continue through the detailed 16 chapters of video lessons and 5 exercise files to gradually become a proficient user.

It's important to note that we don't assume you know anything about Excel 2016. We start from the basics. After installation we discuss what is new with 2016, using Touchscreen, opening a Workbook, and how to use Help to get additional answers when you need them.

Then we show you how to personalize Excel for your own use with exciting Excel Options. We discuss all the Ribbons and Toolbars, entering and editing data, backup and recovery, fill and series, and printing your projects. We also work with Worksheets and formulas and functions.

Upon completion of this course you will know the essentials of Microsoft Excel 2016.

What People Are Saying:

“I bought the course because I wanted to learn more about the use of Excel to assist me in my job. So far, I am very happy with the instructions. They are very detailed and easy to follow. I am able to pause to make notes and rewind if needed. I have used Excel with basic knowledge of the system, but I feel that when I am done with this course I will be able to create better spreadsheets and documents.” -Doris Santangelo

“I was able to learn a lot from this course and to do so at my own pace. I was able to review areas where I needed more time than someone more advanced than I. For the monetary investment, this is a great course for beginners.” -David F. Wilson

“I have been using Excel for some time and this course has shown me just how much I did not know or was unaware of. A terrific learning experience. Thanks for the opportunity!” -Allan Thomson

“I enjoyed to course and it was presented in an orderly fashion with incremental information that gave an intuitive feel to the progression. Thank you.” -John Brown

“Course is well done and since you can go back and review at any time or after the course is done is helpful for us slow learners.” -Rick Clarke


Course curriculum

  • 1

    Introduction

    • Acquiring Excel 2016 and Information on Installation and Upgrade

    • 01-02-excel2016-course-files-and-exercise-files

  • 2

    What's New

    • New and Improved Features in Excel 2016

  • 3

    Getting Started

    • Creating and Saving a Workbook

    • Opening a Workbook

  • 4

    Using Help

    • Online Help and Contextual Help

    • Online Help and Contextual Help

  • 5

    Excel Options

    • Personalizing your use of Excel

  • 6

    The Ribbon and Toolbars

    • Basics of using the Ribbon

    • Quick Access Toolbar

    • Tell Me Feature

    • Mini Toolbars and Contextual Menus

    • Status Bar

  • 7

    Entering and Editing Data

    • Basics of Entering and Editing Data in a Workbook

    • Exercise 01

    • Formatting Dates

    • Formatting Numbers

    • Exercise 02

  • 8

    Backup and Recovery

    • AutoSave, Recover Unsaved Workbook, and Create a Backup Copy

  • 9

    Fill and Series

    • Working with Fill and Series

    • Flash Fill

  • 10

    Viewing and Printing

    • Workbook Views, Zoom, and Freeze

    • Printing

    • Exercise 03

  • 11

    Cut, Copy, and Paste

    • Methods of Cutting, Copying, and Pasting

  • 12

    Formatting a Worksheet

    • Delete and Clear

    • Insert, Hide, Column Width and Row Height, and Merge

    • Alignment

    • Themes and Styles

    • Exercise 04

  • 13

    Formulas and Functions

    • Basics of Formulas and Functions

    • Complex Examples of Formulas

    • Exercise 05

  • 14

    Managing Worksheets

    • Rename, Insert, Move, and Reference a Worksheet

  • 15

    Working with Multiple Workbooks

    • Working with Multiple Workbooks

  • 16

    Saving Workbooks

    • Saving in Different File Types

  • 17

    Proofing

    • The Spell Checker

  • 18

    Inserting Comments

    • Inserting Comments

    • Exercise 06

  • 19

    Basic Functions in Excel

    • The VLOOKUP Function

    • Text Functions

    • Date and Time Functions

    • Logical Functions

  • 20

    Graphs and Charts

    • Creating Graphs and Charts

    • Customizing a Cluster Column Chart

    • Customizing a Pie Chart

    • New Chart Types in Excel 2016

    • Exercise 7

  • 21

    Sorting and Filtering Data

    • Managing Data by Sorting

    • Managing Date by Filtering

    • Customizing Tables

  • 22

    Shapes and Pictures

    • Inserting Shapes and Pictures

    • Exercise 08

  • 23

    Formatting Cells Based on Conditional Formatting

    • Conditional Formatting

  • 24

    Protection and Security

    • Protecting Worksheets

    • Protecting Workbooks

  • 25

    Naming Items

    • Giving Items Names

    • Exercise 09

  • 26

    Finding and Replacing Words

    • Find and Replace

  • 27

    Borders

    • Borders

  • 28

    Workbook Inspection

    • Inspecting a Workbook

  • 29

    Privacy Options

    • Trust Center Privacy Options

  • 30

    Sharing Options

    • Sharing a Workbook

  • 31

    Conclusion

    • Conclusion

  • 32

    Course & Exercise Files

    • Course Files

    • Exercise Files