Courses GoSkills

Microsoft Excel 365 - Basic & Advanced

CPD-accredited Excel 365 course covering basic to intermediate skills. Learn navigation, formulas, data preparation, PivotTables, charts, automation with macros, Power Query, and modern functions like XLOOKUP, Dynamic Arrays, and LET to analyze and present data effectively.

Intermediate Level 26h 0m 4.70 (3,135) 🌐 EN

What you'll learn

  • Navigate the Excel interface and work efficiently with the ribbon and worksheet
  • Use formulas, functions, and shortcuts to boost productivity
  • Prepare, sort, and filter data for analysis and reporting
  • Apply math, statistical, logic, text, date, and time functions
  • Create charts, graphs, and PivotTables to summarize and visualize data
  • Automate repetitive tasks with macros and use modern Excel features like XLOOKUP, Dynamic Arrays, and LET

Skills you'll gain

  • Navigate the Excel interface and work with workbooks and worksheets
  • Boost productivity using formulas, functions, and keyboard shortcuts
  • Prepare and clean data for analysis using sorting, filtering, and tables
  • Use math, statistical, logic, text, date, and time functions to manipulate data
  • Create and format PivotTables, including calculated fields
  • Perform what-if analysis with Scenario Manager and Goal Seek
  • Import, unpivot, and append data using Power Query (Get & Transform)
  • Build effective column, bar, pie, line, and combination charts
  • Apply cell formatting, custom number formats, and conditional formatting
  • Automate repetitive tasks by recording basic macros
  • Use modern Excel functions like XLOOKUP, Dynamic Arrays, and LET

Prerequisites

  • No prior experience needed

Who this course is for

  • Beginners with no prior Excel experience
  • Intermediate users wanting to improve productivity and analysis skills
  • Professionals who need Excel for reporting, data analysis, or project management
  • Learners seeking a CPD-accredited Excel certification

Our Review

Learn A Course Online Editorial

Bottom Line

A genuinely thorough Excel course that earns its "basic to advanced" label—GoSkills packs PivotTables, Power Query, and modern functions like XLOOKUP into a CPD-accredited 26-hour build that actually respects your time.

⭐ 4.7/5 👤 Beginner → Intermediate ⏱️ 26h listed 🏅 CPD Accredited

📊 Course Snapshot

Student Rating4.7 / 5
Content Depth (Basic → Advanced)Strong
Modern Excel Coverage (XLOOKUP, LET, Dynamic Arrays)Very Good
Review Volume (Trust Signal)3,135 reviews
Beginner AccessibilityHigh

📝 Editorial Review

Let me be honest about something: most "basic to advanced" courses are a mess. They're junk drawers—someone kept adding modules until the course weighed 80 hours and the student gave up somewhere around VLOOKUP. GoSkills' Microsoft Excel 365 – Basic & Advanced is not that course. At 26 hours, it's disciplined. And discipline in course design is rarer than it should be.

The curriculum earns its CPD accreditation by being specific about outcomes. You're not just "learning Excel"—you're building navigation habits, writing formulas that hold up under real data, cleaning messy imports with Power Query, and eventually recording macros to stop doing the same thing by hand every Monday morning. That's a real Monday-morning plan. The kind that actually changes how someone spends their Tuesday.

What I genuinely appreciate—and I don't say this about many courses—is the inclusion of modern Excel functions. XLOOKUP, Dynamic Arrays, and LET aren't bonus content here; they're integrated. That matters because a lot of Excel courses are quietly teaching 2013 Excel in a 2024 world. If your organization runs Microsoft 365, you have access to these tools right now, and this course shows you how to use them. That's decision-grade curriculum design.

The 4.7 rating across 3,135 reviews is a meaningful signal—not a vanity number. That's enough volume to smooth out outliers. And the fact that the rating holds that high suggests the course isn't front-loading its best content and trailing off. (I've seen that pattern destroy completion rates. It's not pretty.)

One honest caveat: this requires a GoSkills subscription, not a one-time purchase. That's worth knowing before you commit. If you're already subscribed—or if you're a team lead buying access for a group—it's an easy yes. If you're evaluating a single purchase, factor in whether the broader GoSkills library justifies the subscription cost for your situation. I'm not in your business, so treat this as a starting point.

The realistic learner here is someone who opens Excel regularly, feels vaguely competent, and suspects they're doing things the slow way. This course is built for that person. It meets them where they are and moves them somewhere useful.

⏱️ Real Time Investment

26h

Listed Duration

~40–45h

Realistic Estimate

Weekly Pacing Options

1h/day → ~6 weeks 3h/day → ~2 weeks Weekend sprint → ~4 weekends

The 26-hour figure covers video content. Add practice time—especially for PivotTables, Power Query, and macros, which reward repetition—and you're realistically looking at 40 to 45 hours before the skills feel automatic. Budget extra time if you're brand new to spreadsheets. But here's the thing: that practice time is where the learning actually happens.

🎯 Skills You'll Build

Excel Navigation & Interface Formulas & Functions Data Cleaning & Sorting PivotTables & Calculated Fields Charts & Data Visualization Power Query (Get & Transform) XLOOKUP Dynamic Arrays LET Function Macro Recording & Automation Conditional Formatting What-If Analysis (Goal Seek & Scenario Manager)

Strengths

  • Covers genuinely modern Excel 365 features—XLOOKUP, Dynamic Arrays, and LET—not just legacy VLOOKUP-era content
  • CPD accreditation adds real credential value for professionals building a portfolio or satisfying employer training requirements
  • 26-hour runtime is disciplined for the breadth covered; avoids the bloated 80-module junk-drawer problem
  • 4.7 rating across 3,135 reviews is a high-volume trust signal, not a small-sample illusion
  • Power Query inclusion makes this genuinely useful for anyone dealing with messy imported data on a regular basis

Limitations

  • Subscription-based pricing means upfront cost isn't transparent—you're paying for GoSkills access broadly, not just this course
  • Intermediate users who already know PivotTables and basic formulas will spend meaningful time in content they don't need before reaching the advanced material
  • Macro coverage appears limited to recording basics—learners who need VBA scripting will need a separate, dedicated course
  • No indication of hands-on projects or real-world datasets; practice depth depends heavily on what the learner brings to the table

🎯 Bottom line: If you're using Microsoft 365 at work and still doing things the slow way, this GoSkills course is a clean, credentialed path from 'functional' to 'genuinely fast'—just go in knowing it's a subscription and budget extra hours for the practice that makes it stick.

Course information sourced from GoSkills Last verified 3 weeks ago
Pricing varies
Go to Course

You'll be redirected to GoSkills

Provider

GoSkills

Related Courses

Microsoft Excel Certification Training

This online course prepares you for the Microsoft Office Specialist Excel Expert certification exam. You will learn to create and format worksheets, use advanced formulas, work with lists, charts, PivotTables, macros, and collaboration tools to analyze and present data efficiently.

The City College of New York / ed2go

Online Excel Training

Organized, progression-based online Excel training from Excel University, including Courses (CPE-eligible) and an all-access Campus Pass subscription with live office hours, student community, and gamified learning for faster, more accurate work in Excel.

Excel University

Excel Crash Course: Grow Better with Microsoft Excel Skills

Learn how to import, clean, and manage large data sets in HubSpot Academy’s Excel Crash Course. Explore data analysis essentials such as table creation, data filtering, and pivot tables, and create charts and graphs for effective data visualization and storytelling.

HubSpot Academy

Excel Basics

Take your Excel skills to the next level by learning how to sort, filter, and pivot data. Begin your Excel learning journey and learn to shape data into the format you are looking for using core Excel data manipulation features.

Codecademy ⭐ 4.40

Microsoft Excel: Beyond the Basics

One-day, advanced Excel seminar focused on boosting productivity with powerful formulas, macros, PivotCharts, database functions, shortcuts and data integration techniques, taught in a hands-off, demonstration-based format with a comprehensive workbook.

Pryor Learning ⭐ 3.50

Investment Banking and Finance: Venture Capital Fundraising

Comprehensive venture capital fundraising course for startup founders and entrepreneurs. Learn how investors think, assess if VC is right for you, find and approach the right investors, build compelling pitch decks and financial plans, and navigate term sheets, due diligence, and closing.

Udemy ⭐ 4.70