Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Master Excel 2016 For Complete Beginners In This Helpful, Info-Packed Video Course
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 32 chapters of video lessons and 9 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 formulas, functions, sorting and filtering data, creating charts and graphs, and much more.
Upon completion of this course you will know the essentials of Microsoft Excel 2016.
*** Updated February 2016. Course transcripts now available.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Acquiring Excel 2016 and Information on Installation and UpgradePreview
IMPORTANT - Read this to ensure the best video quality!
Course exercise files
Course demo files
Downloadable Course Transcripts
Section 1 Quiz
|Section 2: What's New|
New and Improved Features in Excel 2016Preview
|Section 3: Using Touch|
Overview of Principles of Using TouchscreenPreview
|Section 4: Getting Started|
Creating and Saving a WorkbookPreview
Opening a Workbook
|Section 5: Using Help|
Online Help and Contextual Help
Section 5 Quiz
|Section 6: Excel Options|
Personalizing your use of Excel
Section 6 Quiz
|Section 7: The Ribbon and Toolbars|
Basics of using the RibbonPreview
Quick Access Toolbar
Tell Me Feature
Mini Toolbars and Contextual Menus
Section 7 Quiz
|Section 8: Entering and Editing Data|
Basics of Entering and Editing Data in a Workbook
Section 8 Quiz
|Section 9: Backup and Recovery|
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
Section 9 Quiz
|Section 10: Fill and Series|
Working with Fill and SeriesPreview
Section 10 Quiz
|Section 11: Viewing and Printing|
Workbook Views, Zoom, and Freeze
Section 11 Quiz
|Section 12: Cut, Copy, and Paste|
Methods of Cutting, Copying, and Pasting
Section 12 Quiz
|Section 13: Formatting a Worksheet|
Delete and Clear
Insert, Hide, Column Width and Row Height, and Merge
Themes and Styles
Section 13 Quiz
|Section 14: Formulas and Functions|
Basics of Fomulas and FunctionsPreview
Complex Examples of Formulas
Section 14 Quiz
|Section 15: Managing Worksheets|
Rename, Insert, Move, and Reference a Worksheet
Section 15 Quiz
|Section 16: Working with Multiple Workbooks|
Working with Multiple WorkbooksPreview
Section 16 Quiz
|Section 17: Saving Workbooks|
Saving in Different File Types
Section 17 Quiz
|Section 18: Proofing|
The Spell Checker
|Section 19: Inserting Comments|
|Section 20: Basic Functions in Excel|
The VLOOKUP FunctionPreview
Date and Time Functions
Section 20 Quiz
|Section 21: Graphs and Charts|
Creating Graphs and ChartsPreview
Customizing a Cluster Column Chart
Customizing a Pie Chart
New Chart Types in Excel 2016
Section 21 Quiz
|Section 22: Sorting and Filtering Data|
Managing Data by SortingPreview
Managing Date by Filtering
Section 22 Quiz
|Section 23: Shapes and Pictures|
Inserting Shapes and Pictures
Section 23 Quiz
|Section 24: Formatting Cells Based on Content|
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.