Introduction to Excel – TamTam Learning

About Course

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.

Course Content

1. Welcome! Course Introduction

1.1 Welcome to the Course

03:34
1.2 Excel Made Easy A Beginner’s Guide to Excel Spreadsheets

03:33
1.3 Data Entry Techniques in Excel

03:00
Exercise
1.4 How to Make Your Spreadsheets Look Professional

05:49
Practice Exam 1 File: Please download the file in order to use it in the following Practice Exam 1. Thanks
Practice Exam 1
1.5 Inserting, Deleting, and Modifying Rows & Columns

01:45
1.6 Excel Formulas for Beginners

02:55
1.7 Excel Functions

03:42
Exercise
1.8 Work Efficiently by Using Cut, Copy, and Paste

02:11
1.9 Formatting

05:25
1.10 Pasting Values, Formulas and Formats with Paste Special

01:16
Exercise

2. Useful Tools & Tips

2.1 Inserting a Line Break with Alt + Enter

00:50
2.2 Do More with Your Sales Data with Excel’s Text to Columns Feature

01:53
Exercise
2.3 Create Easily Printable Excel Documents

01:12
2.4 How to Wrap Text in Excel and Adjust a Cell’s Size

00:45
Practice Exam 2 Ressources
Practice Exam: 2
2.5 Insert Hyperlinks into Excel Spreadsheets

01:17
2.6 Using Excel’s Freeze Panes to Handle Large Datasets

01:13
Exercise
2.7 Find Excel Functionalities in a Quicker Way – Tell Me What You Want to Do

00:47
2.8 A Quick Introduction to Excel’s Pivot Tables

02:13
Exercise
2.9 Initial Formatting Is Key for Creating Professional-looking Spreadsheets

01:54
2.10 Macros Are a Great Timesaver! Here’s Why

03:00
2.11 How to Use the Same Macro On Multiple Workbooks

01:37
2.12 The Secret to Faster Scrolling in Excel

01:36
Exercise
2.13 Be even quicker, F5 + Enter

01:51
2.14 Using Absolute and Relative Cell References

02:15
2.15 Find and Select Cells That Meet Specific Conditions

01:31
Exercise
2.16 How to Create Dynamic Names in Excel Spreadsheets

01:22
2.17 Using Named Ranges to Make Formulas More Readable

01:34
2.18 How to Add a Drop-down List in Excel

01:50
2.19 Using Custom-sort to Sort Multiple Columns Within a Table

01:23
Exercise
2.20 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts

04:16
2.21 Multiply by 1

01:35
2.22 Find and Replace – References

03:04
2.23 Find and Replace – Formatting

01:54
Exercise
2.24 Green References

01:32
2.25 Beauty Saving – The Professional Way of Saving Files

02:14
2.26 The Power of F2

01:50
2.27 Conditional Formatting

05:40
2.28 Introduction to Custom Cell Formatting

06:14
2.29 Custom Formatting – An example

01:34
Exercise
Practice Project: Formatting Data in Excel Professionally
Project Quiz

3. Beginner, Intermediate & Advanced Functions

3.1 Key Excel Functions, If

02:36
3.2 Enlarge the formula bar

01:03
3.3 Key Excel Functions_ Sum, Sumif, Sumifs

04:21
Exercise
3.4 Key Excel Functions_ Count, Counta, Countif, Countifs

03:59
3.5 Key Excel Functions_ Average & Averageif

01:55
3.6 Key Excel Functions_ Left, Right, Mid, Upper, Lower, Proper

04:25
Exercise
3.7 Working with text in Excel

02:40
3.8 Find the Highest and Lowest Values in a Range_ Max & Min

00:52
3.9 When you start typing a formula

00:45
Exercise
3.10 Use Round in Your Financial Models

01:01
3.11 Excel’s Lookup Functions_ Vlookup & Hlookup Made Easy

07:43
3.12 Index, Match, and Their Combination – The Perfect Substitute for Vlookup

07:28
3.13 Using Excel’s Iferror Function to Trap Spreadsheet Errors

01:43
Exercise
3.14 A Useful Tool for Financial Analysis – The Rank Function

02:37
3.15 Create Flexible Financial Models with Choose

02:25
3.16 Goal Seek Will Help You Find the Result You Are Looking For

02:13
3.17 Perform Sensitivity Analysis with Excel’s Data Tables Functionality

04:05
Exercise

4. Practical Exercise “Build a P&L From Scratch”

4.1 Introduction to the Case Study

00:46
4.2 What You Will See Next

01:07
4.3 Understand Your Data Source Before You Start Working on It

02:43
4.4 Ordering the Source Worksheet

02:16
4.5 Create a Code_ The Best Way to Organize Your Data and Work Efficiently with It

02:00
4.6 Learn How to Create a Database

01:59
4.7 Using Lookup Functions (Vlookup) to Fill the Database Sheet

05:30
4.8 Use Sumif to Complete the Database Sheet

04:07
4.9 Using Index & Match as a Substitute for Vlookup

03:52
4.10 The Mapping Exercise

02:17
4.11 Mapping the Rows in the Database Sheet

01:42
4.12 Building the Structure of the P&L Sheet

02:21
4.13 A Practical Example of Professional Formatting in Excel

03:18
4.14 Populate the P&L Sheet with Sumif

02:47
4.15 Learn How to Find Mistakes with Countif

02:15
4.16 Calculating Growth Rates in Excel

03:09
Practice Exam 3 Ressources
Practice Exam: 3

5. Introduction to Excel Charts

6. Building Professional Charts in Excel

7. Course Final Project

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

About Course

What Will You Learn?

Course Content

1. Welcome! Course Introduction

1.1 Welcome to the Course

1.2 Excel Made Easy A Beginner’s Guide to Excel Spreadsheets

1.3 Data Entry Techniques in Excel

Exercise

1.4 How to Make Your Spreadsheets Look Professional

Practice Exam 1 File: Please download the file in order to use it in the following Practice Exam 1. Thanks

Practice Exam 1

1.5 Inserting, Deleting, and Modifying Rows & Columns

1.6 Excel Formulas for Beginners

1.7 Excel Functions

Exercise

1.8 Work Efficiently by Using Cut, Copy, and Paste

1.9 Formatting

1.10 Pasting Values, Formulas and Formats with Paste Special

Exercise

2. Useful Tools & Tips

2.1 Inserting a Line Break with Alt + Enter

2.2 Do More with Your Sales Data with Excel’s Text to Columns Feature

Exercise

2.3 Create Easily Printable Excel Documents

2.4 How to Wrap Text in Excel and Adjust a Cell’s Size

Practice Exam 2 Ressources

Practice Exam: 2

2.5 Insert Hyperlinks into Excel Spreadsheets

2.6 Using Excel’s Freeze Panes to Handle Large Datasets

Exercise

2.7 Find Excel Functionalities in a Quicker Way – Tell Me What You Want to Do

2.8 A Quick Introduction to Excel’s Pivot Tables

Exercise

2.9 Initial Formatting Is Key for Creating Professional-looking Spreadsheets

2.10 Macros Are a Great Timesaver! Here’s Why

2.11 How to Use the Same Macro On Multiple Workbooks

2.12 The Secret to Faster Scrolling in Excel

Exercise

2.13 Be even quicker, F5 + Enter

2.14 Using Absolute and Relative Cell References

2.15 Find and Select Cells That Meet Specific Conditions

Exercise

2.16 How to Create Dynamic Names in Excel Spreadsheets

2.17 Using Named Ranges to Make Formulas More Readable

2.18 How to Add a Drop-down List in Excel

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

Exercise

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

2.21 Multiply by 1

2.22 Find and Replace – References

2.23 Find and Replace – Formatting

Exercise

2.24 Green References

2.25 Beauty Saving – The Professional Way of Saving Files

2.26 The Power of F2

2.27 Conditional Formatting

2.28 Introduction to Custom Cell Formatting

2.29 Custom Formatting – An example

Exercise

Practice Project: Formatting Data in Excel Professionally

Project Quiz

3. Beginner, Intermediate & Advanced Functions

3.1 Key Excel Functions, If

3.2 Enlarge the formula bar

3.3 Key Excel Functions_ Sum, Sumif, Sumifs

Exercise

3.4 Key Excel Functions_ Count, Counta, Countif, Countifs

3.5 Key Excel Functions_ Average & Averageif

3.6 Key Excel Functions_ Left, Right, Mid, Upper, Lower, Proper

Exercise

3.7 Working with text in Excel

3.8 Find the Highest and Lowest Values in a Range_ Max & Min

3.9 When you start typing a formula

Exercise

3.10 Use Round in Your Financial Models

3.11 Excel’s Lookup Functions_ Vlookup & Hlookup Made Easy

3.12 Index, Match, and Their Combination – The Perfect Substitute for Vlookup

3.13 Using Excel’s Iferror Function to Trap Spreadsheet Errors

Exercise

3.14 A Useful Tool for Financial Analysis – The Rank Function