Course Description
This course explains how to use Microsoft Excel for intermediate spreadsheet tasks.
This course is intended for those who have experience of Excel or have completed an introduction to Excel.
Course Content
- 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
Course Duration
One full day 9.30 am – 4.30 pm
Course Fee
Course fee is €195 per person
*Discount for multiple or group bookings
Training Locations
We have training locations in Dublin, Naas, Cork, Limerick, Galway, Sligo & Waterford.
We can also provide onsite training in a group or one to one basis.
Training Dates
For public training dates at our regional training locations see here
Enquiries
If you would like further information please complete our online enquiry form
Please call us on 1800 250350 to chat with one of our staff.
Suggested additional courses
Back to the Main Excel Menu