Microsoft Excel Intermediate

Microsoft Excel Intermediate

Cost

£135+VAT

Next Date

16/01/2019

Duration

One Day

Microsoft Excel Intermediate

Course Description

This one-day course has been designed for existing users who wish to increase their Excel skill level.

Course Objectives

By the end of the course, you will be confident in going beyond the basic features in Excel

Course Content

Review of the basics
Formula and function construction | Shortcuts | Navigation and selection

Creating and working with charts
Creating a chart | Resizing and moving a chart | Changing chart type | Applying built-in chart layouts and styles | Working with chart labels | Working with chart axis | Working with chart backgrounds | Formatting chart elements | Changing a chart’s source data | Using chart templates

Managing Workbooks
Viewing a Workbook | Working with the Workbook window | Splitting and freezing a Workbook window | Selecting Worksheets in a Workbook | Inserting and deleting Worksheets | Renaming, moving and copying Worksheets | Working with multiple Workbooks | Linking between Worksheets and Workbooks | Hiding rows, columns, Worksheets and windows | Protecting a Workbook | Protecting Worksheets and Worksheet elements | Sharing a Workbook | Creating a template

Working with Page Layout and Printing
Creating headers and footers | Using page breaks | Adjusting margins and orientation | Adjusting size and scale | Adjusting print tiles, gridlines and headings | Advanced printing options

More functions and formulas
Formulas with multiple operators | Logical formulae – introduction to simple IF statements | Lookup formulae – introduction to VLOOKUP function | Inserting and editing a function | Defining names | Using and managing defined names | Working with data ranges | Sorting by one column | Sorting by colours or icons | Sorting by multiple columns | Sorting by a custom list | Filtering data | Creating a custom AutoFilter | Using an advanced filter

Working with lists
Creating a list/table | Working with table size | Working with the total row | Working with table data | Using the data form | Using table styles Using table style options | Creating and deleting custom table styles | Convert or delete a table

Related courses

Microsoft Excel Introduction

Microsoft Word Intermediate

Microsoft Excel Advanced

BOOK THIS COURSE

Simply complete the form below and we'll come back to you as soon as possible

BOOK THIS COURSE

Simply complete the form below and we'll come back to you as soon as possible