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
Formatting Cells part 1
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock