Microsoft Office 2016 Essentials: 5 Course Bundle

Learn Microsoft Office 2016 the easy way with this comprehensive, 5-course bundle. Includes Excel (basic & advanced), Wo

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I Learn?

• Discover new and improved features in Excel 2016, Word, PowerPoint & Outlook.
• Excel: Learn to personalize Excel in Excel Options.
• Excel: The Quick Access Toolbar.
• Excel: Data entry, cell formatting, working with multiple worksheets and the Ribbon.
• Excel: Backup and recover your Excel spreadsheets - never lose a file again.
• Excel: AutoFill & Flash Fill.
• Excel: How and when to use formulas and functions.
• Excel: How to sort and filter your data
• Excel: How to password protect and secure your data
• Adv Excel: Discover common Excel hotkeys
• Adv Excel: How to use VLOOKUP and HLOOKUP
• Adv Excel: IF, COUNTIF, SUMIF and other logical functions
• Adv Excel: Using named ranges
• Adv Excel: The power of Dynamic Formulas and how to use them
• Adv Excel: Advanced level charts and graphs
• Adv Excel: Analyzing data using PivotTables, Slicers, Power Query and PivotCharts
• PowerPoint: Presentation tips for an amazing presentation
• PowerPoint: Format text like a pro
• PowerPoint: Insert charts, graphics and pictures to add some "zing" to your presentation
• PowerPoint: Wow your audience by adding animations, audio and video
• PowerPoint: Time saving techniques including duplicating slides, and exporting your presentation
• Word: How to control page appearance including using columns, indents, footers, borders and watermarks
• Word: How to create a mail merge
• Word: Printing, including on envelopes and labels
• Word: How to protect your document
• Word: To spell check
• Word: Insert pictures and graphics in your Word document
• Word: How to insert and edit tables
• Outlook: To use Outlook on touchscreens
• Outlook: Keyboard shortcuts to increase your productivity
• Outlook: Calendar management and organization
• Outlook: Maintaining contacts, address books and groups
• Outlook: Messaging basics and inbox organisation
• Outlook: Creating and managing tasks and rules
• Outlook: How to Mail Merge

Requirements

• Microsoft Office 2016 desktop version for Windows installed and ready to use on your computer.

Target audience

• Those new to using Microsoft Excel, PowerPoint, Outlook and Word 2016
• Those looking to improve their existing skills in Microsoft Excel, PowerPoint, Outlook and Word 2016