Microsoft Excel 2016 Introductory Course
4.6 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,851 students enrolled

Microsoft Excel 2016 Introductory Course

This Step By Step Easy To Learn Course Has Been Designed To Help You Learn The Basics Of Excel 2016.
4.6 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,851 students enrolled
Last updated 12/2019
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 3 articles
  • 33 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You Will Learn The Fundamentals Of Microsoft Excel 2016
Requirements
  • Microsoft Excel 2016
  • Will To Learn
Description

This 3 Hour Step By Step Introductory Course Has Been Designed To Help You Learn The Basics Of Excel 2016.


                                 This Course Is Made Up Of 13 Sections.

  • I will teach you how to open and close excel 2016 at the very beginning.

  • We will look at the different toolbars that are present in excel 2016, the ribbon and the backstage view.

  • You will learn the different ways to select cells, how to manipulate and format worksheets.

  • We will show you different ways to enter data.

  • We will talk about formulas and how to manipulate rows and columns.

  • We will take a look at macros, charts, tables and graphics.

  • I will teach you how to protect, save and print your workbooks.

  • I will show you how to customize the ribbon and the quick access toolbar .

  • We will look at the excel options dialog box and much much more...


You will get access to me. If you don’t understand something, just let me know and I will explain it to you. That is why you’re here.


You will get access to all 33 exercise files that have been used in this course.

This Course has been designed for anyone who wants to learn.

If you are an advanced user , this course can help you learn the basics of excel again and if you are a beginner , it can help you learn the basics of excel so that you can start using the software.

This course also comes with  30-Day Money-Back Guarantee

You will be able to watch the videos on your iOS or Android Devices.

You will get Full Lifetime Access.

Who this course is for:
  • This course is for the beginner who does not know how to use Microsoft Excel 2016
  • This course is also open to the advanced user who wants to learn the basics again and refresh their memory
  • Anyone who wants to learn Excel 2016
Course content
Expand all 60 lectures 03:38:28
+ Getting Acquainted With Excel 2016
12 lectures 27:02
Exercise Files
00:11

In this tutorial , i will show you what you will learn in section 1

Preview 00:24

In this tutorial , you will learn how to open and close Microsoft Excel 2016.

How To Open And Close Excel 2016
01:01

In this tutorial , we will look at the start screen

The Start Screen
02:00

In this tutorial , we will look at the backstage view

The Backstage View
06:03

In this tutorial , we will look at the ribbon

The Ribbon
02:46

In this tutorial , we will look at the mini toolbar

The Mini Toolbar
02:48

In this tutorial , we will look at the formula bar

The Formula Bar
03:08

In this tutorial , i will explain the quick access toolbar and show you how to use the status bar.

The Quick Access Toolbar And The Status Bar In Excel 2016
04:41

In this tutorial , you will learn how to use the tell me feature in excel 2016

Preview 01:35
Quiz Number 1
1 question
+ Different Ways To Select Cells
2 lectures 09:32

In this tutorial , i will tell you what you will learn in section 2

Preview 00:11

In this tutorial , you will learn how to select cells in Excel 2016

How To Select Cells In Excel 2016
09:21
Quiz Number 2
1 question
+ How To Manipulate Worksheets
3 lectures 08:15

In this tutorial , i will show you what you will learn in section 3

Preview 00:10

In this tutorial , you will learn how to create and delete a worksheet.

How To Create And Delete A Worksheet
02:33

In this tutorial , you will learn how to move , copy and rename worksheets in Excel 2016

Moving, Copying And Renaming Worksheets In Excel 2016
05:32
Quiz Number 3
1 question
+ Formatting Worksheets In Excel 2016
10 lectures 43:31

In this tutorial , i will tell you what you will learn in section 4

Preview 00:37

In this tutorial , you will learn how to change the font, the font color and font size in Excel 2016

Preview 05:41

In this tutorial , i will teach you how to align text in a cell

Text Alignment in Excel 2016
06:11

In this tutorial , we will look at cell styles.

A Beginner's Guide To Cell Styles
01:43

I will show you how to automatically insert a decimal point in your cells . This can be useful when you are working with decimals.

How To Automatically Insert A Decimal Point In Excel 2016
01:52

In this tutorial , i will show you how to rotate text that is present in a cell.

How To Rotate Text Within A Cell
02:58

In this tutorial , i will show you how to wrap text in excel 2016

How To Wrap Text In Excel 2016
01:35

In this tutorial , we will look at borders.

A Beginner's Guide To Borders In Excel 2016
04:38

Conditional Formatting is on the menu. come taste it.

An Introduction To Conditional Formatting
11:34

I will show you how to add special effects and show you several other ways to format text.

Formatting And Special Effects
06:42
Quiz Number 4
1 question
+ Ways To Enter Data
5 lectures 12:38

In this tutorial , i will show you what you will learn in section 5

Preview 00:20

Learn how to enter data in a cell.

Data Entry In Excel 2016 - A Beginner's Guide
02:58

Here is where you learn how to limit data entry to a cell range so that you enter data in only the cells you have selected.

How To Limit Data Entry To A Cell Range
01:27

In this tutorial , we will look at the autocomplete feature in excel 2016

Autocomplete
02:27

In this tutorial , we will look at the autofill feature in excel 2016

Autofill
05:26
Quiz Number 5
1 question
+ Formulas
5 lectures 17:31

In this tutorial , i will show you what you will learn in section 6

Preview 00:14

In this tutorial , i will show you how to create and edit a formula

How To Create And Edit A Formula
05:04

When you are using more than one operator in a formula , Excel follows the set order of precedence that can be found in the video.

This allows excel to determine which operators have superiority over other operators.

Order Of Operator Precedence
03:12

In this tutorial , i will show you how to use operators to build formulas

How To Use Operators To Build Formulas
07:34

In this tutorial , you will learn how to copy a formula


How To Copy A Formula
01:27
Quiz Number 6
1 question
+ Manipulating Rows And Columns
3 lectures 10:42

In this tutorial , i will show you what you will learn in section 7

Preview 00:12

In this tutorial , you will learn how to

  •                                insert rows and columns

                                            and

  •                                delete rows and columns

Inserting And Deleting Rows And Columns
06:48

In this tutorial , you will learn how to adjust the width of a column

and you will learn how to change the height of a row

Adjusting Width Of Columns And The Height Of Rows
03:42
Quiz Number 7
1 question
+ Charts , Tables And Graphics
4 lectures 16:21

In this tutorial , i will show you what you will learn in section 8

Preview 00:22

In this tutorial , i will show you how to create a chart and how to delete a chart in excel 2016

How To Create And Delete A Chart In Excel 2016
06:07

In this tutorial , i will show you how to insert WordArt and a SmartArt Graphic.

How To Insert WordArt And SmartArt Graphics
04:08

In this tutorial , i will show you how to create , format and delete a table in excel 2016

Introduction To Tables In Excel 2016
05:44
Quiz Number 8
1 question
+ Macros
2 lectures 07:33

In this tutorial , i will show you what you will learn in section 9

Preview 00:06

In this tutorial , you will learn how to record and run a macro.

How To Record And Run A Macro
07:27
Quiz Number 9
1 question
+ Protecting And Saving Your Workbook
3 lectures 11:39

In this tutorial , i will show you what you will learn in section 10

Preview 00:08

In this tutorial , i will show you how to protect your workbook with a password.

How To Password Protect A Workbook
05:21

In this tutorial , i will show you how to save your workbooks in excel 2016

How To Save Workbooks In Excel 2016
06:10
Quiz Number 10
1 question