Top 10 Excel Tips for MBAs

Time Saving Tips
Rating: 4.4 out of 5 (137 ratings)
7,580 students
English
English [Auto]
Save time and work smarter by using our time saving tips!

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

1 section11 lectures1h 0m total length
  • A structured approach to problem solving
    03:32
  • Keyboard efficiency and shortcuts
    06:01
  • Quick navigation to important cells and ranges
    02:46
  • Control Pasting from Other Applications
    05:08
  • Use an index function to perform a lookup across multiple tables
    05:55
  • Create a single lookup to replace multiple formulas
    07:43
  • Arrange and summarize data more efficiently with pivot tables
    06:09
  • Debug a complicated formula by evaluating it part by part
    06:41
  • Create a dashboard to gather and organize outputs
    03:50
  • Use functions to create in cell charts
    05:59
  • Finer control over protections to allow user interaction
    07:06

Instructor

Excel Geek!
Michael B Rochon
  • 4.4 Instructor Rating
  • 137 Reviews
  • 7,658 Students
  • 1 Course

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!