Our introduction to Microsoft Excel training course is suitable for complete beginners to Microsoft Excel.  At the end of this training course you will have a good working knowledge of Microsoft Excel basics. You will feel more confident using Microsoft Excel and be able to create a spreadsheet from scratch.

Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments. Microsoft Excel spreadsheets that you create will be easier to use and look presentable.  Those who complete the Introduction to Microsoft Excel course satisfactorily will receive a certificate at the end of the computer training course.

Read on for further information on the Introduction to Excel training course. For more information on our computer course trainers, and computer training course content and fees visit this computer training courses information page

Creating Workbooks
• Enter text and numbers
• Enter Formulae
• Saving & naming workbook
• Print & Preview Options

Editing Workbooks
• Open existing Workbooks
• Moving around the Worksheet
• Selecting Areas
• Deleting data
• Editing cell contents
• Copying and moving data

Charting
• Chart Example
• Creating a Chart
• Formatting chart objects

Formatting
• Apply font formats
• Number formats
• Text alignment
• Handling percentages

Working with Columns / Rows
• Changing Column widths
• Changing Row heights
• Autofit
• Insert/Delete columns and row
 
Further Formulae
• Absolute Cell referencing
• Statictical Funtions
• Auto Sum 

Our Intermediate Microsoft Excel training course is suitable for those with a basic working knowledge of Microsoft Excel. This computer training course is designed for those users who wish to step up their current knowledge of Microsoft Excel to take advantage of the more complex features. To be able to create, edit and format large or multiple spreadsheets.

Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment. Those who complete the Intermediate Microsoft Excel course satisfactorily will receive a certificate at the end of the computer training course.
 
Read on for further information on the Intermediate Microsoft Excel training course. For more information on our computer course trainers, and computer training course content and fees visit this computer training courses information page

Formulae
• Review of cell addressing within Formulae
• Copy Formulae
• Absolute Cell Referencing

Functions
• Use of the Average, Min, and Max functions
• If Function and Logical Functions
• VLookup Function
• Date related functions
• Text and Date Functions
• Nested Functions
• And/Or Functions

Data Lists
• Sorting Lists
• Using AutoFilter
• Grouping Data with summary rows

Sharing Data
• Importing Data from other Applications
• Exporting Data to other Applications

Ranges
• Creating Named Ranges
• Using Range names in Formulae

Multiple Sheets
• Renaming Sheets
• Inserting and deleting sheets
• Copying sheets
• Group Edit Mode

Pivot Tables
• Creating a Pivot Table•
• Updating
• Creating a Pivot Chart

General
• Protecting sheets
• Using Comments
• Borders, Colours, Patterns
• Autoformat

Our Advanced Microsoft Excel training course is suitable for those with a sound working knowledge of Microsoft Excel who wish to progress to the most complicated functions and features. At the end of this course you will have a complete understanding of the higher functions of Microsoft Excel.

You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications. You will then be qualified to progress to the VBA course for Excel.

Those who complete the Advanced Microsoft Excel course satisfactorily will receive a certificate at the end of the computer training course.

Read on for further information on the Advanced Microsoft Excel training course . For more information on our computer course trainers, and computer training course content and fees visit this computer training courses information page

Auditing Data
• Auditing Tools
• Error Values
• Removing trace arrows
• Automatic Error Checking
• Checking for Errors
• Watch Window
• Evaluate Formula
• Rounding Values
• Validating Data

Customising Formats
• Customising Numbers 
• Conditional Formats

Using Multiple Workbooks
• Saving a Workspace
• Linking Workbooks

Problem Solving
• Goal Seek
• Solver

Scenarios and Custom Views
• Scenario Manager
• Custom Views 

Macros
• Absolute / Relative References
• Recording a Macro
• Running a Macro
• Assigning a Macro to a Button
• Macro Module 

Working with Ranges of Cells
• Using Labels in Formulae
• Naming Ranges

Working with Databases
• Groups and Outlines
• Sub-Totals
• Pivot Tables

Sharing Workbooks
• Adding Comments
• Creating and Using Templates
• Creating a Template
• Using a Template
• Editing a Template