All   >   Learning Excel 2019 – Beginner (TOSA)

Learning Excel 2019 – Beginner (TOSA)

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

Course details

When you master Excel, you have one of the most practical and valuable skillsets in modern business. A spreadsheet expert can work wonders—from organizing lists to creating multi-layered interactive reports; from answering critical business questions to managing budget allocations and tracking expenses. In this course you’ll start and the beginning to learn how to navigate Excel efficiently. Then you’ll create new workbooks, enter data, start creating calculations, and format your data. In no time at all, you’ll have a functioning workbook you can use to organize your data. 

 

Take this course and make your first move to becoming an expert at using Excel 2019. Material in these modules is aligned with the Level 1 – Beginner User TOSA Certification. You’ll be learning the fundamental features and functions of Excel. 

 

Topics covered include: 

  • Navigating Excel’s interface 
  • Creating and saving workbooks 
  • Selecting and entering data 
  • Performing basic calculations 
  • Formatting text, numbers, and cells 
  • Sorting and filtering data 
  • Changing chart types 
  • Printing worksheets 

 

Enjoy over two 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 Navigating the Interface 8:42
2 Selecting Data 9:15
3 Using Commands 7:14
4 Creating a New Workbook 8:04
5 Entering Cell Data 5:59
6 Using Excel Help 2:05
2 Formulas and Functions 7 Creating Formulas 7:57
8 Inserting Functions 8:14
9 Using Absolute References 9:51
3 Formatting 10 Applying Text Formats 8:35
11 Applying Number Formats 7:24
12 Customizing Number Formats 7:46
13 Applying Cell Styles 5:20
14 Applying Conditional Formatting to Numbers 6:45
15 Applying Conditional Formatting to Text and Dates 7:56
4 Printing 16 Printing Workbooks 4:12
17 Setting the Page Layout 6:34
5 Sorting and Filtering 18 Sorting Data 5:18
19 Filtering Data 5:20
6 Other 20 Using Chart Types 2:27
21 Ideas in Office 365 2:06

Course details

Related Course Recommendations

Power BI – Using Visuals (2024)

Power BI - Using Visuals (2024)

Microsoft Teams Fundamentals (2024)

Microsoft Teams Fundamentals (2024)

Power BI – Data Modeling (2024)

Power Bi - Data Modeling (2024)

Windows 11 Essentials (2024)

Windows 11 Essentials

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…