Excel Training

Microsoft Excel starts with the basic layout and functionality of the programme followed by simple sums, functions and charts. Intermediate users can expect to use Excel as a database and discover the management tools available such as Goal Seek, Scenarios and Data Tables. Creating workbook models and linking sheets is an integral part of using Microsoft Excel, users will be able to create and save templates utilising this technique. Advanced users get down to the uses of more complicated functions and how to nest multiple functions. Basic automation helps users navigate around a workbook. All Microsoft Excel training courses are available as tailored packages.  The outline below is only a guide.

Venue & Duration: We can provide Microsoft Excel training courses nationally across the UK or locally with our Newcastle Training Room (generally 1 day duration course with free parking)

 Costs: Between £125 for a group book and £250 for a single delegate. Enquire about One to One prices.

Objectives: Using Microsoft Excel and don’t know where to start?  Need to do something at work but unsure how to?  Experienced in Excel but looking to develop your skills to the next level?   Whatever the challenge, with our range of Group, Customised & 1-2-1 MS Excel Training help is at hand…

Benefits: We help users of Microsoft Excel to learn and develop their skills with our range of Microsoft Excel Training courses. This helps people to be more productive at work and feel much more confident when using Excel. We offer three courses: Beginners, Intermediate and Advanced; we can also customise training to suit your needs. We can help individuals who would like to attend an open course or we can provide bespoke training for a business or organisation. 1-2-1 and private tuition is also available. If you are unsure as to what level or format will suit your needs, simply contact us and we can find the best solution for you.

Suitable For:  We offer three levels of Excel training: Introduction, Intermediate and Advanced.  Check what level is best for you by using our Check Skill Level.

Find Out More
To find out more, discuss your needs or book a place, call 01670 732139 / e-mail steve@itseasy.co.uk  Online courses are available at http://www.itseasytraining.co.uk

This video explains some of the features covered in the Introduction to Excel course

This video explains what is covered on the Intermediate Excel course.

This video gives an example of the topics covered on the advance Excel course.

MICROSOFT EXCEL COURSE OUTLINE INTRODUCTION

Use the Excel Default Screen
Understanding Excel Worksheets/Workbooks
How to Navigating an Excel Workbook
How to Entering Data in to an Excel worksheet
How to Selecting Cells within and Excel worksheet
How to Editing Data in an Excel worksheet
How to Format Excel Cells to display Dates, Percentages, Currency etc
How to use the AutoSum/Average/Max/Min functions in Microsoft Excel
Understand how to use Basic Sums in Microsoft Excel
Understanding Mathematical Precedence
How to Copy and Paste Data in Microsoft Excel
Using the Auto Fill Feature in Microsoft Excel
Saving a Workbook in Microsoft Excel
How to format a Spreadsheet using the Borders Feature and format Cells in Microsoft Excel
How to create Charts using the ribbon in Microsoft Excel
How to Format Charts in Microsoft Excel
Hiding Columns in Microsoft Excel Moving Columns/Inserting Columns in Microsoft Excel
Using Database Filters in Microsoft Excel
How to use Excel Database Sorts/Forms


MICROSOFT EXCEL COURSE INTERMEDIATE OUTLINE

Revision on the Introduction to Excel courses
How to use Basic Scenarios in Microsoft Excel
Learn how to use Sheet Layout and design in Microsoft Excel
Learn how to Named Cells/Ranges in Microsoft Excel
Understand how Absolute Referencing works in Microsoft Excel
Learn how to use Basic Pivot Tables in Microsoft Excel
Learn how to Linking Excel worksheets and workbooks
Learn how to apply Password Protection in Microsoft Excel
Learn how to use Array Formulae in Microsoft Excel
How to attach Comments to a Cell in Microsoft Excel
How to use the Excel Outline feature in Microsoft Excel
Learn how to Name Worksheets in Microsoft Excel
Learn how to use the Subtotals Feature in Microsoft Excel
Understand how basic templates work in Microsoft Excel
Learn how to use Basic Lookups and a basic IF statement in Microsoft Excel


MICROSOFT EXCEL COURSE ADVANCED OUTLINE

Learn how to use Goal Seek in Microsoft Excel
Learn how to use Data Tables in Microsoft Excel
Learn how to use basic IF Statements in Microsoft Excel
Learn how to use Advanced VlookUp and SUMIF functions in Microsoft Excel
How to use nesting functions IF And Match in Microsoft Excel
Using Functions to create Logical Tests, Error Trapping in Microsoft Excel
Using Form Tools in Microsoft Excel
How to use Data Validation in Microsoft Excel
Using Advanced Pivot Tables Formulae in Microsoft Excel
How to record basic Excel Basic Macros in Microsoft Excel
Importing External Data in Microsoft Excel
Using Named Ranges in a Formula in Microsoft Excel
Using Advanced Database Filters and functions in Microsoft Excel
How to use Excel Advanced Scenarios in Microsoft Excel
How to use Excel Investment Rate of Return Functions in Microsoft Excel
Using Text Functions, Left, Right, Mid, Large, Small and Replace in Microsoft Excel
Using Forecast and Frequency functions in Microsoft Excel and learn how to use Solver in Excel

Have a look at some free course resources.

Free Excel resources