Microsoft Excel has been the power tool for data analysis since it first appeared for the Mac in 1985. Since then it’s grown from a pretty garden-variety spreadsheet to a complex and feature-filled app for analyzing numbers, creating charts, and more. Many jobs require a good background in Excel, so if you want to get ahead in business it is an excellent idea to know the app inside and out. Our Ultimate Excel Bootcamp Bundle will get your skills to the level you need to be a pro, and you’ll have lifetime access to the courses for $49.
Four classes are included:
Microsoft Excel: Take a 32-Hour Deep Dive Into All Things Excel
- Access 160 lectures & 32 hours of content 24/7
- Learn how Excel works, how to navigate it, & how to design a spreadsheet
- Discover the most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
- Use PivotTables, Pivot Charts, & basic macros
- Create beautiful graphs & charts
- Understand formatting including conditional, cell, & number formatting
Business Analysis: Learn to Crunch Numbers Like a Pro & Become a Data Analytics Superstar
- Learn how to turn buckets of data into sound business decisions
- Explore financial modeling theory
- Discover essential Excel analysis techniques such as Dynamic Ranges & Advanced Charts
- Understand how to effectively & clearly present your findings to relevant stakeholders
- Practice different forecasting techniques, including Moving Averages & Regression
PivotTable: Master One of Excel’s Most Powerful Features
- Access 11 lectures & 6 hours of content 24/7
- Learn the primary uses of PivotTables
- Discover how to identify the best & worst data sets
- Filter, sort, & group PivotTable data to maximize its usefulness
- Present your data clearly using PivotCharts & conditional formatting
- Create great looking management reports using a PivotTable
Advanced Excel: Master the Most Powerful Spreadsheet Software in Industry
- Access 20 lectures & 16 hours of content 24/7
- Use advanced graphs in minutes instead of wasting hours trying to figure them out
- Increase interactivity by automating your spreadsheets w/ macros & VBA
- Solve complex problems w/ superpower functions
- Turn raw data into ‘must make’ decisions using PivotTables & PowerPivots
If you’re not completely satisfied with the courses within 15 days of purchase, you can get a no-questions-asked refund for store credit.
