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.

Find it here on bookboon.com

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: Get around PowerPoint 2016, Add text, tables, pictures, SmartArt, charts and more to your slides. Use the Slide Master to control the way the presentation looks, Add Media – audio and video to your slides, Control slide transition, Add animation to objects, And a whole lot more.

Find it here on bookboon.com

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.

Find it here on bookboon.com

Excel 2013 Core Intro

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 2013, 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.

Find it here on bookboon.com

Excel 2013 Core 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.

Find it here on bookboon.com

Project 2013 Essentials

Microsoft 2013 Essentials has been written to accompany our two day Microsoft Project 2013 Essentials classroom course. In this course you will learn: How to set up a project from scratch, The four things you must do before you add any tasks to a project, Add tasks, durations and adjust settings, The difference between Manual and Automatic tasks, How to add and schedule resources, Track a project once it starts.

Find it here on bookboon.com

Outlook 2013

This user guide will enable you to save time when working in Outlook 2013. You will learn how to: Create folders to keep your email tidy, Use QuickSteps to do things such as filing or creating standard emails speedily, Add appointments – all day events and Scheduled Meetings, Create Tasks Perform an email mail merge, Shortcuts for working with email and calendar.

Find it here on bookboon.com

PowerPoint 2013

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: Get around PowerPoint 2013, Add text, tables, pictures, SmartArt, charts and more to your slides, Use the Slide Master to control the way the presentation looks, Add Media – audio and video to your slides, Control slide transition, Add animation to objects, And a whole lot more.

Find it here on bookboon.com