This course covers a range of essential Excel skills designed to streamline your workflow and boost your productivity. You’ll learn powerful techniques like the Advanced Filter, how to create search boxes, calculate weighted averages, and find the closest matches to numbers. We’ll also teach you how to generate barcodes, create personalized habit trackers, and set up expiry alerts—tools that help you stay organized and efficient.

You’ll also master practical functions like calculating workdays, excluding holidays and custom time off, and printing large spreadsheets without losing formatting. Whether you’re managing data, tracking progress, or improving your workflow, these lessons provide the tools you need to take your Excel skills to the next level.

Lessons included:
1. The Advanced Filter in Excel
2. Add a Search Box to a Spreadsheet in Excel
3. How to Do a Weighted Average in Excel
4. Find the Closest Match to a Number in Excel
5. Create Usable Barcodes in Excel
6. Create a Daily Habit Tracker in Excel
7. Create an Expiry Alert in Excel
8. Calculate Work Days Excluding Time Off in Excel
9. Calculate Work Days with Custom Days off in Excel

10. Printing Large Spreadsheets in Excel