HR training course
MS Excel Tips & Tricks
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.
Upcoming sessions
Pick a date and register
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.
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
Learning On Demand Consultant
Monica B. Lewis has been a contract trainer at Catapult for over a year. As a Microsoft Certified Trainer, she has delivered training in 34 countries and 45 U.S. states, reaching professionals and trainers across many industries. Her Catapult courses include Computer Basics, Outlook, PowerPoint, Word, Excel (including PivotTables and dashboards), and Teams.
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.
Learners also liked
Courses learners usually take next
MS Excel Level 2
Next: Sep 23 · 7 upcoming datesView dates & register →Pulling Data using Excel VLOOKUPs and More
Next: Nov 10 · 2 upcoming datesView dates & register →Excel Macros & Intro to VBA: Building Tools & Eliminating Repetition
Next: Dec 9 · 2 upcoming datesView dates & register →Number Crunching with Excel Pivot Tables
Next: Dec 10 · 2 upcoming datesView dates & register →Register for this course today
Live online, open to your whole team. Or bring it in-house with private delivery.