Ultimate Excel Training Bundle
In the toolbox of business software, the most useful application has to be Microsoft Excel. Once you truly learn Microsoft Excel, you can do amazing things: track inventory, calculate budgets, visualize sales trends, and perform sophisticated data analysis.
At Bigger Brains we put special emphasis in our Microsoft Excel training, from working with experienced trainers like Barbara Evers and Kathy Jones, to filming video lessons in our award-winning Teacher/Learner studio format, to creating knowledge reinforcing handouts and practice files.
Now with our new Ultimate Excel Training Bundle, we have packaged the six best Excel training courses into one convenient library, available via our mobile-friendly online classroom or any SCORM or xAPI compliant LMS.
With a combined total of 116 short lessons and over 16 hours of total content, the Ultimate Excel Training Bundle from Bigger Brains is the perfect way to increase your skills with Microsoft Excel.
Available for Excel 2013 or 2016, similar bundle available for 2010.
Mastering Excel – Basics
The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others Who Wish They Were
If you’ve mastered Microsoft Excel then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your first step towards getting started with Microsoft Excel.
- Navigating around Excel
- Creating and saving a Workbook
- Using basic Office features including Undo, Redo, and the Office clipboard
- The basics of Functions and Formulas
- Applying Formatting
- Managing Workbook properties
Mastering Excel – Intermediate
Continue your mastery of Excel with these topics:
- Working with Named Ranges and Tables
- Using Logical, Text, Date, and other Functions
- Sorting, Filtering, and Summarizing Data
- Creating PivotTables and Pivot Charts
- Using Conditional Formatting
- Adding Slicers and Timelines to Analyze Information
Mastering Excel – Advanced
Complete your mastery of Excel with these topics:
- Using Scenarios and Goal Seek
- Working with Macros
- Tracing Precedent and Dependent Cells
- Comparing and Merging Workbooks
- Using 3D References
- Using Data Forms and Form Controls
Excel – Creating Dashboards
Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers
Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards.
Excel – Data Analysis with PivotTables
Get More From Your Excel With The Power Of PivotTables
Pivot Tables are the perfect tool to analyze large amounts of data in Excel. Being able to summarize, visualize, and tabulate your data makes PivotTables an important skill for anyone who uses Excel to store and report on data, and in this course Microsoft trainer Kathy Jones will show you how to effectively use the PivotTable tools in Excel 2013 and 2016.
Excel – Intro to Power Pivot
Learn How To Transform Excel Into Your Big Data Power Tool
Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.