Being able to use Microsoft Excel skillfully is crucial for all business professionals who use, analyze, and apply data. Since Excel is the most popular data analysis tool in the workplace, increasing your ability to utilize its advanced features is vital for professional development and success.
Excel expert Kathy Jones will show you how to share workbooks, create digital signatures, and restore a previous version of your workbook. She will demonstrate how to utilize functions to find data, calculate dates, and determine rates and payments. You’ll also learn how to streamline complex functions with LAMBDA and LET. In addition, you’ll learn how to summarize data with PivotTables and how to create and modify PivotCharts.
Because the visual display of data greatly enhances communication and understanding, Kathy will demonstrate how to create and modify waterfall, treemap, and funnel charts to illustrate your information in multiple ways. You’ll learn how to use data map charts and 3-D maps to compare and analyze data. Kathy will also show you how to create a forecast timeline to look at trends in your data.
Finally, you will learn how to record, run, and edit macros so that you can automate repetitive tasks and save valuable time when formatting your worksheets!
Topics covered include:
Enjoy over three and a half hours of high-quality HD content 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.
| # | Lesson | Length |
| 1 | Introduction | 2:09 |
| 2 | Collaborating and Co-Authoring | 5:29 |
| 3 | Digital Signatures | 4:20 |
| 4 | Get and Transform Data | 3:14 |
| 5 | Map Charts | 3:01 |
| 6 | 3D Maps | 8:38 |
| 7 | Waterfall, Treemap, and Funnel Charts | 4:04 |
| 8 | PivotTable Options | 7:34 |
| 9 | Summarize Data in a PivotTable (Part 1) | 6:28 |
| 10 | Summarize Data in a PivotTable (Part 2) | 7:33 |
| 11 | PivotCharts | 8:28 |
| 12 | Data Models | 4:44 |
| 13 | Named Ranges | 7:41 |
| 14 | Creating Internal Links | 7:41 |
| 15 | Creating External Links | 8:25 |
| 16 | INDEX, MATCH, and Sparklines | 9:00 |
| 17 | Date Functions | 9:33 |
| 18 | Information Functions | 8:09 |
| 19 | LAMBDA and LET | 9:57 |
| 20 | Financial Functions | 4:35 |
| 21 | Watch and Evaluate Formulas | 6:52 |
| 22 | Forecast Data Trends | 4:27 |
| 23 | Using Scenarios | 8:28 |
| 24 | Use Solver | 9:21 |
| 25 | Data Analysis ToolPack | 5:08 |
| 26 | Record a Macro | 9:58 |
| 27 | Run a Macro | 5:42 |
| 28 | Edit a Macro | 7:20 |
| 29 | Forms | 9:22 |
| 30 | Customize the Ribbon | 5:32 |
| 31 | Excel Options | 4:39 |
| 32 | Custom Lists | 5:23 |
| 33 | Linked Data Types | 6:02 |
| 34 | Add-ins | 6:33 |
Fill out the information below to receive a download link for our latest course catalog.
