Requirements
- You should be familiar with the basic functions of Microsoft Excel 2013 or later
Description
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.
We offer:
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.
Who this course is for:
- MBA students entering their first year, with basic or intermediate knowledge of Excel.
Course content
- 03:32A structured approach to problem solving
- 06:01Keyboard efficiency and shortcuts
- 02:46Quick navigation to important cells and ranges
- 05:08Control Pasting from Other Applications
- 05:55Use an index function to perform a lookup across multiple tables
- 07:43Create a single lookup to replace multiple formulas
- 06:09Arrange and summarize data more efficiently with pivot tables
- 06:41Debug a complicated formula by evaluating it part by part
- 03:50Create a dashboard to gather and organize outputs
- 05:59Use functions to create in cell charts
- 07:06Finer control over protections to allow user interaction
Instructor
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!