Microsoft Excel 2016 Skills and Tools Free

Learn about the ribbon, cells, text tools, colors, tables, shapes, filtering and basic formulas such as SUM and AVERAGE.
Rating: 4.1 out of 5 (207 ratings)
7,040 students
Microsoft Excel 2016 Skills and Tools Free
Rating: 4.1 out of 5 (207 ratings)
7,038 students
In this free version, you will learn basic excel skills.
Learn about using cells and the ribbon
Learn about using text tools and colors
Learn how to create, delete, rename and copy sheets
Learn how to insert a shape, change its colors and add effects
Learn how to create a table

Requirements

  • You only need to know how to open Excel 2016. You do not need any experience working with excel. The course will show you how to open a new workbook.
Description

Learn about using the ribbon.

Learn how cells work and how to use sheets.

Learn about text tools and colors.

Learn how to create a shape and add effects and text to it.

Learn how to insert a table and filter and sort the information.

Learn how to use basic formulas such as SUM and AVERAGE.

Thanks so much for trying this course.

Who this course is for:
  • Those who want to learn how to use the Excel 2016
  • Those who need to know how a spreadsheet works
  • Those who want to know the basics of Excel
Course content
4 sections • 7 lectures • 1h 9m total length
  • Introduction
    04:27
  • Cells, Colors and Text
    17:27
  • Wrap Text, Numbers and Sheets
    08:58
  • Excel Basics Quiz
    7 questions
  • Assignment 1
    1 question
  • Tables, Filtering and Sorting
    16:28
  • Insert Shape and Add Effects and Text
    06:22
  • Tables and Shapes Quiz
    7 questions
  • Assignment 2 Tables and Shapes
    1 question
  • Sum, Average and Basic Formulas
    14:51
  • Basic Formulas Quiz
    3 questions
  • Assignment 3 Basic Formulas
    1 question
  • Bonus Lecture
    00:32

Instructor
Microsoft Office Teacher and Graphic Designer
Jevon Pletschke
  • 4.1 Instructor Rating
  • 223 Reviews
  • 9,147 Students
  • 2 Courses

I have studied Microsoft Office at college a few years ago and have taught people to use Excel and Word. I have also been working in the Graphic Design business for the past 2 years. I studied at college and learned how to use all tools and many design skills. I make business cards, folding pamphlets, posters, flyers and more.