Useful Spreadsheet "tricks" for finance classes

This was made for my finance classes but you can use it too!

  1. 7 Handy Excel Tricks That'll Impress Your Boss [Infographic]

    Gone are the days where marketers were forced to rely on intuition when making important business decisions. Thanks to new and continuous...

  2. Excel Formulas: 10 Formulas That Helped Me Keep My Job

    Don't waste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel formulas to decrease the amount of ...

  3. 5 Spreadsheet Hacks for Excel Users

    On the heels of our recent series on automation and productivity hacks, it occurred to me that some of you might have to do spreadsheets ...

  4. Top 15 Financial Functions in Excel | WallStreetMojo

    Top 15 Financial Functions in Excel - Microsoft Excel is the most important tool of Investment Bankers and Financial Analysts. They spent...

  5. 8 Excel hacks anyone working in accountancy and finance should know | Randstad.co.uk

    Excel has a huge number of features, some of which will be useful to you and others that will not, which is why we've put together a list...

  6. Excel 2016: Pivot Tables Basics & New Features in 2016

    Basic Tutorial on Pivot Tables, Plus new features in 2016: -Auto Detect Table Relationships -Automatic Data Grouping by Hector Garcia, CPA

  7. VLOOKUP function - Office Support

    The VLOOKUP function in Excel finds things in a table or range by row. The secret is to organize your data so that the value you look up ...

  8. Get the best out of Excel using Financial Functions and Formulas

    The recording highlights the use of PMT, NPER, FV and IPMT functions.

  9. Microsoft Excel 2013 - Using Excel's MATCH and INDEX functions

    Using the MATCH and INDEX functions in Microsoft Excel 2013. This video was created by Optimum - the IT Training Consultancy. For more in...

  10. Advanced IF functions - Excel

    This course covers complex variations of the IF function in Excel, including nested IF functions, IF with AND and OR, COUNTIFS and SUMIFS...

  11. Creating Dynamic Excel Charts & Data Tables that Automatically Update.

    Demonstration of how to use Excel data tables & the OFFSET function to create graphs & data tables that dynamically / automatically updat...

  12. Excel: How to use Solver in Excel 2010 / 2013 / 2016

    This video outlines how to use the Solver feature in Excel in the context of sales, costs, and profit forecasts.

  13. How to Create a simple Macro in Excel

    This video shows a beginner how to create a very simple macro in Microsoft Excel. Go to http://bit.ly/Mxx1kF to discover Little-known Sec...

  14. Shortcut keys will be your biggest friend

    Learn them! Shortcut keys will be your biggest friend

  15. Excellence with Excel - Cleaning Up Data - BIWS

    This video will teach you how to clean up poorly formatted data in Excel - a very common scenario when you're working with clients in fin...

Continue learning by following more paths or create your own. Join for FREE

By clicking 'Get Started Free' you agree to our Terms of Service and Privacy Policy