We’ll periodically update this story as new. You can get a quick overview of all the formulas you’ve used in a spreadsheet by pressing the Ctrl + ~ keys on your keyboard. It’s easy to use Excel for many of your day-to-day number-crunching tasks, like determining your business’s average sale, computing classroom grades, or forecasting college expenses. Formulas are expressions that take values from a range of cells or a single cell, and output a value. , to ) =DATE – Returns a number that represents the date (yyyy/mm/dd) in Excel. Below are the cheat sheets! VBA CHEAT SHEETS Description VBA Code Activate by Tab Name. Excel, click on the buy now button and grab a copy of this book today! Mr.

Excel formulas cheat sheet SHEETS() THE MICROSOFT EXCEL FORMULAS CHEAT SHEET DATE AND TIME FORMULAS Show today’s date in a cell =NOW Show the date and time Show the current date =TODAY() without the time Show current month in a cell =MONTH(TODAY()) Add 10 days to current date =TODAY()+10 =DAY(TODAY()) COUNTING AND ROUNDING FORMULAS Calculates the sum of a group of values =SUM Download my Excel workbook where I have listed 100+ common and basic Microsoft Excel Formulas and Functions Cheat Sheets for your daily use.