Mastering Excel 365 – Basics

Mastering Excel 365 - Basics

# of Lessons

41

Duration

4:10:07

Skill Level

Basic

MSRP

$30

Instructor(s)

Kathy Jones

Available Captions

Not Captioned

Also Included

Handout, Knowledge Check, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style! 

There are two kinds of people: Those who are masters at Excel 365, and those who wish they were

 

When you master Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel 365.

 

Topics covered include: 

  • Navigating the interface
  • Creating and saving workbooks
  • Selecting and entering data
  • Performing calculations
  • Formatting data
  • Managing multiple worksheets
  • Customizing your options

 

Over four hours of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style!

Course Contents:

# Section # Lesson Length
1 Getting Started  1 Introduction 2:15
2 Navigating the Interface 8:34
3 Selecting Data 8:50
4 Using Commands 7:14
5 Creating a New Workbook 9:08
6 Entering Cell Data 5:59
7 Using AutoFill 7:27
8 Using Flash Fill 4:59
9 Using Excel Help 2:05
2 Performing Calculations 10 Creating Formulas 7:57
11 Inserting Functions 8:14
12 Copying Formulas and Functions 7:09
13 Using Absolute References 9:59
3 Modifying Worksheets 14 Inserting and Deleting Cells 8:50
15 Searching and Replacing 7:54
16 Using Proofing and Researching Tools 6:57
4 Formatting Worksheets 17 Applying Text Formats 8:35
18 Applying Number Formats 7:24
19 Customizing Number Formats 7:46
20 Aligning Cell Contents 7:17
21 Applying Cell Styles 5:20
22 Applying Themes 3:47
23 Inserting Hyperlinks 6:30
24 Applying Conditional Formatting to Numbers 6:45
25 Applying Conditional Formatting to Text and Dates 7:56
26 Applying Comparative Analysis Formatting 7:22
27 Using Templates 6:01
5 Printing Workbooks 28 Printing Workbooks 4:12
29 Setting the Page Layout 6:34
30 Inserting Page Breaks 8:38
31 Configuring Headers and Footers, Part 1 5:09
32 Configuring Headers and Footers, Part 2 4:04
6 Managing Workbooks 33 Managing Worksheets, Part 1 5:02
34 Managing Worksheets, Part 2 7:39
35 Creating a Custom View 3:47
36 Managing Worksheet Views 6:01
37 Managing Workbook Views 6:22
38 Managing Workbook Properties 4:14
7 Customizing Options 39 Customizing General Options 3:57
40 Customizing the Ribbon 7:02
41 Customizing the Quick Access Toolbar 5:40

Related Course Recommendations:

Mastering Excel 365 - Advanced
Microsoft Teams Essentials 2021
Microsoft 365 Office Essentials 2020

Catalog Request

Login Logo