Course Content
Chapter 1 – Introduction
0/5
Menu
01:04
Workbook
01:03
Worksheet
02:19
Quick Access Toolbar
01:31
Column Row Cell Status
01:38
Chapter 2 – Data Entry
0/6
Entering Data
01:49
Auto Fill and Flash Fill
01:33
Dates and Times
01:21
Undo Redo
01:33
Comments
02:36
New Open Save and Save As
04:41
Chapter 3 – Formulas and Functions
0/5
Basic Formulas
04:16
Copy Formulas
01:23
Hierarchy
01:43
Absolute References
03:22
Auto Sum
04:15
Chapter 4 – Formatting
0/8
Font and Borders
04:44
Column Width and Row Height
03:56
Alignment
04:07
Number
03:04
Date and Time Format
02:02
Conditional Formatting
06:05
Tables
09:53
Illustrations
06:25
Chapter 5 – Worksheet Layout
0/4
Insert and Delete Cells
03:00
Hide and Unhide
02:18
Cut Paste Copy Move
03:34
Find and Replace
04:39
Chapter 6 – Print
0/3
Page Setup and Scale to Fit
12:00
Page Break Preview and Page Layout
05:53
Print
04:52
Chapter 7 – Charts
0/7
Recommended Charts
02:29
Creating Charts
04:04
Chart Formatting Shortcuts
03:06
Change Chart Type
01:56
Formatting Chart Elements
03:13
Trendline
02:02
Sparklines
03:01
Chapter 8 – Worksheet Views
0/2
Freeze Panes and Split
05:38
Auto Outline
03:43
Chapter 9 – Multiple Worksheets and Workbooks
0/2
Linking Data
03:40
Edit Links
02:07
Chapter 10 – IF, VLOOKUP, and Other Functions
0/3
IF Function
04:18
VLOOKUP Function
05:33
COUNTIF Function
02:22
Chapter 11 – Security and Sharing
0/5
Protect Sheet
01:33
Lock Cells
02:30
Protect Workbook
01:25
Workbook Password
03:09
Share Workbook
01:36
Chapter 12 – Database Properties
0/4
Sort Property
01:40
Subtotal Property
03:05
Filter Property
02:29
Text to Columns
01:46
Chapter 13 – Pivot Tables
0/10
Create Pivot Table
02:24
Pivot Table Basic Features
04:26
Grouping Feature of Pivot Table
02:53
Multi-level Pivot Table
03:17
Frequency Distribution
02:39
Pivot Chart
04:08
Pivot Table Slicer
04:43
Update Pivot Table
03:49
Calculated Field and Calculated Item
03:57
GETPIVOTDATA Function
03:38
Chapter 14 – Excel Data Analysis Tools
0/4
Goal Seek
02:27
Solver
05:47
Scenario Manager
05:39
Data Table
07:14
Chapter 15 – Excel VBA – Macros
0/15
Excel VBA Introduction
03:59
Excel VBA Terms
00:00
Save As Macro-Enabled Workbook
00:00
MsgBox Function
02:41
InputBox Function
04:49
Excel VBA Variables
00:00
Excel VBA Constants
00:00
Excel VBA Operators
Excel VBA Decisions
06:13
Excel VBA Loops
03:58
Excel VBA Strings
05:09
Excel VBA Date-Time Function
05:10
Excel VBA Arrays
05:42
Excel VBA User Defined Functions
06:39
Excel VBA Sub Procedures
04:25
Chapter 16 – Excel Advanced Formulas and Functions
0/7
VLOOKUP FUNCTION
03:21
INDEX and MATCH
03:34
SUMIFS
05:33
COUNTIFS
05:09
IFERROR
06:43
CONCATENATE
07:32
TRANSPOSE
07:55
About Lesson


Exercise Files
Chapter5.xlsx
Size: 84.39 KB
Previous
Next