The Complete Excel Course for Beginners 2020

Learn the basics of Excel and build a solid understanding of how to use it
Rating: 4.3 out of 5 (689 ratings)
12,209 students
The Complete Excel Course for Beginners 2020
Rating: 4.3 out of 5 (689 ratings)
12,209 students
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

Requirements

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

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

Who this course is for:
  • Beginner Microsoft Excel users
  • Anyone who wants to learn the basics of Excel
Course content
11 sections • 58 lectures • 3h 52m total length
  • Microsoft Excel Beginner Course Introduction
    04:38
  • Launching Excel
    00:45
  • Excel Home Screen
    02:16
  • Introduction to Excel Interface
    04:09
  • Excel Quick Access Toolbar
    02:00
  • Excel Status Bar
    01:35
  • Structure of an Excel Workbook
    02:18
  • Saving an Excel Document
    03:29
  • Opening a Saved Excel Document
    01:48
  • Common Excel Shortcuts
    01:50
  • Microsoft Excel Basic Functions
    3 questions
  • Entering and Highlighting Cells in Excel
    02:53
  • Entering Text Into Excel
    05:36
  • Entering Numbers
    07:29
  • Entering Date Values Into Excel
    05:27
  • Using Cell References
    03:50
  • Creating A Basic Formula In Excel
    06:37
  • Relative Versus Absolute Reference
    10:28
  • Entering and Editing Data In Excel
    3 questions
  • Using the Excel SUM Function
    06:16
  • Using Excel MIN & MAX Functions
    05:00
  • Using Excel AVERAGE Function
    03:54
  • Using Excel COUNT Function
    02:31
  • Adjacent Cell Error
    03:47
  • AutoSum Function
    02:44
  • Using Excel's AutoFill Command
    04:24
  • Using Excel Basic Functions
    2 questions
  • Copy and Paste Data in Excel
    05:23
  • Inserting and Deleting Columns and Rows
    07:37
  • Adjusting Height and Width
    06:11
  • Hiding and Unhiding Excel Columns and Rows
    05:17
  • Renaming an Excel Sheet
    02:42
  • Deleting an Excel Sheet
    04:28
  • Moving and Copying an Excel Sheet
    04:04
  • Modifying An Excel Worksheet
    2 questions
  • Using Font Formatting Commands
    03:16
  • Changing a Cell's Background Color
    03:36
  • Adding Borders to a Cell
    03:15
  • Formatting Data as a Currency Value
    04:36
  • Formatting Data as a Percentage
    02:13
  • Using Excel's Format Painter
    03:17
  • Creating Cell Styles
    05:44
  • Merging and Centering Cells
    03:33
  • Conditional Formatting
    04:44
  • Formatting Data In Excel
    3 questions
  • Inserting Images Into Excel
    03:52
  • Inserting Shapes Into Excel
    03:22
  • Formatting Shapes in Excel
    04:48
  • Using Excel Smart Art
    04:10
  • Inserting Shapes and Images Into Excel
    1 question
  • Create an Excel Column Chart
    04:33
  • Using the Excel Chart Ribbon
    05:34
  • Modifying Data of an Excel Chart
    03:34
  • Moving an Excel Chart
    02:01
  • Creating an Excel Pie Chart
    04:57
  • Creating Charts In Excel
    3 questions
  • Using Print Preview
    01:55
  • Changing Print Properties of an Excel Sheet
    05:18
  • Using the Page Layout View
    03:24
  • Adding Header and Footer Content
    03:58
  • Printing a Specific Set of Cells
    02:24
  • Introduction to Excel Templates
    02:10
  • Using Excel Templates
    04:41
  • Creating an Excel Template
    05:17
  • Using Excel Templates Quiz
    2 questions

Instructor
Instructor
Kris Ivory
  • 4.3 Instructor Rating
  • 689 Reviews
  • 12,209 Students
  • 1 Course

Hello, my name is Kris Ivory and I currently work as an analyst for a management consulting company. I have my Bachelor's degree in Finance and my MBA in business analytics. Throughout my studies and work career I have learned that Excel is one of the most powerful tools. In all my jobs I have used Excel on a daily basis and gained a lot of experience. I now want to share all the skills I have learned through work and studies with you guys. I hope you enjoy my courses.