Useful Spreadsheet "tricks" for finance classes

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

  1. article Completed

    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 continuously improving software, we now have valuable data to enrich our strategies. But organizing and recording it can get a little tricky.

    Edit Remove Move
  2. link Completed

    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 time you spend in Excel and increase the accuracy of your data and your reports. The SUM formula does exactly what you would expect.

    Edit Remove Move
  3. article Completed

    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 more often than I do. And let me tell you, when I do them, it's a project.

    Edit Remove Move
  4. article Completed

    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 more than 70% of the time on preparing Excel Models, formulating Assumptions, Valuations, Calculations, Graphs etc. It is safe to assume that Investment bankers are masters in excel shortcuts and formulas.

    Edit Remove Move
  5. link Completed

    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 of some of the most advantageous hacks for the accountancy industry.

    Edit Remove Move
  6. video Completed

    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

    Edit Remove Move
  7. link Completed

    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 is to the left of the value you want to find. Then use VLOOKUP to find the value.

    Edit Remove Move
  8. video Completed

    Get the best out of Excel using Financial Functions and Formulas

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

    Edit Remove Move
  9. video Completed

    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 information on our Microsoft Office training courses provided in central London, UK - please click here: http://www.optimum.co.uk/microsoft-office/

    Edit Remove Move
  10. link Completed

    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, and AVERAGEIFS and IFERROR.

    Edit Remove Move
  11. video Completed

    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 update when the underlying data changes. http://www.analyticsinaction.com/category/reporting/ I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF

    Edit Remove Move
  12. video Completed

    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.

    Edit Remove Move
  13. video Completed

    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 Secrets That Have Been Hiding Right Under Your Nose. Secrets that will boost Your Excel Skills And Productivity Far Ahead Of Everyone Else. Imagine! Yourself as The Excel Expert!

    Edit Remove Move
  14. embed Completed

    Shortcut keys will be your biggest friend

    Learn them! Shortcut keys will be your biggest friend

    Edit Remove Move
  15. link Completed

    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 finance.

    Edit Remove Move

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