Course Content
Chapter 1 – Introduction
0/5
Menu
01:05
Workbook
01:03
Worksheet
02:19
Quick Access Toolbar
01:31
Column Row Cell Status
01:39
Chapter 2 – Data Entry
0/6
Entering Data
01:49
Auto Fill and Flash Fill
01:34
Dates and Times
01:22
Undo Redo
01:34
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:44
Absolute References
01:58
Auto Sum
04:15
Chapter 4 – Formatting
0/8
Font and Borders
04:44
Column Width and Row Height
03:57
Alignment
04:08
Number
03:05
Date and Time Format
02:03
Conditional Formatting
06:06
Tables
06:11
Illustrations
06:25
Chapter 5 – Worksheet Layout
0/4
Insert and Delete Cells
03:01
Hide and Unhide
02:18
Cut Paste Copy Move
03:34
Find and Replace
04:40
Chapter 6 – Print
0/3
Page Setup and Scale to Fit
12:01
Page Break Preview and Page Layout
05:53
Print
04:53
Chapter 7 – Charts
0/7
Recommended Charts
02:30
Creating Charts
04:04
Chart Formatting Shortcuts
03:06
Change Chart Type
01:56
Formatting Chart Elements
03:13
Trendline
02:03
Sparklines
03:01
Chapter 8 – Worksheet Views
0/2
Freeze Panes and Split
05:38
Auto Outline
03:44
Chapter 9 – Multiple Worksheets and Workbooks
0/2
Linking Data
03:41
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/13
VLOOKUP FUNCTION
03:21
INDEX and MATCH
03:34
SUMIFS
05:33
COUNTIFS
05:09
IFERROR
06:43
CONCATENATE
07:32
TRANSPOSE
07:55
NETWORKDAYS
06:17
SUMPRODUCT
06:31
AVERAGEIFS
06:34
MAXIFS
06:33
RANK
06:40
INDIRECT
05:58
Chapter 17 – Excel Copilot Lessons
0/1
Lesson 1 — Introduction to Excel Copilot
07:17
Exercise Files
Lesson 1 — Introduction to Excel Copilot.pdf
Size: 109.68 KB
Lesson 1 — Introduction to Excel Copilot.xlsx
Size: 8.60 KB
Previous
Next