Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Microsoft Excel® Training - 8 Hours Online MS Excel Course
Chapter 1: Introduction
Welcome to Master of Project Academy (1:19)
How to Utilize Microsoft Excel Training?
Introduction to Excel (1:00)
What's New In Excel 2019 (7:52)
Course Overview (1:16)
Overview of the Excel window (8:25)
Mouse Features (3:12)
Back Stage View (2:37)
Tip #1 - Join LinkedIn Community & Check out MoPA Blog
Join LinkedIn Community & Follow Latest Updates
Supercharge your Project Game with FREE tips and insights on becoming a project management pro with our Blog. (0:25)
Chapter 2: Creating Workbooks
Entering Text and Numbers (4:31)
Creating Basic Formulas (6:49)
Relative References (3:01)
Order of Operations (4:48)
Working with Ranges (4:14)
Chapter 2 - Practice Exercise (1:35)
Chapter 3: Saving Workbooks
Working with the Save and Save As Commands (4:34)
File Extensions Share Export and Publish Files (3:44)
Chapter 3 - Practice Exercise (0:58)
Chapter 4: Navigating Workbooks
Opening a File (5:32)
Working with Larger Files (5:34)
Freeze Panes Option (3:16)
Split Screen Option (3:21)
Chapter 4 - Practice Exercise (2:49)
Chapter 5: Page Setup & Print Options
Headers and Footers (7:23)
Print Titles (2:52)
Comments (5:23)
Page Setup Options (7:29)
Fit to Print on One Page (3:58)
Printing Workbooks (3:55)
Chapter 5 - Practice Exercise (1:53)
Chapter 6: Working with Rows, Columns and Cells
Adding and deleting rows columns and cells (6:12)
Changing Column and-Row Widths (3:45)
Chapter 6 - Practice Exercise (1:11)
Chapter 7: Moving Data
Cut Copy and Paste (7:07)
Copying Formulas (5:09)
Chapter 7 - Practice Exercise (1:20)
Chapter 8: Formulas & Functions
Overview of Formulas (2:47)
Create Formulas Using Functions part1 (10:03)
Create Formulas Using Functions part-2 (5:24)
Absolute Values (5:16)
Chapter 8 - Practice Exercise (1:20)
Chapter 9: Working with Sheets
Adding Deleting and Renaming Sheets (4:09)
Additional Sheet Tab Options (5:19)
3 Dimensional Formulas (5:28)
Chapter 9 - Practice Exercise (1:31)
Chapter 10: Formatting Worksheets
Formatting Cells part 1 (10:04)
Formatting Cells part 2 (3:38)
Formatting Numbers (9:24)
Borders and Shading (7:08)
Format as Table (6:07)
Using Styles (3:49)
Using Format Painter (4:29)
Protecting Sheets (9:00)
Fill Handle and Custom Lists (7:17)
Chapter 10 - Practice Exercise (1:10)
Chapter 11: Charts
Creating Charts (9:48)
Types of Charts (5:58)
Editing Charts Part 1 (11:00)
Editing Charts Part 2 (3:16)
Using Graphics to Enhance Charts (5:05)
Linking Chart Titles (2:51)
Chapter 11 - Practice Exercise (0:53)
Chapter 12: Working with Names
Creating Range Names (0:35)
Managing Names (3:17)
Using Names in Formulas (5:58)
Chapter 12 - Practice Exercise (1:20)
Chapter 13: Sorting and Filtering
Remove Duplicates (7:45)
Sort Data (10:28)
Filter Data (7:38)
Advanced Filters (4:46)
Chapter 13 - Practice Exercise (0:57)
Chapter 14: Outlining and Subtotaling
Creating an Outline (6:01)
Subtotals (8:00)
Chapter 14 - Practice Exercise (1:07)
Chapter 15: Working with Views
Arranging Files (3:14)
New Window Option (2:45)
Custom Views (5:32)
Chapter 15 - Practice Exercise (1:07)
Chapter 16: Linking Files
Creating Formulas Between Files (6:35)
Working with Links (4:01)
Consolidating Data (5:16)
Chapter 16 - Practice Exercise (1:30)
Chapter 17: Advanced Formula Creation
If Statements (7:49)
VLookups (7:39)
Data Validation (8:13)
Formula Auditing (5:29)
Chapter 17 - Practice Exercise (1:19)
Chapter 18: Pivot Tables
Pivot Tables (9:36)
Pivot Charts (3:16)
Chapter 18 - Practice Exercise (0:56)
Chapter 19: Additional Excel Features
Slicers (4:39)
Goal Seeker (2:56)
Text to Columns (2:50)
Watch Window (2:32)
Customizing Ribbons and Tabs (3:25)
Chapter 19 - Practice Exercise (1:23)
Chapter 20: Shortcuts
Excel Shortcuts That Every User Should Know (12:00)
Chapter 21: Closing
Closing Video (0:37)
End of Course Quiz
End of Course Quiz - Web Version
End of Course Quiz - PDF Version
How to Submit a PDU Claim (For Retaining PMP Certificate)
How to Submit PDUs
Bonus Lecture - Discount for our paid courses
Bonus Lecture - Discount for our paid courses
Important Notice About Certificate of Completion
Important Notice About Certificate of Completion
Fit to Print on One Page
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock