Skip to content
N+® Microsoft Advanced

Microsoft Excel – Advance

Empowers learners to master dynamic arrays, advanced lookup functions, statistical tools, and specialized rounding techniques in Excel 365.

  • 1 hour 10 minutes
  • Self-paced · online
  • Included in N+
Subscribe to Access $299 / year · all 228 N+ courses
Microsoft Excel – Advance course

Microsoft Excel – Advance is a self-paced advanced Microsoft course (1 hour 10 minutes) on the N+® learning platform. It is included in the N+ Annual Subscription from 1ApexLearn — one subscription unlocks this course and all 228 N+ courses for 12 months, on web, iOS and Android.

Course overview

Advanced-level course empowering learners to master dynamic arrays, advanced lookup functions, statistical tools, and specialized rounding techniques in Excel 365. Designed for data professionals, analysts, and power users, focusing on automation, precision, and flexibility using latest Excel features.

What you will learn

  • Use Dynamic Arrays: Automate data spills and extract unique values
  • Sort and Randomize Data: Apply SORTBY, SEQUENCE, and RANDARRAY
  • Perform Complex Lookups: Use XLOOKUP, XMATCH, INDEX/MATCH, and OFFSET
  • Apply Logical Tools: Use CHOOSE, SWITCH, and two-way lookups
  • Analyze and Rank Data: Use statistical functions and ranking tools
  • Round and Aggregate Values: Apply rounding logic and AGGREGATE function

Skills you will gain

  • Dynamic Arrays
  • Unique Extraction
  • Advanced Sorting
  • Complex Lookups
  • Two-Way Lookup
  • Logical Functions
  • Statistical Tools
  • Data Ranking
  • Rounding Values
  • Aggregation Functions

Tools covered

Excel 365.

Course modules

  1. Module 1: Introduction
  2. Module 2: Advanced Excel Functions
  3. Module 3: Advanced Lookup Functions
  4. Module 4: Statistical Functions in Excel
  5. Module 5: Excel Rounding Functions

Who this course is for

  • Data professionals
  • Analysts
  • Excel power users

Prerequisites

  • Intermediate Excel knowledge required
  • Familiarity with formulas and functions
  • Access to Microsoft Excel 365

What is included

  • Video lessons
  • Digital courseware
  • E-book
  • Audio access
  • Recorded sessions
  • AI Mentor
  • Module Quizzes
  • 12 months of access with the N+ Annual Subscription
  • Course completion certificate

How to access this course

  1. Subscribe to the N+ Annual Subscription on 1ApexLearn.
  2. Receive your N+ activation details by email, usually within one business day.
  3. Sign in at learn.nplus.global or in the N+ app and open Microsoft Excel – Advance.
  4. Learn at your own pace — your progress syncs across devices.

Frequently asked questions

Is this course for advanced users?

Yes, it's designed for users with intermediate Excel experience.

Do I need Excel 365?

Yes, many features like dynamic arrays are exclusive to Excel 365.

Will I learn advanced lookups?

Absolutely! XLOOKUP, XMATCH, and INDEX/MATCH are covered.

Can I use this for data analysis?

Yes, it's ideal for analysts and professionals working with large datasets.

Who should take this course?

Data professionals, analysts, and Excel power users.

Is this course included in the N+ Annual Subscription?

Yes. Microsoft Excel – Advance is one of the 228 courses included in the N+ Annual Subscription from 1ApexLearn. You do not need to buy it separately.

More Microsoft courses in N+

Browse all 228 N+ courses →

Microsoft Excel – Advance is included in N+ Subscribe to Access