Excel Level 2 - Custom Fit

Prerequiste

Completion of Excel Level 1, or comfortable with its topics — entering data, basic formulas, formatting, and working with rows, columns, and multiple worksheets.

Class Description

Level 1 taught you to build a clean worksheet. Level 2 teaches you to make sense of the data once your worksheet grows — hundreds of rows, multiple criteria, numbers that need context. You'll learn to sort, filter, summarize, and visualize data so you can answer real questions ("which region underperformed?" "what's the trend?") in minutes instead of scrolling and squinting.

What You'll Walk Away With

• Get more out of your formulas — go beyond Level 1 basics with more advanced formulas and functions, plus comments and notes so your logic stays clear to you and anyone else who opens the file
• Find exactly what you need in a sea of data — sort, find and replace, and filter your data, then organize it into proper Tables and use grouping and subtotals to summarize it instantly
• Make numbers and exceptions jump off the page — apply custom number formatting and conditional formatting so key values stand out without you having to eyeball every row
• Stop bad data before it happens — implement data validation so your worksheets catch entry mistakes automatically, before they turn into bad decisions
• Turn raw numbers into a story — build charts, add graphics, and create PivotTables and PivotCharts to summarize and present your data at a glance

You'll Also Get

• Links to the class workbook, exercise files, and quizzes, so you can practice and review everything at your own pace after class
• A free 30-minute one-on-one Zoom session with your instructor — included with every TechMentors Excel class, so you've got backup when you hit a real snag

Books & Supplies: Any required books, software, or materials will be communicated prior to the start of training.