Seize the opportunity to gain new skills and reshape your career!

Choose a free learning path and get valuable insights from first-rate courses
watching now
5 Students
59 Lessons
Beginner

What Will You Learn?

  • How to use Microsoft Excel 2016
  • How to manage large volumes of data
  • How to visualize data
  • How to apply various formulas

Curriculum

3h 39m
Section 1: Introduction To This Course
03:51
Section 2: Getting Acquainted With Excel 2016
24:24
Exercise Files
The Backstage View
06:04
The Ribbon
02:46
The Mini Toolbar
02:45
The Formula Bar
03:08
The Quick Access Toolbar And The Status Bar In Excel 2016
04:39
The Tell Me Feature In Excel 2016
01:35
Section 3: Different Ways To Select Cells
09:33
What You Will Learn In Section 2
00:11
How To Select Cells In Excel 2016
09:22
Section 4: How To Manipulate Worksheets
07:43
What You Will Learn In Section 3
00:11
How To Create And Delete A Worksheet
02:31
Moving, Copying And Renaming Worksheets In Excel 2016
05:01
Section 5: Formatting Worksheets In Excel 2016
43:39
What You Will Learn In Section 4
00:38
How To Change The Font, Font Color And Font Size In Excel 2016
05:41
Text Alignment in Excel 2016
06:12
A Beginner's Guide To Cell Styles
01:44
How To Automatically Insert A Decimal Point In Excel 2016
01:53
How To Rotate Text Within A Cell
02:59
How To Wrap Text In Excel 2016
01:36
A Beginner's Guide To Borders In Excel 2016
04:39
An Introduction To Conditional Formatting
11:35
Formatting And Special Effects
06:42
Section 6: Ways To Enter Data
12:42
What You Will Learn In Section 5
00:20
Data Entry In Excel 2016 - A Beginner's Guide
02:59
How To Limit Data Entry To A Cell Range
01:28
Autocomplete
02:28
Autofill
05:27
Section 7: Formulas
17:31
What You Will Learn In Section 6
00:15
How To Create And Edit A Formula
05:04
Order Of Operator Precedence
03:13
How To Use Operators To Build Formulas
07:35
How To Copy A Formula
01:24
Section 8: Manipulating Rows And Columns
10:44
What You Will Learn In Section 7
00:13
Inserting And Deleting Rows And Columns
06:49
Adjusting Width Of Columns And The Height Of Rows
03:42
Section 9: Charts, Tables And Graphics
16:24
What You Will Learn In Section 8
00:23
How To Create And Delete A Chart In Excel 2016
06:07
How To Insert WordArt And SmartArt Graphics
04:09
Introduction To Tables In Excel 2016
05:45
Section 10: Macros
07:35
What You Will Learn In Section 9
00:07
How To Record And Run A Macro
07:28
Section 11: Protecting And Saving Your Workbook
11:42
What You Will Learn In Section 10
00:09
How To Password Protect A Workbook
05:23
How To Save Workbooks In Excel 2016
06:10
Section 12: Printing Your Worksheet
07:23
What You Will Learn In Section 11
00:08
How To Print A Workbook
07:15
Section 13: Customizing The Quick Access Toolbar And The Ribbon
18:52
What You Will Learn In Section 12
00:10
How To Customize The Quick Access Toolbar In Excel 2016
08:00
How To Customize The Ribbon In Excel 2016
10:42
Section 14: The Excel Options Dialog Box
27:34
What You Will Learn In Section 13
00:13
The General Tab In The Excel Options Dialog Box
08:19
The Formulas Tab In The Excel Options Dialog Box
06:13
The Proofing Tab In The Excel Options Dialog Box
07:54
The Save Tab In The Excel Options Dialog Box
04:55

Description

Requirements

  • Microsoft Excel 2016

About the Instructor

98% of students rated this instructor as excellent!
Reviews 0
Students 198
Courses 3

I teach courses online and have been doing it since 2015.I have taught thousands of students and I like teaching people no matter where they come from.
I offer a step by step and deep explanation . I give out clear and beautiful notes .
The courses are prepared with so much care and attention.It takes a lot of time and i like to do it.

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo