Target Audience
You should be comfortable with the Excel basics and/or be using Excel regularly including formulas/functions/sort and filtering/charts.
Outline
The course will take place on Zoom over 4 sessions as per details below. Homework will be assigned between sessions. Resources and links will be stored on a platform called GiraffePad. Please note these will sessions will be recorded and shared with the attendees only. Full instructions and links will be given after registration.
Session One (90 minutes) 19 Feb starting at 3.15pm
- Revision of basics: formulas/functions/fixing cells/lists
Session Two (90 minutes) 26 Feb starting at 3.15pm
- Vlookup function: What it is, what you use it for, use in same workbook and with different workbooks.
Session Three (90 minutes) 05 March starting at 3.15pm
- Introduction to Pivot Tables
Session Four (90 minutes) 12 March starting at 3.15pm
- If functions & Introduction to Conditional Formatting
- Final Q&A
Methodology
- Delivered virtually via Zoom.
- GiraffePad will be the platform used to hold the Zoom links/training materials.
- Homework will be assigned between sessions.
Instructor
Anne Walsh
Anne Walsh has been an IT trainer since Excel came on Windows 95. She has been a freelance IT trainer since the mid-90s. She is a MOS Master Instructor. She has written several books for bookboon.com and is the author of “Your Excel Survival Kit: Your guide to surviving and thriving in an Excel world” which has been receiving consistent 5 star reviews on Amazon. She blogs regularly at www.the-excel-lady.com.
You can read testimonials for her work at https://the-excel-lady.com/testimonials/.
Outcomes
By the end of the course participants will be able to:
- Solid grasp of basics
- Understand the importance of clean data for pivot tables
- Able to create a pivot table, pivot chart, add slicers and keep it up to date
- Understand how to use a vlookup function within and between files
- Apply conditional formatting
- Use the If function to get results based on different conditions.
- Q&A session at the end.
Carmichael’s Spring/Summer 2025 Scheduled Training Programme is kindly sponsored by BoardEffect.
BoardEffect is part of Diligent, the leader in modern governance. BoardEffect delivers an agile board management solution optimised for governance leaders of nonprofits, higher education institutions, community healthcare organisations, and credit unions with the right tools, analytics, and insights to drive more efficient, transparent, and secure governance.
Fees
| €160 | Nonprofit Organisation |
| €140 | Carmichael Resident Organisation |
| €180 | Statutory Organisation |
| €180 | Corporate Organisation |
Testimonials
The presenter - Anne is excellent and you feel very comfortable to ask questions.
Demos were brilliant.
Anne’s presentation was very clear with clear instructions and she helped everyone along at a nice pace.
The course content that was most relevant to me, especially, such as pivot tables and the vlookup function, which will make it much easier to draft up reports and work with large sets of data.
Anne - She delivered the course so well.