Search
Search
Close this search box.
All   >   Mastering Excel 2019 – Basics

Mastering Excel 2019 – Basics

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

$30 USD

Suggested price per user, ask about bundle discounts

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

 

When you master Excel 2019 or 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 2019. This is our most requested training course!

 

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! 

 

Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives, and include captions and transcripts in 29 languages, downloadable handouts, and optional LinkedIn digital badges on course completion.

Course Contents:

#  Section  #  Lesson  Length 
1  Getting Started   1  Introduction  2:09 
2  Navigating the Interface  8:34 
3  Selecting Data  9:15 
4  Using Commands  7:13 
5  Creating a New Workbook  8:03 
6  Entering Cell Data  5:59 
7  Using AutoFill  7:26 
8  Using Flash Fill  4:59 
9  Using Excel Help  2:04 
2  Performing Calculations  10  Creating Formulas  7:57 
11  Inserting Functions  8:13 
12  Copying Formulas and Functions  7:08 
13  Using Absolute References  9:51 
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:34 
18  Applying Number Formats  7:23 
19  Customizing Number Formats  7:46 
20  Aligning Cell Contents  7:16 
21  Applying Cell Styles  5:20 
22  Applying Themes  3:48 
23  Inserting Hyperlinks  6:30 
24  Applying Conditional Formatting to Numbers  6:44 
25  Applying Conditional Formatting to Text and Dates  7:55 
26  Applying Comparative Analysis Formatting  7:22 
27  Using Templates  6:00 
5  Printing Workbooks  28  Printing Workbooks  4:11 
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:00 
37  Managing Workbook Views  6:22 
38  Managing Workbook Properties  4:13 
7  Customizing Options  39  Customizing General Options  4:35 
40  Customizing the Ribbon  7:02 
41  Customizing the Quick Access Toolbar  6:50 

$30 USD

Suggested price per user, ask about bundle discounts

Related Course Recommendations

Mastering Excel 2019 – Intermediate

Mastering Excel 2019 – Advanced

What’s New in Excel 2019?

Bigger Brains Course Catalog and Pricing

Fill out the information below to receive a download link for our latest course catalog.

I am getting training for…