Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel for Beginners
Introduction
Course Agenda (4:58)
What is Excel (3:48)
Understanding & Learning Excel Terminology (13:43)
Understanding Excel Interface (8:59)
Difference Between Workbook Vs Worksheet (6:45)
Diving Deeper Into Excel
Introduction To Workbook And Worksheet Creation (13:36)
Working With Data & Importing Templates (12:07)
Moving & Copying Worksheets (11:59)
Working With Excel Ranges & Navigation (11:15)
Formatting Cells And Ranges (18:20)
Conditional Formatting & Ordering Cells (12:38)
Working With Print-Save-Views (14:51)
Excel Functions
Understanding Order Of Operations (8:29)
Working With Auto-Fill And Functions (15:35)
Understanding Date-Number Formatting (8:57)
Absolute Referencing (13:22)
Conditional Logic (8:54)
Modifying Text (14:46)
Perform Edit Related Functions
Editing Ranges (10:04)
Additional Tools (8:57)
Find & Replace (9:30)
Productive Tools In Excel
Working With Columns Rows (9:29)
Understanding Numeric Format (14:19)
Text Formatting & Borders (7:51)
Format Painter Tool (5:08)
Themes & Cell Styles (6:37)
Zoom & Split Functionality
Zoom Functionality & Split (5:25)
Freeze Panes (10:13)
Adding Comments (12:15)
Understanding Page Breaks & Margins
Page Break & Print Preview (7:15)
Margin Headers (11:26)
Worksheet Options (12:58)
Charts, Graphs & Objects (15:48)
Inserting & Formatting Objects (9:53)
Projects
Project B (19:53)
Project C (13:50)
Resources
Download files here
Working With Data & Importing Templates
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock