Microsoft Excel

Overview

This range of training courses will focus on equipping delegates with a good understanding of the functions of Microsoft Excel, and can be delivered either on a 1:1 or group basis.   You can choose on expending your experience in three different ways:-

• Excel Basics
• Moving on from the Basics
• Intermediate to Advanced

The level will depend on the experience of the delegates working with Excel,  By the end of this course, delegates will be able to:-

• Demonstrate the main functions of Microsoft Excel
• Successfully implement the use of Excel into their working role

Content

The course can be tailored to meet your specific requirements and deal with any issues you may wish to address. To give you an idea of the course content, we could cover the following areas for you.

• Working with Large Worksheets
• Navigating Worksheets & Workbooks
• Viewing Options
• Page Break Preview
• Hiding & displaying data
• Printing large Worksheets
• Freeze and Split Panes
• Multiple Worksheets/Workbooks
• Inserting sheets
• Renaming sheets
• Copying sheets
• 3D formulas to link sheets
• Consolidating data
• Linking Workbooks
• Recap Formulas
• Relative & absolute referencing
• Averages, minimum & maximum
• Paste functions
• Conditional Formatting
• Formatting the Worksheet
• Adding Borders & Shading
• AutoFormats
• Copying Formats
• Text Formatting
• Working with dates
• Using Special Number Formats
• Indented lists
• Merge & Centre
• Functions and Orders
• SUM, COUNT, AVERAGE, COUNTIF, SUMIF
• V, H and X Lookups
• IF Statements and IFERROR
• Index and Index Match
• PIVOT Tables
• Slicers
• Data Validation
• Macros