Microsoft Office 2016 Essential Training: 9 Course Bundle
What you'll learn
- Discover new and improved features in Excel 2016, Word, PowerPoint, OneNote & Access.
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
- 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
Requirements
- Microsoft Office 2016 desktop version for Windows installed and ready to use on your computer.
We Are Turning You Into A Software Savvy From The Convenience Of Your Home!
You don’t have to spend a fortune on classes anymore; you can save yourself the time spent on commuting to training institutes!
We are making hands-on knowledge of 9 training courses a breeze, teaching you in your own SELF- PACED learning environment:
- Microsoft Excel 2016 - Beginners
- Microsoft Excel 2016 - Advanced
- Microsoft Word 2016
- Microsoft OneNote 2013:
- Microsoft PowerPoint 2016:
- Microsoft Access 2016 – Beginners
- Microsoft Access 2016 – Advanced
- Microsoft Essential VBA for Excel
- VBA Intermediate Training- Discover Excel Automation Secrets
Why Take This Course
Most work today happens on a computer – optimize your effort by learning useful software tips and tricks that you'll apply for decades to come! And that will save you valuable time, money and effort.
Want to get noticed by your boss or earn the respect of your colleagues? Become the office superstar by becoming the go-to expert on everything related to MS Office 2016!
Individual video training for these programs would easily cost hundreds of dollars, but this 9-in-1 package is available at one unbelievably low price. Tremendous learning at tremendous savings.
Who this course is for:
- Those new to using Microsoft Access, Excel, OneNote PowerPoint, and Word 2016
- This course is created for absolute beginners.
- If you want to refresh your memory and understanding of Access, Excel, OneNote, Word and PowerPoint