- Duration: 65 Hours
Course details
Unlock the secrets of Excel and master spreadsheets.
Hone your skills in one of the most important, universal areas in the modern knowledge workers day to day job, and become indispensable.
However, we know Excel can be mystifying and intimidating to many people.
This bundle is perfect for beginners all the way through to data and financial analysts interested in solving complex business problems. We've established ourselves as the Excel experts in the last 9 years, and you won't find better, or more thorough content anywhere else.
What you get with this Ultimate Microsoft Excel Bootcamp package:
- 4 business focused Excel courses
- 280 modules of training, covering the most business-relevant areas of Microsoft Excel.
- 190+ videos and over 130 downloadable exercises.
- Tailored learning. If you have some Excel knowledge, you can use the filter to show only what you most need to learn.
- Multiple videos, practice exercises and test questions to aid your learning.
- Knowledge to understand the data that drives your business.
The courses this bundle will cover:
Microsoft Excel:
- How Excel works, how to navigate and design a spreadsheet
- The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
- To use PivotTables, Pivot Charts and Basic Macros
- To create beautiful looking graphs and charts
- Formatting, including; conditional, cell and number formatting
- How to print what you want
- Use advanced graphs in minutes instead of wasting hours trying to figure them out
- Increase interactivity by automating your spreadsheets with macros and VBA
- Solve complex problems with superpower functions
- Turn raw data into must make decisions using PivotTables and PowerPivots.
- And more!
- The primary uses of pivot tables
- How to identify the best and worst data sets
- To filter, sort and group PivotTable"! data to maximise its usefulness
- How to present your data clearly using PivotCharts and Conditional Formatting
- How to turn buckets of data into sound business decisions
- Financial modelling theory
- Essential Excel analysis techniques such as Dynamic Ranges, and Advanced Charts
- How to effectively and clearly present your findings to relevant stakeholders
- Different forecasting techniques, including Moving Averages and Regression
About Excel with Business
Formed in 2009, Excel with Business was created by founders Marc, Vin and Chris to solve a problem close to their hearts – ineffective Microsoft Excel training. As three Strategy and Management Consultants they understood the importance of being able to apply MS Excel skills in a business context. The main issue was that too many Excel courses were focussing on the software functionality rather than how that was applicable in business. They taught everything, creating long and laborious courses – rather than focusing on the most business-relevant parts of Excel… so an idea was born:
A business relevant Excel training course that was affordable and personalised to each person taking it.
The first Excel course quickly attracted over 100,000 users. Fast forward a few years and we have expanded our focus on improving personal productivity and helping people achieve their career ambitions through a comprehensive library of 50+ Microsoft and Business training courses. The principles of getting the right training to the right user remain and has become more sophisticated through the introduction of the filter on many courses.
See all Excel with Business courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- USD 200Duration: Upto 155 Hours
- Level 3 Diploma in Microsoft Excel John AcademyUSD 25
USD 400Duration: 33 Hours
