Excel Is Fun

Excel Magic Trick 1127

April 27, 2015 0

DESCRIPTION See how to automate the tracking of and the Current and Ending Amounts for Budget Categories using The Excel Table feature, Data Validation drop-down list, the SUMIFS function, and Page Setup for printing. (00:08) […]

Excel Is Fun

Excel Magic Trick 1126

April 26, 2015 0

DESCRIPTION See how to complete a monthly employee calendar with the text “Training” based on a start and end date, and holiday and weekend dates. See the functions: IFERROR, WORKDAY.INTL, IF, AND, and NETWORKDAYS.INTL. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1125

April 25, 2015 0

DESCRIPTION See how to use Data Validation Custom Formula to verify that dates entered into cells are in current month and are NOT a weekend or holiday. See the AND and NETWORKDAYS.INTL functions as well […]

Excel Is Fun

Excel Magic Trick 1124

April 24, 2015 0

DESCRIPTION See how to Conditional Format Weekends & Holidays using the NETWORKDAYS.INTL & NOT functions. Conditionally format serial dates for weekends and holidays. Conditional Formatting. Format Conditionally. Logical Formulas. Format holidays and weekends. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1123

April 23, 2015 0

DESCRIPTION See how to… Create a formula To Create A List of Dates For Month. Change the start date and the list updates. See the functions, EOMONTH, DAY, IF, ROWS. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1122

April 22, 2015 0

DESCRIPTION 1. Excel 2010 or later formula when day is indicated with the number 1 2. Formula Excel 2010 or later formula when day is indicated with the number 1 or an “x” 3. Excel […]

Excel Is Fun

Excel Magic Trick 1121

April 21, 2015 0

DESCRIPTION See how to: Calculate Compounding Rate/Geometric Mean with the new RRI function in Excel 2013 WORKBOOKS

Excel Is Fun

Excel Magic Trick 1120

April 20, 2015 0

DESCRIPTION See how to create a Logical Formula that will check whether an item in in all three lists using 2 MATCH functions and the ISNUMBER function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1119

April 19, 2015 0

DESCRIPTION See how to: 1. Create formula for Conditionally Formatting a Date when 44 days have passed 2. Create formula to Conditionally Formatting the whole row when 44 days have elapsed after a given date. […]

Excel Is Fun

Excel Magic Trick 1118

April 18, 2015 0

DESCRIPTION See how to Extract Word That Occurs Most Frequently: (00:07) MODE calculation for text. (00:57) COUNTIFS function for basic mode calculation (01:38) INDEX, MODE and MATCH function (with function argument array operation) to extract […]