Name: Introduction to Microsoft Excel Course
Price: 36 USD

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

Top Choice of Leading Companies Worldwide

Industry leaders and professionals globally rely on this top-rated course to enhance their skills.

Course Description

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? 1. 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. 2. 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. 3. 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. 4. 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.

Learn for Free

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

Interactive Exercises
Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.

Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.

Curriculum

1. Welcome! Course Introduction

10 Lessons 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
4 min
Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
4 min
Data Entry Techniques in Excel
3 min
How to Make Your Spreadsheets Look Professional
6 min
Inserting, Deleting, and Modifying Rows & Columns
2 min
Excel Formulas for Beginners
3 min
Excel Functions
4 min
Work Efficiently by Using Cut, Copy, and Paste
2 min
Formatting
5 min
Pasting Values, Formulas and Formats with Paste Special
1 min
2. Useful Tools & Tips

29 Lessons 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
1 min
Do More with Your Sales Data with Excel's Text to Columns Feature
2 min
Create Easily Printable Excel Documents
1 min
How to Wrap Text in Excel and Adjust a Cell's Size
1 min
Insert Hyperlinks into Excel Spreadsheets
1 min
Using Excel's Freeze Panes to Handle Large Datasets
1 min
Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do
1 min
A Quick Introduction to Excel's Pivot Tables
2 min
Initial Formatting Is Key for Creating Professional-looking Spreadsheets
2 min
Macros Are a Great Timesaver! Here's Why
3 min
How to Use the Same Macro On Multiple Workbooks
2 min
The Secret to Faster Scrolling in Excel
2 min
Be even quicker: F5 + Enter
2 min
Using Absolute and Relative Cell References
2 min
Find and Select Cells That Meet Specific Conditions
2 min
How to Create Dynamic Names in Excel Spreadsheets
1 min
Using Named Ranges to Make Formulas More Readable
2 min
How to Add a Drop-down List in Excel
2 min
Using Custom-sort to Sort Multiple Columns Within a Table
1 min
Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts
4 min
Multiply by 1
2 min
Find and Replace - References
3 min
Find and Replace - Formatting
2 min
Green References
2 min
Beauty Saving - The Professional Way of Saving Files
2 min
The Power of F2
2 min
Conditional Formatting
6 min
Introduction to Custom Cell Formatting
6 min
Custom Formatting - An example
2 min
3. Beginner, Intermediate & Advanced Functions

17 Lessons 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
3 min
Enlarge the formula bar
1 min
Key Excel Functions: SUM, SUMIF, SUMIFS
4 min
Key Excel Functions: COUNT, COUNTIF, COUNTIFS
4 min
Key Excel Functions: AVERAGE, AVERAGEIF
2 min
Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER
4 min
Working with text in Excel
3 min
Find the Highest and Lowest Values in a Range: MAX & MIN
1 min
When you start typing a formula
1 min
Use ROUND in Your Financial Models
1 min
Excel's Lookup Functions: VLOOKUP & HLOOKUP made easy
8 min
INDEX, MATCH, and Their Combination - The Perfect Substitute for VLOOKUP
7 min
Using Excel's IFERROR Function to Trap Spreadsheet Errors
2 min
A Useful Tool for Financial Analysis - The RANK Function
3 min
Create Flexible Financial Models with CHOOSE
2 min
Goal Seek Will Help You Find the Result You Are Looking For
2 min
Perform Sensitivity Analysis with Excel's Data Tables Functionality
4 min
4. Practical Exercise "Build a P&L From Scratch"

16 Lessons 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
1 min
What You Will See Next
1 min
Understand Your Data Source Before You Start Working on It
3 min
Ordering the Source Worksheet
2 min
Create a Code: The Best Way to Organize Your Data and Work Efficiently with It
2 min
Learn How to Create a Database
2 min
Using Lookup Functions (Vlookup) to Fill the Database Sheet
5 min
Use Sumif to Complete the Database Sheet
4 min
Using Index & Match as a Substitute for Vlookup
4 min
The Mapping Exercise
2 min
Mapping the Rows in the Database Sheet
2 min
Building the Structure of the P&L Sheet
2 min
A Practical Example of Professional Formatting in Excel
3 min
Populate the P&L Sheet with Sumif
3 min
Learn How to Find Mistakes with Countif
2 min
Calculating Growth Rates in Excel
3 min
5. Introduction to Excel Charts

7 Lessons 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
1 min
Beginner's Guide to Inserting Charts in Excel
2 min
Modifying Excel Charts - The Easy Way
2 min
Making Your Excel Charts Sexier - Proven Tips
3 min
Creating a Bridge Chart in Excel 2016 - As Easy as It Gets
2 min
New Ways to Visualize Your Data - Treemap Charts
1 min
How to Represent Trends with Sparklines
4 min
6. Building Professional Charts in Excel

4 Lessons 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
6 min
Doughnut Chart
5 min
Area Chart
4 min
Bridge Chart
7 min

Topics

Data AnalysisExcelData VisualizationSpreadsheetsData Analysis

Tools & Technologies

Course Requirements

No prior experience or knowledge is required. We will start from the basics and gradually build your understanding. Everything you need is included in the course
You will need Microsoft Excel 2010, 2013, 2016, 2020, or Microsoft Excel 365

Who Should Take This Course?

Level of difficulty: Beginner

Excel beginners
Aspiring financial analysts and data analysts
Graduate students who want to learn how to work with Excel professionally

Exams and Certification

A 365 Data Science Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Meet Your Instructor

Ned Krastev

CEO at

24 Courses

35113 Reviews

412489 Students

Nedko earned a Master’s degree in Finance from Bocconi University (Milan, Italy) in 2012. Then, he gained valuable working experience with exciting firms like PwC Italy (Financial Advisory and M&A), Coca-Cola European Partners (Financial Analyst), and Infineon Technologies (M&A). In 2014, he published his first online course on financial modeling and valuation when he realized that creating educational materials is his true calling. The amazing students and content creators in the data science community, the 365 team, and the strong desire to build the perfect learning platform drive Nedko to continue on this exciting journey. His goal is to establish 365 Data Science as the learning platform that bridges the gap between theoretical knowledge and practical business application.