Skip to main content

29 Apr 2021

Introduction to Spreadsheets – Microsoft Excel – Online 29/04/2021

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.  More details to come:

Session One (90 minutes) 29 Apr starting at 9.15am

  • 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) 6 May starting at 9.15am

  • 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) 13 May starting at 9.15am

  • Review of homework
  • Continue Sorting and filtering
  • Printing
  • Introduction to chart
  • Homework

Session Four (90 minutes) 27 May starting at 9.15am

  • 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 the the platform used to hold the Zoom links/training materials.
  • Homework will be assigned between sessions

Instructor

Anne Walsh

www.the-excel-expert.com

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 is also 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-expert.com

You can read testimonials for her work at http://www.the-excel-expert.com/training-2/testimonials/.

Fees

€140Nonprofit Organisation
€120Carmichael Resident Organisation
€160Statutory/Corporate Organisation

Book Now