MS Excel Level 2
- Live virtual or in person
- 7 hours
- Instructor-led
Live virtual or in person · 7 hours · Instructor-led
KWCOBuild 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
This course will teach learners how to work with large worksheets in Microsoft Excel and efficiently use multiple worksheets and workbooks. It will show how to link information from different worksheets and workbooks and introduce more advanced formatting techniques. In addition, participants will learn how to create outlines and subtotals and create and apply cell names. They will sort, filter, remove duplicate data, and create and format tables. Finally, they will learn how to protect and share workbooks.
Before you attend. The course requires that you have successfully completed Excel I or had more than six months using Excel and are familiar with all Excel I materials.
Your facilitators
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.
Ken Worthy
Facilitator
Carolyn Oakes
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 $459 for non-members and $339 for members. It is also included with a Class Pass.
Next: Nov 24 · 15 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
Computer Basics: Windows and more
Apr 28 · 1 date
Live virtual
$459 non-member · $339 member
Delivered live online nationwide, with select courses also meeting in person in Charlotte and Raleigh. Explore training by state: North Carolina · Louisiana · New Hampshire · South Dakota · Alaska · Hawaii
Customer Service Excellence
Dec 2 · 1 date
Live virtual
$459 non-member · $339 member
Cyber-Security Essentials
Dec 9 · 3 dates
Live virtual
$459 non-member · $339 member
All Courses & Dates
Browse the full catalog of 101 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 →Register for MS Excel Level 2 today
Live online, open to your whole team. Or bring it in-house with private delivery.