Online Course bestseller
Introduction to Excel

Name: Introduction to Microsoft Excel Course
Price: 36 USD

Go from beginner to pro in Excel with this introductory Excel course that will quickly boost your skills. Learn the most popular office productivity tool in the world

4.8

862 reviews on

Start for free

206,287 students already enrolled

Skill level:

Basic

Duration:

7 hours

Lessons (4 hours)

Practice exams (48 minutes)

Projects (5 hours)

CPE credits:

7

CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of professionals must earn to maintain their licenses and stay current with regulations and best practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's official website: www.nasbaregistry.org

Accredited

certificate

What you learn

Gain speed, reliability, and competence in Excel
Master Excel through best practices taught by a top global instructor
Format spreadsheets professionally to enhance look and function
Utilize essential Excel tools like functions and pivot tables
Design polished, professional Excel charts
Confidently organize and structure your Excel projects

Topics & tools

Data AnalysisExcelData VisualizationSpreadsheets

Your instructor

Ned Krastev

Founder & CEO, 365 Careers | Co-founder, 365 Data Science

Track record

Bringing real-world expertise from leading global companies

Academic background

Master's degree, Finance

Media and recognition

Named by Forbes Bulgaria among the most successful in online ed
1.6M+ students in 210+ countries
Courses used by employees at 80% of Fortune 500 companies

Ask Ned a question

Course overview

Accredited certificates

Course OVERVIEW

Description

CPE Credits: 7 Field of Study: Specialized Knowledge
Delivery Method: QAS Self Study

Are you looking for Excel courses for beginners that will elevate you to pro level?

Would you like to learn to work competently in Excel in just a few hours?

If so, this is the perfect Excel course for you!

You don’t need to spend hundreds of hours trying to learn Excel on your own. It doesn’t get any easier if you rely on Excel tutorials from specialized websites and YouTube. There is a good reason for that.

The most effective way to master Excel is through comprehensive Excel training, where an industry professional guides you from the basics to advanced techniques, offering a structured, step-by-step learning experience beyond mere snippets of information.

This Excel course for beginners stands out because it introduces practical tools and best practices and combines all the acquired knowledge to solve a real-world problem. We know this system works exceptionally well because hundreds of thousands of users worldwide have provided feedback and expressed satisfaction.

The Excel training is ideal for recent graduates, inexperienced young professionals, and analysts a few years into their roles who need to enhance their skills and adopt best practices. No prior knowledge of Excel basics? No problem. This course efficiently guides you from the ground up. Hundreds of Excel courses are available online, but this highly popular one stands out. Instructor Ned Krastev delivers Excel lessons in a clear, friendly manner—ensuring that students can work proficiently on their own by the course's end.

Ned brings practical insights from his roles at PwC, Coca-Cola, and Infineon Technologies—making him the perfect instructor for Excel beginners. With over a decade of teaching experience and millions of students globally, his courses have proven effective. Join us to master quick Excel navigation with shortcuts and popular functions like VLOOKUP, SUMIF, SUMIFS, INDEX, MATCH, and more.

Gain the flexibility to create financial and data analysis reports with pivot tables and Excel functions. Format your work professionally and follow Excel best practices. Earn an Excel certificate recognized by employers and boost your resume.

What sets this beginner Excel course apart from others?

Exceptional Content Quality
Enjoy structured learning and bestselling Excel course content that thousands of students rated excellent. The curriculum distills the practical experience of the instructor and teaches you the Excel skills that allow you to perform at a high level in any corporation globally. The instructor doesn’t simply introduce you to Excel’s tools and features but also shows you how to work with them in real-world scenarios.
One of the Top Excel Courses Online
This course is one of the most popular online Excel courses—attracting nearly a million students across major global corporations and this platform.
Comprehensive Downloadable Material
Access essential Excel resources anytime during your learning journey, including course notes, key term flashcards, exercises, and practice exams—all included in the course.
Certificate of Achievement
Complete the Intro to Excel coursfe and pass the exam to earn a verifiable certificate of achievement—a testament to your dedication and hard work.

Click the 'Buy Now' button to embark on an incredible learning journey and invest in a career-changing opportunity.

Prerequisites

Microsoft Excel (any recent version, such as Excel 2019, 2021, or Microsoft 365)

Advanced preparation

None

Curriculum

83 lessons 36 exercises 3 projects 4 exams

1. Welcome! Course Introduction

34 min

This section is fundamental for those of you who have never used Excel. We will start from the very basics: introducing the Excel ribbon, learning how to insert (and delete) rows and columns, how to perform data entry tasks, and how to format worksheets professionally. In addition, you will create your first formulas and functions, and cut, copy, and paste values for the first time.

34 min

This section is fundamental for those of you who have never used Excel. We will start from the very basics: introducing the Excel ribbon, learning how to insert (and delete) rows and columns, how to perform data entry tasks, and how to format worksheets professionally. In addition, you will create your first formulas and functions, and cut, copy, and paste values for the first time.

Welcome to the Course Free

Excel Made Easy: A Beginner's Guide to Excel Spreadsheets Free

Data Entry Techniques in Excel Free

Exercise Free

How to Make Your Spreadsheets Look Professional Free

Practice exam Free

Inserting, Deleting, and Modifying Rows & Columns Free

Excel Formulas for Beginners Free

Excel Functions Free

Exercise Free

Work Efficiently by Using Cut, Copy, and Paste Free

Formatting Free

Pasting Values, Formulas and Formats with Paste Special Free

Exercise Free
2. Useful Tools & Tips

62 min

Once you are familiar with the basic operations in Excel, it will be time to learn Excel best practices and learn how to navigate spreadsheets professionally. In this section, you will learn how to apply fast scrolling, use keyboard shortcuts, format sheets professionally, fix cell references, use named ranges, apply custom cell formats, and much more.

62 min

Once you are familiar with the basic operations in Excel, it will be time to learn Excel best practices and learn how to navigate spreadsheets professionally. In this section, you will learn how to apply fast scrolling, use keyboard shortcuts, format sheets professionally, fix cell references, use named ranges, apply custom cell formats, and much more.

Inserting a Line Break with Alt + Enter Free

Do More with Your Sales Data with Excel's Text to Columns Feature Free

Exercise Free

Create Easily Printable Excel Documents Free

How to Wrap Text in Excel and Adjust a Cell's Size Free

Practice exam Free

Insert Hyperlinks into Excel Spreadsheets Free

Using Excel's Freeze Panes to Handle Large Datasets Free

Exercise Free

Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do Free

A Quick Introduction to Excel's Pivot Tables Free

Exercise Free

Initial Formatting Is Key for Creating Professional-looking Spreadsheets Free

Macros Are a Great Timesaver! Here's Why Free

How to Use the Same Macro On Multiple Workbooks Free

The Secret to Faster Scrolling in Excel Free

Exercise Free

Be even quicker: F5 + Enter Free

Using Absolute and Relative Cell References Free

Find and Select Cells That Meet Specific Conditions Free

Exercise Free

How to Create Dynamic Names in Excel Spreadsheets Free

Using Named Ranges to Make Formulas More Readable Free

How to Add a Drop-down List in Excel Free

Using Custom-sort to Sort Multiple Columns Within a Table Free

Exercise Free

Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts Free

Multiply by 1 Free

Find and Replace - References Free

Find and Replace - Formatting Free

Exercise Free

Green References Free

Beauty Saving - The Professional Way of Saving Files Free

The Power of F2 Free

Conditional Formatting Free

Introduction to Custom Cell Formatting Free

Custom Formatting - An example Free

Exercise Free

Formatting Data in Excel Professionally Free
3. Beginner, Intermediate & Advanced Functions

52 min

Excel is one of the most popular productivity tools the business world has ever seen. The main reason for this is Excel functions. Here, you will learn how to use Excel functions like a true professional. We will start with some easier examples (SUM, COUNT, AVERAGE, IF, MAX, MIN, VLOOKUP, HLOOKUP), and gradually introduce more advanced (and more powerful) functions such as SUMIF, SUMIFS, COUNTIF, COUNTIFS, INDEX, MATCH, INDEX & MATCH, etc.

52 min

Excel is one of the most popular productivity tools the business world has ever seen. The main reason for this is Excel functions. Here, you will learn how to use Excel functions like a true professional. We will start with some easier examples (SUM, COUNT, AVERAGE, IF, MAX, MIN, VLOOKUP, HLOOKUP), and gradually introduce more advanced (and more powerful) functions such as SUMIF, SUMIFS, COUNTIF, COUNTIFS, INDEX, MATCH, INDEX & MATCH, etc.

Key Excel Functions: IF

Enlarge the formula bar

Key Excel Functions: SUM, SUMIF, SUMIFS

Exercise

Key Excel Functions: COUNT, COUNTIF, COUNTIFS

Key Excel Functions: AVERAGE, AVERAGEIF

Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER

Exercise

Working with text in Excel

Find the Highest and Lowest Values in a Range: MAX & MIN

When you start typing a formula

Exercise

Use ROUND in Your Financial Models

Excel's Lookup Functions: VLOOKUP & HLOOKUP made easy

INDEX, MATCH, and Their Combination - The Perfect Substitute for VLOOKUP

Using Excel's IFERROR Function to Trap Spreadsheet Errors

Exercise

A Useful Tool for Financial Analysis - The RANK Function

Create Flexible Financial Models with CHOOSE

Goal Seek Will Help You Find the Result You Are Looking For

Perform Sensitivity Analysis with Excel's Data Tables Functionality

Exercise
4. Practical Exercise "Build a P&L From Scratch"

41 min

It is one thing to learn how to work with Excel’s most important tools, but it is even better to apply these techniques in a practical exercise. This is what we will do here. The “Build a P&L from scratch” exercise allows you to see how everything you have learned so far can be put into practice.

41 min

It is one thing to learn how to work with Excel’s most important tools, but it is even better to apply these techniques in a practical exercise. This is what we will do here. The “Build a P&L from scratch” exercise allows you to see how everything you have learned so far can be put into practice.

Introduction to the Case Study

What You Will See Next

Understand Your Data Source Before You Start Working on It

Ordering the Source Worksheet

Create a Code: The Best Way to Organize Your Data and Work Efficiently with It

Learn How to Create a Database

Practice exam

Using Lookup Functions (Vlookup) to Fill the Database Sheet

Use Sumif to Complete the Database Sheet

Using Index & Match as a Substitute for Vlookup

The Mapping Exercise

Mapping the Rows in the Database Sheet

Building the Structure of the P&L Sheet

A Practical Example of Professional Formatting in Excel

Populate the P&L Sheet with Sumif

Learn How to Find Mistakes with Countif

Calculating Growth Rates in Excel
5. Introduction to Excel Charts

15 min

One of the strongest features of Microsoft Excel, besides multi-layered calculations, is that it allows you to visualize data. Here, you will learn how to insert and format different types of charts that will help you make sense of numbers and figure out their trend.

15 min

One of the strongest features of Microsoft Excel, besides multi-layered calculations, is that it allows you to visualize data. Here, you will learn how to insert and format different types of charts that will help you make sense of numbers and figure out their trend.

Introduction to Excel Charts

Beginner's Guide to Inserting Charts in Excel

Modifying Excel Charts - The Easy Way

Making Your Excel Charts Sexier - Proven Tips

Creating a Bridge Chart in Excel 2016 - As Easy as It Gets

New Ways to Visualize Your Data - Treemap Charts

How to Represent Trends with Sparklines
6. Building Professional Charts in Excel

22 min

Pivot Tables are capable of summarizing thousands of rows of data in just a few seconds. All you have to do is drag and drop, and you will be able to create the report you need. No functions are needed when working with Pivot Tables, which makes them popular among a large number of users.

22 min

Pivot Tables are capable of summarizing thousands of rows of data in just a few seconds. All you have to do is drag and drop, and you will be able to create the report you need. No functions are needed when working with Pivot Tables, which makes them popular among a large number of users.

Stacked Column Chart with a Secondary Axis

Doughnut Chart

Area Chart

Bridge Chart
7. Course project and exam

235 min

235 min

Football Transfers Analysis in Excel Project

Course exam

Free lessons

1.1 Welcome to the Course

4 min

1.2 Excel Made Easy: A Beginner's Guide to Excel Spreadsheets

4 min

1.3 Data Entry Techniques in Excel

3 min

1.5 How to Make Your Spreadsheets Look Professional

6 min

1.7 Inserting, Deleting, and Modifying Rows & Columns

2 min

1.8 Excel Formulas for Beginners

3 min

Start for free

I joined 365 Data Science to strengthen my skills in data science. Starting with the Python Bootcamp, I quickly learned the programming skills I needed for my job. The platform also helped me refresh my math and statistics and gain a solid foundation in machine learning. The courses are easy to follow, practical, and directly applicable to my work. I highly recommend 365 to anyone wanting to learn programming and data science—it’s a resource I recommend to friends, family, and colleagues.

Megan V.

Before 365: Medical scientist | Triumvira Ummonologics

After 365: Director, Translational Medicine and Data Management | KaliVir Immunotherapeutics

See all reviews

$29,000

average salary increase

after moving to an AI and data science career

The courses at 365 Data Science are engaging, well-structured, and strike the right balance between theory and application. The end-of-course exams stand out—they’re challenging enough to ensure you’ve truly mastered the material, making the certification well-earned. For me, it was also a great refresher that helped solidify my past knowledge. If you want a comprehensive, hands-on platform that truly tests and strengthens your skills, I highly recommend 365 Data Science.

Mario O.

Before 365: Data Scientist | InSites Consulting

After 365: ML/Data Science Engineer | NEWTON

See all reviews

94%

of AI and data science graduates

successfully change

or advance their careers.

Even after earning my master’s degree, I struggled with meeting the specific requirements companies sought in data roles. Enrolling in 365 Data Science and following the career paths helped me focus on high-demand topics like probability and advanced Python. These paths streamlined my preparation for interviews and boosted my skills for the job. With constantly updated content, 365 keeps me current in the field—I’ll keep using it as an essential career tool.