Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 26 Minute(s)
Language
English
Taught by
Kieran Luke
Rating
Course Overview
Go from spreadsheet rookie to rockstar
This two-hour Excel crash course is the quickest way to go from spreadsheet rookie to rockstar. It's an accelerated 'learn-by-doing' approach: we'll solve a business problem by designing a model, collecting data and building a spreadsheet. Along the way, we'll cover the keyboard shortcuts, functions and insider 'best practices' to make your spreadsheets sizzle!
Who is this for?
Anyone who has to build Excel models from scratch. If you fall into one of these groups, this course will suit you particularly well:
Business professionals (consultants, analysts, marketers etc)
Students using Excel to analyze data or entering business careers
Entrepreneurs who use Excel to run their startups, to analyze opportunities and to present to investors
What makes this course different?
- It's practical. The instructor worked in consulting at BCG for eight years. That's a lot of Excel. His practical knowledge of how to use Excel in real life, as well as pitfalls and traps to avoid, will save you hundreds of hours of spreadsheet anxiety
- It's efficient. 2.5 hours of the highest quality content
- It uses the 'case-method' pedagogy. By teaching in the context of a real example, retention is significantly higher than a traditional 'formula-led' approach
Course Content
- 1 section(s)
- 15 lecture(s)
- Section 1 Designing and setting up your model
What You’ll Learn
- Ability to design and build well structured models from scratch
- An understanding of how to use what functions, when
- Mastery of time-saving keyboard shortcuts
Skills covered in this course
Reviews
-
CClaudia Oyola
Mejor de lo que esperaba, claro, conciso, útil
-
CCharles Heyworth
GREAT
-
GGuy Cardwell
No review
-
LLillian Buchanan
I learned a lot! It was a lot of information, which is good, but sometimes hard to follow because I use apple products. I wish that the creator would have told us the apple shortcuts along the way because they weren’t helpful at the end once we had already done everything manually with the mouse.
