Beyond Basics: Microsoft Excel
LIVE CLASS
TECHNOLOGY AND CODING
MICROSOFT EXCEL
6 WEEKS · SHORT-TERM

Beyond Basics: Microsoft Excel

If you're already comfortable with the basics of Excel but still feel like you're working harder than you should be, Beyond Basics: Microsoft Excel is built for you.

Starts Sat, Sep 19

2:30 PM UTC · 1h

6 sessions


Akhil photo
FEATURED INSTRUCTOR

Akhil

WHAT YOU'LL WALK AWAY WITH

Outcomes, not lecture notes.

01

Apply ROUND functions to control numerical precision and produce cleaner, more professional outputs

02

Use Flash Fill in multiple ways to automate data entry and transform text patterns instantly

03

Distinguish between relative and absolute cell references and use each correctly in complex formulas

04

Insert and manage hyperlinks to connect spreadsheets to external resources and internal references

05

Build and customize conditional formatting rules to surface insights and flag data visually

06

Create, sort, and style tables using Excel's advanced table options for organized, presentation-ready data

07

Navigate spreadsheets faster with time-saving shortcuts and efficiency tactics most users never learn

YOUR INSTRUCTOR

Meet Akhil.

Akhil photo

Akhil

As an honors engineering student at NCSU with over 3 years of tutoring experience in various subjects, I've had the privilege of implementing creative instructional strategies. These efforts contributed to a 24% increase in students' cumulative SAT scores and a 15% improvement in AP Biology and AP Computer Science scores. I am genuinely dedicated to excelling in a STEM-related field and have been fortunate to be involved in founding and directing the international computer science competition, "OHacksIO," which brought together over 300 participants from six countries.

ABOUT THIS CLASS

If you're already comfortable with the basics of Excel but still feel like you're working harder than you should be, Beyond Basics: Microsoft Excel is built for you. This course targets the gap between knowing how to use Excel and knowing how to use it well — covering power features like conditional formatting, flash fill, absolute and relative cell references, and advanced table styling that the average user never discovers on their own. You'll work alongside an expert instructor and a motivated peer group, picking up shortcuts and strategies that translate directly into faster, cleaner, more professional work. Walk away with the Excel fluency that makes a real difference in reporting, analysis, and day-to-day productivity.

SYLLABUS

Who This Course Is For Beyond Basics: Microsoft Excel is designed for learners who have moved past the fundamentals — you know your way around a spreadsheet, you can sort and filter data, and you've built a formula or two. But you've also hit the ceiling of what casual use has taught you. This course breaks through that ceiling. Whether you're a working professional who needs to produce sharper financial reports, a student preparing to enter a data-heavy field, or a career changer looking to make Excel a genuine asset on your resume, this course gives you the specific, practical skills that separate competent users from confident ones.

Work Smarter with Functions and References One of the most common sources of Excel frustration is formulas that break — or worse, return wrong answers silently. This course tackles that head-on by clarifying the critical difference between relative and absolute cell references, so your formulas behave exactly as intended whether you're copying them across ten cells or a thousand. You'll also master ROUND functions to bring numerical precision and consistency to any reporting or financial work you produce.

Automation and Formatting That Actually Saves Time Flash Fill is one of Excel's most underused features, and once you see what it can do, you'll wonder how you worked without it. This course covers multiple ways to apply Flash Fill to automate repetitive data entry, reformat text, and clean up messy imports in seconds. Pair that with a deep dive into conditional formatting — building rules that automatically highlight trends, flag outliers, and make your data visually intuitive — and you'll be producing spreadsheets that communicate clearly without hours of manual cleanup.

Tables, Hyperlinks, and a More Connected Workbook Excel tables are far more powerful than a plain data range, and this course shows you how to create, sort, and style them using Excel's full suite of table options. You'll also learn how to use hyperlinks to connect your workbooks to external sources, documentation, or other sheets — building spreadsheets that function as complete, navigable tools rather than static grids. These skills are especially valuable for anyone managing reports, dashboards, or collaborative files in a professional setting.

Learn with an Expert, Leave with an Edge Beyond the technical content, this course is built around live instruction and peer interaction. You're not watching pre-recorded tutorials — you're working through real problems with an expert instructor who can answer your specific questions and a group of peers who are at the same stage and motivated by the same goals. The shortcuts and time-saving tactics woven throughout the course aren't just clever tricks; they're the kind of muscle memory that compounds over time, making every future spreadsheet faster and every deliverable more polished.

GOOD TO KNOW

Live Q&A

Cameras / mics optional

Recordings

Available within 1 hour, kept 90 days

Materials

No special materials required

PLAN PERK
$0

free with a Varsity Tutors membership

NEXT CLASS IN

11

DAYS

00

HRS

17

MIN

Sat, Sep 19 • 2:30pm UTC

6 classes, starts in 11 days

1 left

Mon, Oct 26 • 11:00pm UTC

6 classes, starts in 48 days

Sun, Dec 6 • 10:00pm UTC

6 classes, starts in 89 days

Tue, Sep 8 • 11:30pm UTC

2 classes, starts today

1 left · Almost full

Beyond Basics: Microsoft Excel