Excel Formulas Cheat Sheet: Shortcuts for Date, Time, Counting, Rounding, Conversion, Lecture notes of Finance

Download Excel Formulas Cheat Sheet: Shortcuts for Date, Time, Counting, Rounding, Conversion and more Lecture notes Finance in PDF only on Docsity! MICROSOFT EXCEL SHORTCUT KEYS THE MICROSOFT EXCEL FORMULAS CHEAT SHEET DATE AND TIME FORMULAS Show today’s date in a cell Show the date and time=NOW Show the current date without the time=TODAY() 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 Calculates the mean of a group of values=AVERAGE Counts the number of cells in a range that contains numbers=COUNT Removes the decimal portion of a number=INT Rounds a number to a specified number of decimal places=ROUND Returns the date, without the time=NOW Tests for a true or false condition=IF Rounds 1.45 to one decimal place=ROUND(1.45, 1) Count the number of non-blank cells in a range=COUNTA(A1:A5) Returns the date, without the time=TODAY Calculates the mean of a group of values=AVERAGE Returns the logical value TRUE=TRUE Rounds -1.457 to two decimal places=ROUND(-1.457, 2) Returns the logical value FALSE=FALSE MICROSOFT EXCEL SHORTCUT KEYS COUNTING AND ROUNDING FORMULAS (CONT.) Calculates the sum of a group of values=COUNTIF Calculates a sum from a group of values in which a condition has been met` =SUMIF Returns TRUE if all of its arguments are TRUE=AND Returns TRUE if any argument is TRUE=OR UNIT CONVERSION FORMULAS Converts value of A1 from days to hours =CONVERT(A1,”DAY”,”HR”) Converts value of A1 from Celsius to Fahrenheit =CONVERT(A1,”C”,”F”) Converts value of A1 from hours to minutes =CONVERT(A1,”HR”,”MN”) Converts value of A1 from teaspoons to tablespoons =CONVERT(A1,”TSP”,”TBS”) Converts value of A1 from years to days =CONVERT(A1,”YR”, “DAY”) Converts value of A1 from gallons to liters !ERROR! A1 does not contain a number or expression Converts value of A1 from miles to kilometers =CONVERT(A1,”MI”,”KM”) Converts value of A1 from centimeters to inches =CONVERT(A1,”CM”,”IN”) Converts value of A1 from kilometers to miles =CONVERT(A1,”KM”,”MI”) Converts binary 1100100 to decimal (100) =BIN2DEC(1100100) Converts a number into a Roman numeral =ROMAN Converts value of A1 from inches to feet =CONVERT(A1,”IN”,”FT”)