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.
What you'll learn
- Learn to sort, filter, and pivot data in Excel
- Understand how to shape datasets into useful formats
- Practice skills through projects, quizzes, and a final project
Skills you'll gain
- Sort data based on custom parameters
- Filter data based on values
- Pivot a dataset
- Use Excel to explore and analyze real-world data such as GDP
Prerequisites
- • None
Who this course is for
- → Beginners who are new to Microsoft Excel
- → Learners interested in data analytics and data science
- → Anyone who wants to improve basic Excel data manipulation skills
Our Review
Learn A Course Online EditorialBottom Line
A genuinely finishable, zero-cost intro to Excel's most practical features—best treated as a confident first step, not a complete skill set.
📊 Course Snapshot
📝 Editorial Analysis
Here's the thing about a one-hour Excel course: it's either going to be a genuinely useful on-ramp or a glorified table of contents. Codecademy's Excel Basics lands closer to the first option—and at free, the bar for recommending it is pretty low. But I want to be specific about what you're actually getting, because the title is doing a little more heavy lifting than the content.
The course covers three core skills: sorting, filtering, and pivoting data. That's a deliberately narrow scope—and honestly, I respect it. Too many beginner courses try to cover formulas, charts, VLOOKUP, conditional formatting, and keyboard shortcuts all in one go, and then wonder why their support inbox fills up with "I'm lost" messages. This one picks a lane. The lane is data manipulation. It stays in that lane.
The use of real-world data—GDP figures, specifically—is a small but meaningful detail. It means you're not sorting a fake list of fictional widgets. You're working with something that feels like an actual Tuesday-morning task. That kind of grounding matters for beginners who are trying to connect the skill to a reason to care.
Codecademy's format leans interactive, which is a plus here. Quizzes and a final project are included—so it's not just watch-and-forget. There's some low-stakes proof-of-learning built in. For a free, one-hour course, that's more structure than most.
The honest limitation? One hour is one hour. You will not leave this course ready to build a financial model or wrangle a 50,000-row dataset. Pivot tables get introduced here—but pivot tables have depth. This is the appetizer, not the meal. Anyone hoping to use Excel seriously for data analytics will need to stack this with intermediate content afterward. Think of it as the "start-here path," not the whole path.
With 658 reviews sitting at 4.4 out of 5, students seem to agree: it does what it says. That's not a small thing. And I get a little spicy about courses that overpromise, so a course that quietly delivers on a modest promise? That earns some goodwill from me.
⏱️ Real Time Investment
1h
Listed Duration
~2h
Realistic Estimate
The listed hour is plausible if you're clicking through quickly—but if you're actually pausing to do the exercises, re-reading anything that doesn't click, and completing the final project without rushing, budget closer to two hours. That's still an easy Saturday morning or a couple of lunch breaks. The friction here is low by design.
🎯 Skills You'll Build
✓ Strengths
- Completely free with no paywall—zero financial risk for an absolute beginner testing the waters
- Narrow, well-defined scope (sort, filter, pivot) means you actually finish knowing those three things, not vaguely knowing twenty
- Uses real-world GDP data for practice, which grounds the skills in something that feels like actual work
- Interactive format with quizzes and a final project adds light accountability that passive video courses skip
- One-hour runtime makes it genuinely finishable—even on a tired Tuesday night
✗ Limitations
- Depth is shallow by design: pivot tables are introduced but barely explored, so intermediate learners will hit a ceiling fast
- No coverage of formulas, functions, or charts—the course title says 'basics' but really means 'data manipulation basics,' which is a narrower promise than most beginners expect
- 658 reviews is a relatively small sample for a Codecademy course, so the 4.4 rating may shift as more students weigh in
- Codecademy's browser-based environment doesn't fully replicate working in an actual Excel desktop file, which can create a small friction gap when students try to apply skills on their own machine
🎯 Bottom line: If you've never touched Excel and want a clean, free, no-excuses starting point that you'll actually finish, this is a solid first hour—just know you'll need to keep going after it.
Provider
Codecademy
Related Courses
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 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.
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.
Learn Node.js
Beginner-friendly, hands-on introduction to Node.js for backend web development. Learn to create and configure HTTP servers, understand the request–response cycle, implement routing, serve JSON APIs with path and query parameters, and handle CORS while building a small server application.
Data Structures and Algorithms in Python
Explore core data structures—linked lists, stacks, queues, hash tables, trees, and graphs—and implement key search and sort algorithms in Python while analyzing their efficiency using Big O notation.
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.