Overview of the Excel window | Master of Project Academy

Autoplay
Autocomplete

Previous Lesson 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

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

Teach online with

Overview of the Excel window

Complete and Continue

Discussion

1 comments