# MS Office 2016 tutorial eBooks

Recently updated to Microsoft Office 2016? The 5 eBooks below will help you get up to speed with all the functions you have been using in the past or previous Microsoft Office versions and introduce you to new functions of Excel 2016, PowerPoint 2016 , Outlook 2016 and Word 2016.

## Excel 2016 Core Part One

This user guide will take you through all the things you need to know when using Excel at a simple level.

You will learn how to:

• Get around Excel 2016
• Add text and numbers to spreadsheets
• Use Autofill to copy formula and create series
• Create a basic formula
• Use Average Minimum and Maximum
• Work with Worksheets
• And much more

Download the Excel 2016 Core Part One eBook here!

## Excel 2016 Advanced

This user guide will introduce you to some of Excel’s more complex functionality. Specifically, when analysing data.

You will learn how to:

• Use Conditional Logic in a formula – IF statements
• Use the SumIF and CountIF functions
• Produce a chart
• Sort and filter
• Apply subtotals
• Introduction to Pivot Tables
• Introduction to Macros.

## PowerPoint 2016

This user guide will take you through all the things you need to know when using PowerPoint to create professional presentations.

You will learn how to:

1. Get around PowerPoint 2016
2. Add text, tables, pictures, SmartArt, charts and more to your slides
3. Use the Slide Master to control the way the presentation looks
4. Add Media – audio and video to your slides
5. Control slide transition
6. Add animation to objects
7. And a whole lot more.

## Word 2016

This guide will help you to be confident with the basic functions of Word 2016.

You will learn how to:

1. The Word 2016 Interface
2. Setting up the Document
3. Formatting & Styles
4. Headers and Footers
5. Quick Parts
6. References
7. Footnotes and Endnotes
8. Smart Lookup
9. Index
10. Images
11. Adding Shapes, Smart Art, Charts, Screenshots, and Videos
13. Bookmarks
14. Tables
15. Mailings
16. Reviewing your Document

… and much more!

## Outlook 2016

This user guide will enable you to save time when working in Outlook 2016.

You will learn how to:

1. Create folders to keep your email tidy
2. See how Outlook 2016 handles attachments
3. Use QuickSteps to do things such as filing or creating standard emails speedily
4. Add appointments – all day events and Scheduled Meetings
6. Perform an email mail merge
7. Shortcuts for working with email and calendar
8. Learn how to use Groups to collaborate with others