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
- Module 1: Introduction
- Module 2: Advanced Excel Functions
- Module 3: Advanced Lookup Functions
- Module 4: Statistical Functions in Excel
- 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
- Subscribe to the N+ Annual Subscription on 1ApexLearn.
- Receive your N+ activation details by email, usually within one business day.
- Sign in at learn.nplus.global or in the N+ app and open Microsoft Excel – Advance.
- 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.





