Skip to main content
by learnformula
Explore courses
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
Explore courses
  1. Courses
  2. /Office Productivity
  3. /MS Excel

Mastering Advanced Excel: Transform Data Into Actionable Ins

Learn advanced Excel techniques to automate workflows, enhance security, and create dynamic dashboards with tools like INDEX, XLOOKUP, and PivotBy.

Created byAssemble You
BeginnerUpdated Dec 2, 2024

What You'll Learn

  • check_circleExplore the Advanced Filter feature in Microsoft Excel. Examine its capabilities in data extraction and efficient data refresh through VBA Macro.
  • check_circleIntegrate a dynamic search feature into Excel spreadsheets to efficiently match search terms and highlight corresponding information
  • check_circleProficiently calculate weighted averages in Excel by mastering manual formula methods and the efficient application of the SUMPRODUCT function.
  • check_circleEstablish how to find the closest match to a given number in Excel using two methods – one with a helper column and another with a single-cell formula
  • check_circleExplore how to create barcodes in Excel, explore font options like Libre Barcode 39, and customise font sizes.
  • check_circleCreate a personalised Daily Habit Tracker in Excel and dynamically display the percentage completion for selected daily habits.

About This Course

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

Course Content

21 activities • 21 videos • duration: 1h 53m

  • videocamThe Advanced Filter in Excel
    Duration 4:55
  • quizKnowledge Check

Your Instructor

Assemble You

menu_book12 courses
star1,057 reviews

Assemble You teaches the Power Skills you need to build the best you. Skills unique to humans. Leadership, Productivity, Wellbeing, Project Management, Communication, Intrapreneurship, Strategy, Systems, Ethics, and so much more. Each Assemble You course includes impactful video lessons, downloadable key-point infographics and ends with a short test. Become the best you with Assemble You.

Credit Information

Professional development requirements vary by profession, country, and regulatory body. Before enrolling, review the course details and confirm that the content, learning format, and any listed credits meet your specific requirements. You are responsible for confirming eligibility with your regulator or professional association and keeping the records required for reporting.

What Students Are Saying

4.8 out of 5
Student's Choice
55 reviews
  • BC
    Brian C.
    starstarstarstarstar

    Lots of useful functions and tips, even for experienced users

  • LL
    Lizhen (Hedy) L.
    starstarstarstarstar

    Great course!

  • CS
    Claudine S.
    starstarstarstarstar

    Great way to learn advanced Excel!

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(632 reviews)
    2 CPD hrs
  • Finance: NASBA - Finance

    Sensitivity Analysis and Scenario Planning

    starRated5.0out of 5,(154 reviews)
    1.5 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(697 reviews)
    2.5 CPD hrs