HR training course

MS Excel Tips & Tricks

Instructor-ledIntermediateHands-on

The shortcuts, formulas and features that cut the time you spend in Excel and the errors you make there. Built for people who already use Excel and want to stop doing things the long way.

Taught by Monica LewisHalf dayPrerequisite: Excel Level 1

Upcoming sessions

Pick a date and register

Nov20
Friday, November 20
9:00 AM ET
Add to cart

What you will learn

Skills you will walk away with

  • Use the shortcut keys that actually save time
  • Select and navigate large sheets efficiently
  • Find and fill blank cells, and find duplicate records
  • Apply Flash Fill, Autofill and the Quick Analysis feature
  • Use conditional formatting, filters, slicers and data validation

About this course

What this course covers

Learning Excel tips pays off for anyone who works with data or spreadsheets regularly. Understanding keyboard shortcuts, formula shortcuts, data manipulation techniques and data analysis features saves time and reduces errors. Whether you are a beginner or an experienced user, this class will help you work smarter rather than harder.

Prerequisites: you must be a current Excel user and have taken Excel Level 1 or have equivalent experience. Taught in the Windows environment.

FormatInstructor-led
LevelIntermediate
PrerequisiteExcel Level 1

Who should attend

Who this course is for

  • Anyone who works in spreadsheets most days
  • HR and finance professionals handling recurring data
  • Experienced users who have never been shown the shortcuts

Your facilitator

Who teaches this course

Monica Lewis

Facilitator

Monica teaches Catapult’s Microsoft Office curriculum, working with professionals who need Excel to be faster and more reliable in their day-to-day work.

Good to know

Course questions

You should be a current Excel user who has taken Excel Level 1 or has equivalent experience.

The course is taught in the Windows operating system environment.

This course does not carry HRCI or SHRM credit.

Register for this course today

Live online, open to your whole team. Or bring it in-house with private delivery.