Microsoft Excel Powerpoint And Word 2016
Tags: Microsoft Word
The Most Convenient Way to Boost Your Confidence And Learn MS Office 2016 Inside And Out—Quickly, No Travel or Classes.
Last updated 2022-01-10 | 4.5
- Discover new and improved features in Excel 2016.- How to effectively use Excel 2016 on a touchscreen device.
- How create
- save
- and open a workbook.
What you'll learn
Discover new and improved features in Excel 2016.
How to effectively use Excel 2016 on a touchscreen device.
How create
save
and open a workbook.
Learn how to personalize your use of Excel using Excel Options.
How to use and how to customize the Quick Access Toolbar.
Complete data entry
cell formatting
working with multiple worksheets and the “Ribbon” interface.
The basics of entering and editing data in a workbook.
Discover how to format dates and numbers.
Learn practical methods in which you can backup and recover your Excel spreadsheets.
Effectively use autofill and flashfill so you are more productive.
Discover the essentials of using fomulas and functions.
How to rename
insert
move
and reference an Excel 2016 worksheet.
Discover how to create charts and graphs
Learn practical methods to sort and filter your data
How to protect and secure your Excel data
Practice what you learned with included exercise files
Discover new features in PowerPoint 2016
Learn presentation tips for an effective presentation
Discover how to format text on a PowerPoint slide
Add charts
graphs and tables to present information in a non-text format
Learn how to insert shapes
graphics and pictures to add some "zing" to your presentation
Wow your audience by adding animations
audio and video
Discover practical tips to present your presentation to your audience
Learn time saving techniques including how to copy slides
and exporting your presentation
Customize PowerPoint for greater productivity by customizing the Microsoft Office Ribbon
Master the most common uses of Word.
How to controlling page appearance including using columns
indents
footers
borders and watermarks.
Learn to create many types of documents.
How to create a mail merge.
Printing envelopes and labels.
Discover different page setup options.
How to protect your document from changes.
Learn how to spell check your documents.
Insert pictures and graphics in your Word document.
Discover how to insert and edit tables.
Using "Go To
Find
and Replace".
How to create
save and open documents.
* Requirements
* Microsoft Office 2016Description
- Discover new and improved features in Excel 2016.
- How to effectively use Excel 2016 on a touchscreen device.
- How create, save, and open a workbook.
- Learn how to personalize your use of Excel using Excel Options.
- How to use and how to customize the Quick Access Toolbar.
- Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
- The basics of entering and editing data in a workbook.
- Discover how to format dates and numbers.
- Learn practical methods in which you can backup and recover your Excel spreadsheets.
- Effectively use autofill and flashfill so you are more productive.
- Discover the essentials of using fomulas and functions.
- How to rename, insert, move, and reference an Excel 2016 worksheet.
- Discover how to create charts and graphs
- Learn practical methods to sort and filter your data
- How to protect and secure your Excel data
- Practice what you learned with included exercise files
- Discover new features in PowerPoint 2016
- Learn presentation tips for an effective presentation
- Discover how to format text on a PowerPoint slide
- Add charts, graphs and tables to present information in a non-text format
- Learn how to insert shapes, graphics and pictures to add some "zing" to your presentation
- Wow your audience by adding animations, audio and video
- Discover practical tips to present your presentation to your audience
- Learn time saving techniques including how to copy slides, and exporting your presentation
- Customize PowerPoint for greater productivity by customizing the Microsoft Office Ribbon
- Master the most common uses of Word.
- How to controlling page appearance including using columns, indents, footers, borders and watermarks.
- Learn to create many types of documents.
- How to create a mail merge.
- Printing envelopes and labels.
- Discover different page setup options.
- How to protect your document from changes.
- Learn how to spell check your documents.
- Insert pictures and graphics in your Word document.
- Discover how to insert and edit tables.
- Using "Go To, Find, and Replace".
- How to create, save and open documents.
Course content
69 sections • 290 lectures
Acquiring Excel 2016 and Information on Installation and Upgrade Preview 12:02
WATCH ME: Essential Information for a Successful Training Experience Preview 02:11
Course Exercise Files Preview 00:23
Course Demo Files Preview 00:23
Downloadable Course Transcripts Preview 00:19
Section 1 Quiz
New and Improved Features in Excel 2016 Preview 02:55
Overview of Principles of Using Touchscreen Preview 05:36
Creating and Saving a Workbook Preview 15:16
Opening a Workbook Preview 10:13
Online Help and Contextual Help Preview 06:27
Section 5 Quiz
Personalizing your use of Excel Preview 10:50
Section 6 Quiz
Basics of using the Ribbon Preview 14:56
Quick Access Toolbar Preview 05:45
Tell Me Feature Preview 06:49
Mini Toolbars and Contextual Menus Preview 03:47
Status Bar Preview 05:02
Section 7 - Quiz
Basics of Entering and Editing Data in a Workbook Preview 13:29
Exercise 01 Preview 01:50
Formatting Dates Preview 12:36
Formatting Numbers Preview 13:48
Exercise 02 Preview 01:43
Section 8 - Quiz
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy Preview 07:35
Section 9 - Quiz
Workbook Views, Zoom, and Freeze Preview 08:41
Printing Preview 14:29
Exercise 03 Preview 02:55
Section 11 - Quiz
Methods of Cutting, Copying, and Pasting Preview 13:32
Section 12 - Quiz
Delete and Clear Preview 13:45
Insert, Hide, Column Width and Row Height, and Merge Preview 12:46
Alignment Preview 12:05
Themes and Styles Preview 11:19
Exercise 04 Preview 01:44
Section 13 - Quiz
Basics of Formulas and Functions Preview 11:15
Complex Examples of Formulas Preview 13:36
Exercise 05 Preview 03:25
Section 14 - Quiz
Rename, Insert, Move, and Reference a Worksheet Preview 08:40
Section 15 - Quiz
Working with Multiple Workbooks Preview 15:48
Section 16 - Quiz
Saving in Different File Types Preview 12:58
Section 17 - Quiz
The Spell Checker Preview 13:11
Inserting Comments Preview 04:54
Exercise 06 Preview 03:01
The VLOOKUP Function Preview 14:06
Text Functions Preview 08:17
Date and Time Functions Preview 06:47
Logical Functions Preview 15:51
Section 20 - Quiz
Creating Graphs and Charts Preview 12:10
Customizing a Cluster Column Chart Preview 15:41
Customizing a Pie Chart Preview 13:35
New Chart Types in Excel 2016 Preview 02:01
Exercise 07 Preview 02:28
Section 21 - Quiz
Managing Data by Sorting Preview 09:39
Managing Date by Filtering Preview 11:59
Customizing Tables Preview 13:23
Section 22 - Quiz
Conditional Formatting Preview 15:32
Section 24 - Quiz
Protecting Worksheets Preview 09:35
Protecting Workbooks Preview 10:21
Giving Items Names Preview 06:30
Exercise 09 Preview 02:10
Finding and Replacing Words Preview 07:09
Section 27 - Quiz
Adding Borders Preview 10:44
Section 28 - Quiz
Inspecting a Workbook Preview 06:08
Trust Center Privacy Options Preview 05:46
Sharing a Workbook Preview 08:30
Section 31 - Quiz
Welcome and Overview Preview 02:09
WATCH ME: Essential Information for a Successful Training Experience Preview 02:03
PowerPoint 2016 Course Exercise Files Preview 00:23
The PowerPoint 2016 exercise/example files consist of a single .ZIP file. You will need to download the PPT 2016 Exercise Files.zip file to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. Once unzipped, all of the exercise/example files will reside in one folder.