HR training course
MS Excel Level 2
Build on your Excel foundation with intermediate skills including advanced formulas, lookup functions, conditional formatting, data tables, and introductory PivotTables to analyze and summarize data more effectively.
Upcoming sessions
Pick a date and register
Course outline
Topics covered
- Managing workbooks and worksheets
- Setting sheets up in a workbook
- Viewing large worksheets
- Printing large worksheets
- Working with multiple worksheets
- Cell and range names
- Linking worksheets
- Using multiple workbooks
- Custom Number formatting
- Using and Creating special formats
- Transposing data
- Create and Modify Tables
- Creating Subtotals
- Custom Sorting
- Filtering data
- Removing Duplicate values
About this course
What this course covers
Build on your Excel foundation with intermediate skills including advanced formulas, lookup functions, conditional formatting, data tables, and introductory PivotTables to analyze and summarize data more effectively.
Your facilitators
Who teaches this course
Monica Lewis
Facilitator
See the full team of Catapult HR Advisors.
Good to know
Course questions
It is delivered live online and in person at the Charlotte Learning Center. Each session runs 7 hours.
A single seat is $309 for members and $369 for non-members. It is also included with a Class Pass.
Next: Aug 13 · 10 upcoming dates. Pick a date from the list above to register.
Yes. Private delivery is available for your organization, scheduled around your calendar, live online or on site.
Learners also liked
Courses learners usually take next
Related training
More Technology & Digital Skills training
MS Word Level 2
Next: Dec 3 · 2 upcoming dates
View dates & register →Number Crunching with Excel Pivot Tables
Next: Sep 2 · 4 upcoming dates
View dates & register →Pulling Data using Excel VLOOKUPs and More
Next: Aug 11 · 4 upcoming dates
View dates & register →All Courses & Dates
Browse the full catalog of 65 live, instructor-led courses.
Browse the catalog →Technology & Digital Skills
All technology & digital skills courses with upcoming dates.
Explore →All HR Training
Every Catapult training topic and format.
Browse →Private Group Training
Bring this course to your team on your schedule.
Learn more →Delivered live online nationwide, with in-person seats in Charlotte and Raleigh. Explore training by state: North Carolina · Missouri · Oregon · West Virginia · District of Columbia · Maine
Register for MS Excel Level 2 today
Live online, open to your whole team. Or bring it in-house with private delivery.