=EOMONTH – convert a date to the last day of the month (e.g., to )

=EDATE – add a specified number of months to a date in Excel Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts – a list of the most important Excel shortcuts to speed up financial modeling.ĭates and time Excel formulas cheat sheet Keyboard shortcuts speed up your modeling skills and save time. List of Excel shortcuts Excel Shortcuts PC Mac Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. If you’re already a power user, check out our Advanced Excel Course and learn the most powerful combinations of formulas and functions.

However, if you want a video explanation of the formulas, check out our Free Excel Crash Course. We’ve built an Excel formulas cheat sheet of the most important formulas and functions required to become a spreadsheet power user.īelow is a written overview of the main formulas for your own self-study. If you want to become a master of Excel financial analysis and an expert on building financial models then you’ve come to the right place.

Excel spreadsheet