Master Excel 2016 for complete beginners in this helpful, info-packed video course
About This Video
In Detail
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 at the very beginning: …
Master Excel 2016 for complete beginners in this helpful, info-packed video course
About This Video
In Detail
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 at the very beginning: installing the program, creating your first workbook, and entering data. Before you know it, you'll be using Excel 2016 like a pro, including its 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.
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.
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 the 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, fills and series, and printing your projects. We also work with worksheets and formulas/functions.
Upon completion of this course, you will know the essentials of Microsoft Excel 2016.
Chapter 1 : Introduction
Acquiring Excel 2016 and Information on Installation and Upgrade 00:12:02
Exercise Files 00:02:28
Chapter 2 : What’s New
New and Improved Features in Excel 2016 00:02:56
Chapter 3 : Using Touch
Overview of Principles of Using Touchscreen 00:05:36
Chapter 4 : Getting Started
Creating and Saving a Workbook 00:15:16
Opening a Workbook 00:10:13
Chapter 5 : Using Help
Online Help and Contextual Help 00:06:28
Chapter 6 : Excel Options
Personalizing your use of Excel 00:10:50
Chapter 7 : The Ribbon and Toolbars
Basics of using the Ribbon 00:14:56
Quick Access Toolbar 00:05:46
Tell Me Feature 00:06:50
Mini Toolbars and Contextual Menus 00:03:47
Status Bar 00:05:03
Chapter 8 : Entering and Editing Data
Basics of Entering and Editing Data in a Workbook 00:13:30
Exercise 01 00:01:51
Formatting Dates 00:12:36
Formatting Numbers 00:13:48
Exercise 02 00:01:43
Chapter 9 : Backup and Recovery
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy 00:07:35
Chapter 10 : Fill and Series
Working with Fill and Series 00:09:09
Flash Fill 00:04:05
Chapter 11 : Viewing and Printing
Workbook Views, Zoom, and Freeze 00:08:42
Printing 00:14:30
Exercise 03 00:02:56
Chapter 12 : Cut, Copy, and Paste
Methods of Cutting, Copying, and Pasting 00:13:32
Chapter 13 : Formatting a Worksheet
Delete and Clear 00:13:45
Insert, Hide, Column Width and Row Height, and Merge 00:12:47
Alignment 00:12:05
Themes and Styles 00:11:19
Exercise 04 00:01:44
Chapter 14 : Formulas and Functions
Basics of Formulas and Functions 00:11:15
Complex Examples of Formulas 00:13:37
Exercise 05 00:03:26
Chapter 15 : Managing Worksheets
Worksheet 00:08:40
Chapter 16 : Working with Multiple Workbooks
Working with Multiple Workbooks 00:15:49
Chapter 17 : Saving Workbooks
Saving in Different File Types 00:12:59
Chapter 18 : Proofing
The Spell Checker 00:13:12
Chapter 19 : Inserting Comments
Inserting Comments 00:04:55
Exercise 06 00:03:02
Chapter 20 : Basic Functions in Excel
The VLOOKUP Function 00:14:07
Text Functions 00:08:17
Date and Time Functions 00:06:48
Logical Functions 00:15:51
Chapter 21 : Graphs and Charts
Creating Graphs and Charts 00:12:10
Customizing a Cluster Column Chart 00:15:42
Customizing a Pie Chart 00:13:36
New Chart Types in Excel 2016 00:02:01
Exercise 7 00:02:28
Chapter 22 : Sorting and Filtering Data
Managing Data by Sorting 00:09:39
Managing Date by Filtering 00:11:59
Customizing Tables 00:13:24
Chapter 23 : Shapes and Pictures
Inserting Shapes and Pictures 00:15:01
Exercise 08 00:00:47
Chapter 24 : Formatting Cells Based on Content
Conditional Formatting 00:15:32
Chapter 25 : Protection and Security
Protecting Worksheets 00:09:36
Protecting Workbooks 00:10:21
Chapter 26 : Naming Items
Giving Items Names 00:06:31
Exercise 09 00:02:11
Chapter 27 : Finding and Replacing Words
Find and Replace 00:07:10
Chapter 28 : Borders
Adding Borders 00:10:44
Chapter 29 : Workbook Inspection
Inspecting a Workbook 00:06:08
Chapter 30 : Privacy Options
Trust Center Privacy Options 00:05:46
Chapter 31 : Sharing Options
Sharing a Workbook 00:08:31
Chapter 32 : Conclusion
Conclusion and Close 00:00:30