Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Top 10 Excel Tips for MBAs
Rating: 4.4 out of 5(200 ratings)
11,190 students

Top 10 Excel Tips for MBAs

Time Saving Tips
Created byMichael B Rochon
Last updated 9/2018
English

What you'll learn

  • Save time and work smarter by using our time saving tips!

Course content

1 section • 11 lectures • 1h 0m total length

  • A structured approach to problem solving3:32

    Overview of Efficient Excel's problem solving process and our full platform

  • Keyboard efficiency and shortcuts6:01

    What are some ways I can use my keyboard instead of my mouse in order to work more quickly?  #shortcuts #keystrokes

  • Quick navigation to important cells and ranges2:46

    I want to navigate to specific components of my work more quickly. How can I do this more efficiently #goto #namedranges #shortcuts

  • Control Pasting from Other Applications5:08

    When I paste data and items from other applications, I don't get what I expect.  #copy #paste #pastespecial #PowerPoint #pdf

  • Use an index function to perform a lookup across multiple tables5:55

    I need to lookup sales for a particular region, quarter and category. How can I perform all 3 lookups in a single function? #index #match #vlookup

  • Create a single lookup to replace multiple formulas7:43

    I need to do a lookup for multiple columns of info. Do I need to create multiple formulas or is there a quicker way to do this with a single formula?  #vlookup #match #cellreferencing

  • Arrange and summarize data more efficiently with pivot tables6:09

    Creating an accurate and well-organized table of data analysis takes a lot of time. How can Excel improve my efficiency?  #pivottable

  • Debug a complicated formula by evaluating it part by part6:41

    I have a formula evaluating to an error, but I feel like I am doing everything right. How do I find out which part of my formula is returning the error?  #shortcut #formula #evaluate

  • Create a dashboard to gather and organize outputs3:50

    The interesting outputs are scattered over multiple tables and sheets. How can I pull them all together? #dashboards #grouping #alignment #copy #paste #formatting

  • Use functions to create in cell charts5:59

    I want more control over in-cell charts - what functions are available to help with this? #formatting #REPT

  • Finer control over protections to allow user interaction7:06

    I've locked my model to keep it safe, but now other users can't interact with it. Is there a way to do both? #protection #sharing #formatting

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.

Report abuse