phone 020 8798 3474 / 01670 732139
Email steve@itseasy.co.uk

Excel Training

 

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 a free sandwich lunch and free parking)

 

Costs: Between £125 for a group book and £225 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 MS 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 020 8798 3474/ e-mail info@itseasy.co.uk or use the enquiry form on the top right hand side of this page.

 

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 wizard  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

 

Intermediate Excel Training Course


Use the Average  function in Microsoft Excel
Use the Maximum function in Microsoft Excel
Use the Minimum function  in Microsoft Excel
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 use Goal Seek in Microsoft Excel
Learn how to use Data  Tables in Microsoft Excel
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 in Microsoft Excel

 

Advanced Excel Training Course

 

Learn how to use Solver 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

Some examples
mark up

Basic Formula

Basic IF
Find Out More
To find out more, discuss your needs or book a place, call 01670 732139 / e-mail info@itseasy.co.uk or use the enquiry form on the top right hand side of this page.

Make An Enquiry


If you have any questions
or would like to request a call back,
please use the form below:


Request a Call Back


excel

  • Beginners, Intermediate & Advanced courses
  • Open, bespoke & 1-2-1 training
  • Newcastle Training Room or your premises
  • from just £90 per delegate per day

readmore



  • Learn new skills and develop existing skills
  • Feel much more confident when using the computer program
  • Be more productive at work and be able to take on new roles

readmore

excel

  • Training in small groups (max 6)
  • FREE and UNLIMITED support after the course
  • Free buffet lunch & refreshments
  • Complete notes and manuals

readmore