Target Audience
People with little or no knowledge, or experience of using Microsoft Excel.
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. Full instructions and links will be given after registration. Please note, these sessions will be recorded and shared with attendees only. Details of dates and topics are below:
Session One (90 minutes) Wed 04 Sep starting at 3.15pm
- Open A New Spreadsheet
- Identify Data Types
- Use Autofill
- Enter Data / Text
- Select Data / Text
- Format Data / Text
- Use Basic Formulae
- Copy Formulae
- Homework
Session Two (90 minutes) Wed 11 Sep starting at 3.15pm
- Review of homework
- Use Absolute Cell Reference
- Use built in functions: Sum, Average, Max, Min, Count, CountA
- Start on preparing lists
- Add/Delete Rows/Columns
- Sorting and Filtering
- Homework
Session Three (90 minutes) Wed 18 Sep starting at 3.15pm
- Review of homework
- Continue Sorting and filtering
- Printing
- Introduction to chart
- Homework
Session Four (90 minutes) Wed 25 Sep starting at 3.15pm
- Review of homework
- Worksheets-Housekeeping: Add, delete, rename, move/copy, hide
- Worksheets – Formulas – adding up entries across sheets.
- Final Q&A
Methodology
- Delivered virtually via Zoom.
- GiraffePad will be the platform used to hold the Zoom links/training materials/recordings.
- 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
- Learn how to use Microsoft Excel at a beginner’s level.
Carmichael’s Autumn/Winter 2024 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 practical nature of the course - very practical tips that can be put into practice.
Anne is very attentive, has a lot of information handouts and answers each and every question fully.
The teaching was very good. I found Anne very helpful and informative.
Learned and got to cover so many topics in the four weeks.
Glad I got the homework and lots of practice material.
Everything we learnt was really beneficial.