Excel 2016 Beginners
New! Subscribe and get access to all over 20 classes for just $49/mo, or purchase this class a la carte
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
Acquiring Excel 2016 and Information on Installation and Upgrade
01-02-excel2016-course-files-and-exercise-files
New and Improved Features in Excel 2016
Creating and Saving a Workbook
Opening a Workbook
Online Help and Contextual Help
Online Help and Contextual Help
Personalizing your use of Excel
Basics of using the Ribbon
Quick Access Toolbar
Tell Me Feature
Mini Toolbars and Contextual Menus
Status Bar
Basics of Entering and Editing Data in a Workbook
Exercise 01
Formatting Dates
Formatting Numbers
Exercise 02
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
Working with Fill and Series
Flash Fill
Workbook Views, Zoom, and Freeze
Printing
Exercise 03
Methods of Cutting, Copying, and Pasting
Delete and Clear
Insert, Hide, Column Width and Row Height, and Merge
Alignment
Themes and Styles
Exercise 04
Basics of Formulas and Functions
Complex Examples of Formulas
Exercise 05
Rename, Insert, Move, and Reference a Worksheet
Working with Multiple Workbooks
Saving in Different File Types
The Spell Checker
Inserting Comments
Exercise 06
The VLOOKUP Function
Text Functions
Date and Time Functions
Logical Functions
Creating Graphs and Charts
Customizing a Cluster Column Chart
Customizing a Pie Chart
New Chart Types in Excel 2016
Exercise 7
Managing Data by Sorting
Managing Date by Filtering
Customizing Tables
Inserting Shapes and Pictures
Exercise 08
Conditional Formatting
Protecting Worksheets
Protecting Workbooks
Giving Items Names
Exercise 09
Find and Replace
Borders
Inspecting a Workbook
Trust Center Privacy Options
Sharing a Workbook
Conclusion
Course Files
Exercise Files