Microsoft Excel Training - Beginner, Intermediate, Advanced

Microsoft Excel Training

                                                                                           

Microsoft Excel is the industry leading spreadsheet program which enables information to be stored, organised and manipulated with powerful data visualisation and analysis tools.

We have a wide range of excel courses for all levels; Beginner, Intermediate or Advanced.

Beginner
This course is intended for new users and covers the following:

  • Creating a Spreadsheet Files
  • Excel Environment
  • Navigating within a Worksheet
  • Navigating the Workbook
  • Working with Cells
  • Selecting items in Excel
  • Entering Data
  • Formatting Text
  • Formatting Numbers and values
  • Formatting Columns and Rows
  • Adding and Editing Borders
  • Cutting, Copying and Pasting
  • Inserting and Deleting
  • Using Find and Replace
  • Using Undo and Redo
  • Entering Basic Formula and Functions
  • Auto filling Rules
  • Using Page Setup
  • Sorting Data
  • Headers and Footers
  • Printing a Spreadsheet

Intermediate

This course is intended for those who have experience of Excel or have previously completed the beginners course. The course covers the following:

  • Worksheet management – comparing/moving/copying
  • Conditional Formatting
  • Linking excel data
  • Paste Specials
  • Freezing/Hiding Rows/Columns
  • Absolute Cell Referencing
  • Working with  Formulas (SumIF, CountIF, CountA)
  • Working with Date and Time Functions
  • Sorting Data
  • Filters & Advanced Filters
  • Creating sub-totals
  • IF and nested IF Functions
  • V Lookups & H Lookups
  • Creating and formatting Charts
  • Pivot Tables

Advanced

This course is intended for those who have a good level of Excel and want to develop their skills further in the following areas:

  • Creating Tables in Excel
  • Advanced formulas and functions
    • Database Functions
    • Text Functions
    • Lookup, Index and Match
    • Array Formula 
  • Advanced List management
  • Importing & Exporting Data
  • What If Analysis
    • Scenarios,
    • Data Tables,
    • Goal Seek
  • Spreadsheet Security
  • Working with Macros
    • Creating a Macro
    • Inserting a Macro
    • Assigning a macro to a button
  • Forms and Form controls in Excel

Course Duration:

9:30am – 4:30pm

Price:

  • €195 per person*

*Discounts available for group booking