Top 10 Excel Tips for MBAs
- You should be familiar with the basic functions of Microsoft Excel 2013 or later
Efficient Excel ensures you have a blueprint for what you want to achieve, and the right process and tools to deliver value and drive action. It combines deep problem solving wisdom with cutting-edge Excel craft.
A clear process that helps you to approach unstructured problems and get work done efficiently.
Navigation design for different learning styles - whether you want to learn by listening or watching, our high quality videos use audio and visual cues to reinforce learning.
Many opportunities to practice and continually hone your Excel skills, free workbooks and walkthroughs provided for every video.
- MBA students entering their first year, with basic or intermediate knowledge of Excel.
- A structured approach to problem solving03:32
- Keyboard efficiency and shortcuts06:01
- Quick navigation to important cells and ranges02:46
- Control Pasting from Other Applications05:08
- Use an index function to perform a lookup across multiple tables05:55
- Create a single lookup to replace multiple formulas07:43
- Arrange and summarize data more efficiently with pivot tables06:09
- Debug a complicated formula by evaluating it part by part06:41
- Create a dashboard to gather and organize outputs03:50
- Use functions to create in cell charts05:59
- Finer control over protections to allow user interaction07:06
I was desperate to get better at Excel after clocking late hours at Ernst & Young. After graduating with an MBA from INSEAD, I perfected my Excel and problem solving craft as a general manager at a leading financial services firm.
I am now a co-founder of Efficient Excel and excited to bring all we’ve learned to you!