Open links in new tab
  1. Copilot Answer
    Corporate Finance Institute
    https://corporatefinanceinstitute.com › resources › excel › excel-formulas-cheat-sheet

    Excel Formulas Cheat Sheet - Important Excel Formulas to Know

    • List of Excel shortcuts– a list of the most important Excel shortcuts to speed up financial modeling. See more

    Dates and Time Excel Formulas Cheat Sheet

    =EDATE– add a specified number of months to a date in Excel
    =EOMONTH – convert a date to the last day of the month (e.g., 7/18/2018 to 7/31/2018)… See more

    Corporate Finance Institute
    Navigation Excel Formulas Cheat Sheet

    Go To Special– press F5 and find all cells that are hard-coded, formulas, and more. Great for auditing.
    Find and Replace– press Ctrl + F and you can chang… See more

    Corporate Finance Institute
    Lookup Formulas

    INDEX MATCH– a combination of lookup functions that are more powerful than VLOOKUP
    =VLOOKUP – a lookup function that searches v… See more

    Corporate Finance Institute
    Math Functions Excel Formulas Cheat Sheet

    =SUM – add the total of a series of numbers
    =AVERAGE – calculates the average of a series of numbers
    =MEDIAN … See more

    Corporate Finance Institute
    What are Excel formulas & how do I use them?
    Excel is one of the most powerful accounting software tools out there, and most of that power comes from the ability to use Excel formulas to automate your work. When you’re first learning how to use them, it’s easy to get a little overwhelmed – luckily, this Excel formulas cheat sheet is here to help you make sense of it all!
    excel-university.com
    Feedback
    Table of Contents
    Dates and Time Excel Formulas Cheat Sheet
    Navigation Excel Formulas Cheat Sheet
    Lookup Formulas
    Math Functions Excel Formulas Cheat Sheet
    What are Excel formulas & how do I use them?
     
  2. Some results have been removed