Tận dụng cơ hội để nhận học bổng!

Học khoá học ưa thích & nhận học bổng
Đang xem
5 Học viên
59 Các bài học
Mới bắt đầu

Bạn sẽ học gì?

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

Chương trình giảng dạy

3giờ 39phút
Phần 1: Introduction To This Course
03:51
Phần 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
Phần 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
Phần 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
Phần 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
Phần 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
Phần 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
Phần 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
Phần 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
Phần 10: Macros
07:35
What You Will Learn In Section 9
00:07
How To Record And Run A Macro
07:28
Phần 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
Phần 12: Printing Your Worksheet
07:23
What You Will Learn In Section 11
00:08
How To Print A Workbook
07:15
Phần 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
Phần 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

Mô tả

Yêu cầu

  • Microsoft Excel 2016

Về Giảng viên đào tạo

98% học viên đánh giá giảng viên này là xuất sắc!
Đánh giá 0
Học viên 198
Khóa học 3

Đánh giá nền tảng BitDegree

Học viên của chúng tôi nói Xuất sắc
9.5 trên 10
trustpilot logo 1 trustpilot logo