Microsoft Office Training (The Complete MS Office Course)

Description

In this course, you will :

• 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.

• 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

• Discover new features in PowerPoint 2016

• Learn presentation tips for an effective presentation

• Discover how to format text on a PowerPoint slide

• Learn how to insert shapes, graphics and pictures to add some "zing" to your presentation

• Add charts, graphs and tables to present information in a non-text format

• 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

• Learn cool tips and tricks in the Ribbon

• Discover common Excel hotkeys

• How to use VLOOKUP and HLOOKUP

• Learn how to use popular functions

• Discover how to use named ranges

• Discover the power of Dynamic Formulas and how to use them

• Get advanced level tips for creating awesome charts and graphs

• How to work with and analyze your data using data slicers, PivotTables, Power Query and PivotCharts

• Setting up email accounts

• Using Outlook on a touch device

• 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