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:
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.
# | 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 |
This website uses cookies to improve your experience. Please select whether you would like to accept our decline tracking technologies and cookies. https://getbiggerbrains.com/privacy-policy/ Read More
Fill out the information below to receive a download link for our latest course catalog.