Introduction to Excel

with Ned Krastev
4.8/5
(9,819)

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

6 hours of content 169973 students

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 6 hours of content
  • 40 Interactive exercises
  • 198 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

Introduction to Excel

A course by Ned Krastev

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 6 hours of content
  • 40 Interactive exercises
  • 198 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 6 hours of content
  • 40 Interactive exercises
  • 198 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

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

Welcome to the Course

1.1 Welcome to the Course

4 min

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

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

4 min

Data Entry Techniques in Excel

1.3 Data Entry Techniques in Excel

3 min

How to Make Your Spreadsheets Look Professional

1.5 How to Make Your Spreadsheets Look Professional

6 min

Inserting, Deleting, and Modifying Rows & Columns

1.7 Inserting, Deleting, and Modifying Rows & Columns

2 min

Excel Formulas for Beginners

1.8 Excel Formulas for Beginners

3 min

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 visualization

Tools & Technologies

excel

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.

Exams and certification

Meet Your Instructor

Ned Krastev

Ned Krastev

CEO at

23 Courses

34002 Reviews

396686 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.

What Our Learners Say

26.11.2024
Very informative
26.11.2024
26.11.2024

365 Data Science Is Featured at

Our top-rated courses are trusted by business worldwide.