Course Outline - BFI School
Microsoft Excel Course Outline
Microsoft Excel
0% Completed
Beginner – Introduction to Microsoft Excel
Introduction
Video - 00:1:01 mins
About the Course
Video - 00:00:22 mins
Course Outline
Video - 00:4:58 mins
What is Microsoft Excel
Video - 00:00:56 mins
Excel - Applications
Video - 00:1:35 mins
Beginner – Basic Workbook Skills
Download Practice File Here!
Reading
Introduction
Video - 00:00:30 mins
The Excel Interface
Video - 00:4:26 mins
Inputting Values into a cell
Video - 00:1:47 mins
Open, Save and Close Workbook
Video - 00:4:45 mins
Beginner – Managing Worksheets
Introduction
Video - 00:00:27 mins
Naming, Adding and Deleting a Worksheet
Video - 00:2:21 mins
Grouping Worksheet
Video - 00:2:36 mins
Moving and Copying a Worksheet
Video - 00:4:47 mins
Moving Around a Worksheeet
Video - 00:2:47 mins
Beginner – Working with Columns and Rows
Download Practice File Here!
Reading
Introduction
Video - 00:00:27 mins
Selecting, Inserting and Deleting Column and Row
Video - 00:2:26 mins
Adjusting Column Width and Row Height
Video - 00:2:16 mins
Hiding and Unhiding Column & Row
Video - 00:2:02 mins
Grouping and Ungrouping Column & Row
Video - 00:3:01 mins
Editing a Data
Video - 00:5:05 mins
Using the Freeze Pane
Video - 00:2:07 mins
Beginner – Creating simple formulas
Download Practice File Here!
Reading
Introduction
Video - 00:00:31 mins
Excel Order of Operation
Video - 00:4:29 mins
Sum and Autosum with Other Basic Functions
Video - 00:2:33 mins
Average, Min and Max Functions
Video - 00:2:33 mins
Beginner – Formatting Data and Cells
Download Practice File Here!
Reading
Introduction
Video - 00:00:28 mins
Formatting
Video - 00:9:41 mins
Round, Round Up, and Round Down
Video - 00:2:47 mins
Comment
Video - 00:2:55 mins
Beginner – Filling
Download Practice File Here!
Reading
Introduction
Video - 00:00:28 mins
Copying & Filling
Video - 00:5:16 mins
Fill Series
Video - 00:1:33 mins
Fill Series
Video - 00:5:25 mins
Flash Fill
Video - 00:4:58 mins
View Files Side by Side
Video - 00:3:00 mins
Comparing Two Worksheets Side by Side
Video - 00:2:28 mins
Beginner – Page Setup
Introduction
Video - 00:00:28 mins
Download Practice File Here!
Reading
Print Page Setup
Video - 00:9:19 mins
Header and Footer
Video - 00:5:33 mins
Beginner – Sort & Filters
Introduction
Video - 00:00:28 mins
Download Practice File Here!
Reading
Data Sorting
Video - 00:4:50 mins
Advanced Filter
Video - 00:4:48 mins
Filtering Data
Video - 00:5:58 mins
Beginner – Protection
Introduction
Video - 00:00:23 mins
Download Practice File Here!
Reading
Protect File
Video - 00:1:27 mins
Protect Workbook
Video - 00:1:12 mins
Protect Worksheet
Video - 00:2:26 mins
Protect Cells
Video - 00:3:17 mins
Beginner – Hyperlink
Download Practice File Here!
Reading
Hyperlink to Webpage
Video - 00:1:10 mins
Hyperlink to File
Video - 00:1:05 mins
Hyperlink to Sheet
Video - 00:1:24 mins
Beginner – Consolidate
Download Practice File Here!
Reading
Introduction
Video - 00:00:27 mins
Consolidation I
Video - 00:5:35 mins
Consolidation II
Video - 00:2:41 mins
Beginner – Logical Functions
Download Practice File Here!
Reading
Logical Test
Video - 00:1:59 mins
IF Function
Video - 00:5:10 mins
Nested IF
Video - 00:3:32 mins
AND_OR Functions
Video - 00:7:17 mins
IF Function - Examples
Video - 00:5:10 mins
SUMIF and SUMIFS
Video - 00:8:45 mins
COUNTIF and COUNTIFS
Video - 00:3:11 mins
AVERAGEIF and AVERAGEIFS
Video - 00:4:24 mins
ASSESSMENTS – 1
Download Workbook and Complete Tasks
Assignment
Intermediate – Keyboard shortcuts
Download Practice File Here!
Reading
Introduction
Video - 00:00:37 mins
Shortcuts for Formatting, Navigation & Selection
Video - 00:6:31 mins
Shortcuts for Workbook and Working with Data
Video - 00:4:06 mins
Intermediate – Data Formatting techniques
Download Practice File Here!
Reading
Introduction
Video - 00:00:28 mins
Cell Reference
Video - 00:8:48 mins
Cell References- Example
Video - 00:11:28 mins
Conditional Formatting I
Video - 00:11:28 mins
Conditional Formatting II
Video - 00:3:07 mins
Advanced Conditional Formatting
Video - 00:5:45 mins
Conditional Formatting- Examples
Video - 00:8:56 mins
Intermediate – Data Validation Technique and Named Range
Download Practice File Here!
Reading
Introduction
Video - 00:00:33 mins
Data Validation
Video - 00:6:38 mins
Name Range with Formula
Video - 00:4:12 mins
Name Range with Formula
Video - 00:4:07 mins
Intermediate – Excel Functions and Formulas
Download Practice File Here!
Reading
Introduction
Video - 00:00:36 mins
Text Functions
Video - 00:7:29 mins
Date Functions
Video - 00:13:36 mins
Date Function II
Video - 00:5:13 mins
SUMPRODUCT Function
Video - 00:13:35 mins
CHOOSE Function
Video - 00:3:49 mins
Intermediate – Lookup
Download Practice File Here!
Reading
Introduction
Video - 00:00:30 mins
VLOOKUP with Exact Match
Video - 00:8:38 mins
VLOOKUP With Approximate Match
Video - 00:6:05 mins
VLOOKUP Rules and Examples
Video - 00:4:26 mins
HLOOKUP
Video - 00:2:45 mins
LOOKUP Funcion
Video - 00:4:53 mins
MATCH Function
Video - 00:3:43 mins
INDEX Function
Video - 00:2:27 mins
INDEXMATCH - Function
Video - 00:3:27 mins
INDEXMATCH - Examples
Video - 00:4:04 mins
XLOOKUP Function
Video - 00:7:11 mins
Intermediate – Data Presentation Techniques
Download Practice File Here!
Reading
Introduction
Video - 00:00:29 mins
Creating and Formatting a Table
Video - 00:11:31 mins
Creating and Formatting Charts
Video - 00:11:52 mins
Charts Example
Video - 00:3:33 mins
Creating and Modifying Pivot Tables
Video - 00:9:19 mins
ASSESSMENTS – 2
Download Workbook and Complete Tasks
Assignment
Announcements Reviews Live Classes Gradebook Certificate Course Info
PreviousNext