Microsoft Excel Outlook And Word 2016 Training For Beginners
Tags: Microsoft Office
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.
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.
Setting up email accounts.
Creating and sending email messages.
Organizing email.
Calendar appointments and attachments.
Create and manage meetings.
Adding email signatures.
How to archive email.
Spam and junk mail removal.
Creating and managing tasks and reminders.
Using the mail merge feature to import contact information to Microsoft Word.
Adding
managing and searching contacts in the address book.
Creating filters to automate incoming messages.
Practice what you learned with included exercise files.
* Requirements
* Microsoft Office 2016 desktop version for Windows installed and ready to use on your computer.Description
- 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.
- 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.
- Setting up email accounts.
- Creating and sending email messages.
- Organizing email.
- Calendar appointments and attachments.
- Create and manage meetings.
- Adding email signatures.
- How to archive email.
- Spam and junk mail removal.
- Creating and managing tasks and reminders.
- Using the mail merge feature to import contact information to Microsoft Word.
- Adding, managing and searching contacts in the address book.
- Creating filters to automate incoming messages.
- Practice what you learned with included exercise files.
Course content
66 sections • 277 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 Fomulas 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
Find and Replace 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
Introduction to the Course Preview 06:59
WATCH ME: Essential Information for a Successful Training Experience Preview 02:11
Course Exercise Files Preview 00:23
Course Demo Files Preview 00:23
Acquring Outlook 2016 Preview 13:54
What's New Preview 08:27
Section 35 - Quiz
Starting Outlook 2016 Preview 06:58
Using Touch Preview 09:51
Outlook 2016 Interface Preview 13:32
Getting Help Preview 10:54
Keyboards Shortcuts and Keytips Preview 07:28
Outlook Options Preview 10:38
Secton 34 - Quiz
Setting Up an Account Preview 07:03
Sending and Receiving Email Preview 13:40
Calendar Basics Preview 16:00
Exercise 01 Preview 01:55
People Preview 12:42
Task Basics Preview 12:46
Notes Preview 08:18
Section 35 - Quiz
Customizing the Ribbon and Quick Access Toolbars Preview 10:16
Exercise 02 Preview 02:36
Section 36 - Quiz
Outlook Data Files and Their Properties Preview 12:58
Managing Accounts Preview 14:27
Managing Folders Preview 14:37
Exercise 03 Preview 03:12
Backup and Restore a PST file Preview 06:03
Section 37 - Quiz
Contact Records Preview 08:49
Maintaning Contact Information Preview 11:16
Contact Views Preview 11:36
Using Contact Information Preview 10:48
Address Books Preview 16:06
Contact Groups Preview 07:36
Exercise 04 Preview 00:59
Printing Contact Information Preview 09:09
Section 38 - Quiz
Sending Messages Preview 15:03
Receiving Messages Preview 15:49
Replying to Messages Preview 08:21
Touch Action Bar Preview 05:33
Organizing Folder Contents Preview 11:38
Junk Email Preview 16:44
Security & Trust Center Preview 10:10
Exercise 05 Preview 02:44
Section 39 - Quiz
Archiving Preview 11:00
Section 40 - Quiz
Calendar Setup Preview 11:48
Viewing & Sharing Calendars Preview 15:23
Calendar Item Management Preview 13:24
Managing Meetings Preview 11:57
Calendar Events Preview 05:38
To-do Bar Preview 07:40
Printing Calendar Information Preview 05:42
Exercise 06 Preview 03:58
Section 41 - Quiz
Color Categories Preview 10:31
Section 42 - Quiz
Creating & Managing Rules Preview 09:58
Quick Steps Preview 09:08
Exercise 07 Preview 02:40
Section 44 - Quiz
Email Features Preview 15:16
Proofing Features Preview 10:37
Formatting Themes and Styles Preview 13:54
Signatures and Stationery Preview 06:54
Saving and Printing an Email Preview 06:11
Exercise 08 Preview 03:25
Section 45 - Quiz
Searching Contacts and Other Items Preview 15:41
Section 46 - Quiz
Office Updates; Conclusion Preview 04:53
Welcome and Overview Preview 02:01
WATCH ME: Essential Information for a Successful Training Experience Preview 02:03
Course exercise files Preview 00:23
What's New in Word 2016 Preview 05:40
Overview of MS Word Screen Preview 08:07
Backstage View Preview 03:11
Creating a New Blank Document Preview 06:54
Working with Non-Printing Characters and Line Spacing Basics Preview 07:44
Saving a Document Preview 05:20
Opening a Document Preview 04:38
Navigating in a Document Preview 02:19
Go To, Find, and Replace Preview 07:22
Editing a Document Preview 02:09
Practice Exercise Preview 01:28
Section 50: Quiz
AutoCorrect Options Preview 08:43
Selecting text Preview 05:34
Cut, Copy & Paste Preview 05:31
Character Formatting Options Preview 08:43
Format Painter Preview 02:16
Working with numbers Preview 06:20
Working with bullets Preview 05:13
Creating an Outline Preview 06:33
Practice Exercise Preview 02:42
Alignment Options Preview 02:22
Line Spacing Options Preview 04:36
Working with Indents Preview 04:00
Working with Tabs Preview 10:12
Practice Exercise Preview 01:35
Section 52 - Quiz
Sorting a List Preview 04:33
Working with Tables Preview 02:30
Creating a Table Preview 05:03
Adding Rows and Columns to a Table Preview 04:03
Formatting Table Data Preview 08:01
Borders & Shading Preview 09:19
Sorting in a Table Preview 05:08
Drawing a Table Preview 05:33
Converting Existing Data to a Table Preview 03:19
Quick Tables Preview 04:18
Using Formula in Tables Preview 05:21
Practice Exercise Preview 01:15
Section 54 - Quiz
Working with Styles Preview 03:26
Creating Styles Preview 06:27
Editing Styles Preview 05:45
Practice Exercise Preview 01:18
Section 55 - Quiz
Working with Page Breaks Preview 03:41
Working with Columns Preview 05:43
Adding a Watermark Preview 02:50
Applying Page Borders Preview 03:10
Headers & Footers Preview 09:32
Practice Exercise Preview 01:10
Section 56 - Quiz
What is Sectioning? Preview 03:02
Sectioning a Document Preview 08:57
Odd and Even Sections Preview 02:25
Practice Exercise Preview 02:43
Section 57 - Quiz
Inserting Pictures Preview 02:13
Inserting Pictures into Existing Documents Preview 03:34
Picture Options Preview 07:03
Working with Shapes Preview 08:25
Other Graphic Options Preview 08:04
Practice Exercise Preview 01:12
Section 58 - Quiz
What is Mail Merge? Preview 03:17
Creating a Mail Merge Document - Part 1 Preview 10:15
Creating a Mail Merge Document - Part 2 Preview 08:51
Merging a Document with an Existing Data Source Preview 03:40
Sorting and Filtering Images Preview 05:08
Merging Envelopes and Labels Preview 04:43
Merging a Directory Preview 02:52
Practice Exercise Preview 02:01
Section 60 - Quiz
Building Blocks Preview 03:58
Creating and Editing Building Blocks Preview 03:43
Auto Text Preview 02:35
Practice Exercise Preview 01:27
Section 61 - Quiz
Creating an Index Preview 04:44
Creating a Table of Contents Preview 04:30
Practice Exercise Preview 02:16
Section 62 - Quiz
Using the Thesaurus Preview 01:33
Spell Check Preview 03:24
Comments Preview 03:04
Margins Preview 03:38
Page Setup Options Preview 03:36
Printing Preview 02:50
Practice Exercise Preview 01:19
Section 63 - Quiz
EXTRA LESSON: Designing Better Spreadsheets Webinar Recording Preview 01:04:55
EXTRA LESSON: Data Cleaning in Excel Webinar Recording Preview 52:26
EXTRA LESSON: Top Ten Excel Functions You HAVE to Know Webinar Recording Preview 01:11:18
EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic Preview 00:01
EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic Preview 00:01
EXTRA RESOURCE: The Most Frequently Used Outlook Shortcuts - Infographic Preview 00:00
This course includes:
- 29.5 hours on-demand video
- Access on mobile and TV
- Certificate of completion
Related Courses
Recent Posts
What is Cryptocurrency? Career Options, Salary and Demand
Cryptocurrency – a digital currency with the help of which you can purchase services and goods online. It uses an online register that has strong ...Read more
Excellent courses for learning SQL
The world is becoming more data-driven every day. Businesses run on data. We make decisions based on data. It plays a significant role in our ...Read more
Tips to help criminology majors excel in their field
After all is said and done, our society is an amalgam of good and bad and we need experts to keep us safe from the ...Read more
How to Know When It’s Time to Change Jobs?
Without a doubt, it’s a one tough and incremental journey to find a fulfilling career. Especially when there’s so much hustle and bustle around, when ...Read more
Top-choice online baseball courses for beginners
Today, with baseball becoming more and more popular with the world, it seems that many people need to learn it is a common thing in ...Read more
