watching now
2 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
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
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
18:52
What You Will Learn In Section 12
00:10
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

#### Requirements

• Microsoft Excel 2016

#### Everyday Solutions

98% of students rated this instructor as excellent!
Reviews 0
Students 199
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
4.5 out of 5