Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Training
Module 1: Getting To Know Your Excel Program
How to navigate its interface (4:23)
When to use Excel (4:15)
How to understand the structure (1:38)
How to use the ribbon in Excel (4:46)
Basic formatting (1:56)
Module 2: Executing Formulas and Functions
Learning the Principles of Excel Formulas (6:30)
Mathematical Calculations and Equations (1:32)
Statistical Functions (3:25)
Date and Time (1:45)
Logical Functions (4:03)
Exercise: Applying Formulas in the Real World (2:20)
Module 3: Organizing and Analyzing Data
Using Macros to Automate Tasks (2:35)
How to Sort Data and Apply Filters (7:25)
Creating Pivot Tables (2:48)
Auditing Formulas and Task (2:32)
Module 4: Presentation
Applying Borders (1:58)
Font and Number Formatting (4:40)
Adding Color to Enhance Data (1:53)
Merging, Wrapping, and Indents (3:50)
Conditional Formatting (1:33)
Printing Worksheets, Sections, and Tables (2:42)
Module 5: Creating Charts and Graphs
Overview of Creating and Reading Excel Charts (6:43)
Column Charts and Bar Graphs (3:38)
Line Graphs (3:29)
Pie Charts (1:32)
Conditional Formatting
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock