Excel Is Fun

Excel Magic Trick 1470

DESCRIPTION Learn about how to take a rainfall data set with Time-Date Stamps and add rain totals for each day and have the ability to change the definition of the 24 hour period by subtracting [Read More >>>]

Excel Is Fun

Excel Magic Trick 1469

DESCRIPTION Learn about how to take a rainfall data set with Time-Date Stamps and add rain totals for each day and have the ability to change the definition of the 24 hour period. Topics: (00:11) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1468

DESCRIPTION Learn about how Topics: (00:16) Introduction (00:51) Discussion about the two different Data Ribbon Tabs and Get & Transform groups that you may see in Excel 2016 (03:51) Example #1: Clean Data and create [Read More >>>]

Excel Is Fun

Excel Magic Trick 1467

DESCRIPTION Learn about how to Count Open Projects by Day and Project Code, Including Empty Cells with the following Complex Criteria: 1) Start Date Less Than or Equal To Date AND 2) Start Date NOT [Read More >>>]

Excel Is Fun

Excel Magic Trick 1466

DESCRIPTION Learn about how to create Formulas For Start of Month & Number Days in Month From Any Date using the EOMONTH and EDATE Functions. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1465

DESCRIPTION Learn about how to apply Conditional Formatting with a Logical Formula so that dates in a list that are holiday lists show up with the word “Holiday” and with red fill and white font. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1464

DESCRIPTION Learn about how to check whether or not an item in is a list using the MATCH Function. Learn three different formula that may work for your situation: (00:11) Introduction (00:53) Excel New Windows [Read More >>>]

Excel Is Fun

Excel Magic Trick 1463

DESCRIPTION Learn about how to Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA. Topics in Video: (00:11) Introduction (01:19) FORMULATEXT & ISFORMULA & IF Functions to create formula to show formula in cell [Read More >>>]

Excel Is Fun

Excel Magic Trick 1462

DESCRIPTION Learn about how to create a single cell Array Formula to calculate Total Sales from a Column of Units Sold and a column of Prices (5,000 transactions). See how to use SUMPRODUCT function to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1461

DESCRIPTION Copy Quickly Down Column, Excel keyboard shortcuts, Copy Formula Down Column, Excel Keyboards, Keyboard shortcuts in Excel, What does Ctrl + Enter Do?, What does Ctrl + D do?, Excel Ctrl Enter, Excel Ctrl [Read More >>>]