Skip to main content

1 Oct 2020

Microsoft Excel – Beyond the Basics – Intermediate Level – Online Course 01/10/2020

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 5 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.

Session One (90 minutes) 1st Oct starting at 9.15am

  • Revision of basics: formulas/functions/fixing cells/lists

Session Two (90 minutes) 8th Oct starting at 9.15am

  • Vlookup function: What it is, what you use it for, use in same workbook and with different workbooks.

Session Three (90 minutes) 22nd Oct starting at 9.15am

  • Introduction to Pivot Tables

Session Four (90 minutes) 29th Oct starting at 9.15am

  • If functions & Introduction to Conditional Formatting

Session Five (60 minutes) 5th Nov starting at 9.15am

  • 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/.

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.

Fees

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

Testimonials

The trainer was great – absolutely excellent teacher, great way of explaining things, calm and gave time as needed.
Very interactive and excel made interesting.
Excellent trainer, knowledge and style.
Pace of teaching was ideal. Making sure the content is relevant to the participants was great.

Book Now