Master advanced Excel techniques with this comprehensive course.Learn to filter and search data dynamically, create automated workflows with macros, and build visually engaging dashboards.
Discover lookup methods, including INDEX, MATCH, and XLOOKUP, for efficient data retrieval, and explore advanced charting and tracking techniques. Develop practical tools like habit trackers, expiry alerts, and project scheduling systems using functions like NETWORKDAYS and STOCK HISTORY.
Enhance security with cell protection strategies, streamline large spreadsheet printing, and automate titles for a dynamic workflow. Dive into innovative features like Copilot and PivotBy, and even create barcodes and hyperlinks to elevate your productivity.
In this program, it includes the following assets:
- The Advanced Filter in Excel
- How to Do a Weighted Average in Excel
- Find the Closest Match to a Number in Excel
- Create Usable Barcodes in Excel
- Create a Daily Habit Tracker in Excel
- Create an Expiry Alert in Excel
- Create a Daily Habit Tracker in Excel
- Calculate Work Days Excluding Time Off in Excel
- Calculate Work Days with Custom Days Off in Excel
- Create an Expiry Alert in Excel
- Calculate Work Days Excluding Time Off in Excel
- Printing Large Spreadsheets in Excel
- Export a List of Files from File Explorer to Excel with Hyperlinks
- Protect Specific Cells in an Excel Workbook
- Lock Cells but NOT Slicers in Excel
- Create a Stock Chart in Excel - Excel Charting Skills
- New Checkboxes in Excel
- The PIVOTBY Function in Excel
- Change Title and Tab Name Automatically in Excel
- Introduction to Copilot in Excel
- Create a Daily Habit Tracker in Excel
- Creating a TOC with Bookmarks
schedule2 hours on-demand video
signal_cellular_altBeginner level
task_altNo preparation required
calendar_todayPublished At Dec 2, 2024
workspace_premiumCertificate of completion
errorNo prerequisites
lock1 year access