Microsoft Excel 2016 for Beginners: Master the Essentials

194 Enrolled

9 Hours

$15.00$100.00

You save 85%

65 Lessons (9h)

Introduction
Acquiring Excel 2016 and Information on Installation and Upgrade12:02
Exercise Files2:28
Course exercise files
Course demo files
What's New
New and Improved Features in Excel 20162:55
Using Touch
Overview of Principles of Using Touchscreen5:36
Getting Started
Creating and Saving a Workbook15:16
Opening a Workbook10:13
Using Help
Online Help and Contextual Help6:27
Excel Options
Personalizing your use of Excel10:50
The Ribbon and Toolbars
Basics of using the Ribbon14:56
Quick Access Toolbar5:45
Tell Me Feature6:49
Mini Toolbars and Contextual Menus3:47
Status Bar5:02
Entering and Editing Data
Basics of Entering and Editing Data in a Workbook13:29
Exercise 011:50
Formatting Dates12:36
Formatting Numbers13:48
Exercise 021:43
Backup and Recovery
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy7:35
Fill and Series
Working with Fill and Series9:09
Flash Fill4:04
Viewing and Printing
Workbook Views, Zoom, and Freeze8:41
Printing14:30
Exercise 032:56
Cut, Copy, and Paste
Methods of Cutting, Copying, and Pasting13:32
Formatting a Worksheet
Delete and Clear13:45
Insert, Hide, Column Width and Row Height, and Merge12:46
Alignment12:05
Themes and Styles11:19
Exercise 041:44
Formulas and Functions
Basics of Fomulas and Functions11:15
Complex Examples of Formulas13:36
Exercise 053:26
Managing Worksheets
Rename, Insert, Move, and Reference a Worksheet8:40
Working with Multiple Workbooks
Working with Multiple Workbooks15:48
Saving Workbooks
Saving in Different File Types12:59
Proofing
The Spell Checker13:11
Inserting Comments
Inserting Comments4:54
Exercise 063:02
Basic Functions in Excel
The VLOOKUP Function14:07
Text Functions8:17
Date and Time Functions6:47
Logical Functions15:51
Graphs and Charts
Creating Graphs and Charts12:10
Customizing a Cluster Column Chart15:42
Customizing a Pie Chart13:36
New Chart Types in Excel 20162:01
Exercise 72:28
Sorting and Filtering Data
Managing Data by Sorting9:39
Managing Date by Filtering11:59
Customizing Tables13:23
Shapes and Pictures
Inserting Shapes and Pictures15:00
Exercise 080:47
Formatting Cells Based on Content
Conditional Formatting15:32
Protection and Security
Protecting Worksheets9:36
Protecting Workbooks10:21
Naming Items
Giving Items Names6:31
Exercise 090:47
Finding and Replacing Words
Find and Replace7:10
Borders
Adding Borders10:44
Workbook Inspection
Inspecting a Workbook6:08
Privacy Options
Trust Center Privacy Options5:46
Sharing Options
Sharing a Workbook8:30
Conclusion
Course Conclusion and Closing0:56
Course Quiz
Microsoft Excel 2016 Quiz

DescriptionInstructorImportant DetailsRelated Products

Master the Essentials of Microsoft Excel 2016 in This Easy-to-Follow Course

SimonSezItSince 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 70+ courses and 3,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free e-learning and enhanced employee productivity – whether you’re implementing new software or a technological upgrade for your workplace. With over 225,000 Udemy students in over 180 countries, Simon Sez IT is the preferred e-learning choice for individuals and businesses everywhere.

Description

Microsoft Excel 2016 is the newest, most advanced version of the world's leading spreadsheet software. This course assumes you have never worked with any version of Excel, and will take you from a complete beginner to a wizard with the most up-to-date features available. By course's end, you'll have a valuable new bullet point on your resume.

Access 65 lectures & 9 hours of content 24/7
Install & run Microsoft Excel 2016 for the first time
Use Touchscreen, open a Workbook, & use Help to get additional answers when you need them
Personalize Excel for your own use
Discuss all Ribbons & Toolbars, entering & editing data, backup & recovery, & more
Practice w/ included exercise files

Specs

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: beginner

Compatibility

Internet required

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your Cart

Your cart is empty. Continue Shopping!

Processing order...