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