The Complete Excel Course for Beginners 2020

Learn the basics of Excel and build a solid understanding of how to use it

Why this course is for you?

What you’ll learn

  • Master the Microsoft Excel basics.
  • Build a solid foundation on how to use Excel.
  • Learn the most commonly used Excel functions and formulas.
  • Build a business budget from scratch.
  • Learn how to enter numbers and text into Excel.
  • Learn how to create graphs and charts.
  • Learn how to format your Excel worksheets.
  • Learn the Excel layout.
  • Learn how to automate work in Excel.
  • Learn popular Excel shortcuts.

Course Content

  • Introduction –> 1 lecture • 5min.
  • Microsoft Excel Basic Functions –> 9 lectures • 20min.
  • Entering and Editing Data In Excel –> 7 lectures • 42min.
  • Using Excel Basic Functions –> 7 lectures • 29min.
  • Modifying An Excel Worksheet –> 7 lectures • 36min.
  • Formatting Data In Excel –> 9 lectures • 34min.
  • Inserting Shapes and Images Into Excel –> 4 lectures • 16min.
  • Creating Charts In Excel –> 5 lectures • 21min.
  • Printing an Excel Worksheet –> 5 lectures • 17min.
  • Using Excel Templates –> 3 lectures • 12min.

The Complete Excel Course for Beginners 2020


  • Ability to download Excel onto computer or laptop.
  • Eagerness to learn.
  • No prior Excel knowledge needed.

Why this course is for you?

You want to learn the basics of Excel for professional or personal reasons but you have little to no knowledge of how Excel works. You have heard that Excel will allow you to automate work and make your life easier but you don’t know where to start. You know that a lot of jobs now require Excel skills and you want to build up your skills for these jobs.

What you will learn:

  1. The basics of Excel
  2. How to work with the Excel interface
  3. How to open and save an Excel file
  4. How to enter numbers and text into Excel
  5. How to enter formulas into Excel
  6. How to have your formulas automatically update
  7. Common Excel shortcuts
  8. Creating graphs and charts
  9. How to copy, cut, and paste data
  10. Different formatting options and tools
  11. How to create a budget
  12. Cell referencing
  13. Inserting images and shapes

What you will need:

  1. A computer, laptop, or tablet
  2. Microsoft Excel
  3. No prior Excel knowledge needed
  4. Hunger and willingness to learn
Get Tutorial