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. 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.

Precision with ROUND Functions Use ROUND functions to control numerical precision so your outputs look cleaner and more professional, without the stray decimals that clutter a report.

Automating Entry with Flash Fill Use Flash Fill in multiple ways to automate data entry and transform text patterns instantly, skipping the manual cleanup most users do cell by cell.

Relative and Absolute References Learn the difference between relative and absolute cell references and use each correctly, so complex formulas keep working when you copy them across a sheet.

Connecting Sheets with Hyperlinks Insert and manage hyperlinks that connect your spreadsheets to external resources and internal references.

Conditional Formatting Rules Build and customize conditional formatting rules that surface insights and flag important values visually, so patterns stand out the moment you open the file.

Advanced Tables and Faster Navigation Create, sort, and style tables with Excel's advanced table options for presentation-ready data, and pick up the time-saving shortcuts and efficiency tactics most users never learn.