Excel Is Fun

Highline Excel 2013 Class Video 05

January 27, 2015 0

Cell References: Relative, Absolute & Mixed (8 Examples) DESCRIPTION (01:09) Relative Reference Example, Net Income Formula. (02:02) Ctrl + Enter to populate a range of cells with a formula. (02:20)┬áRelative and Absolute Reference Example, Increase […]

Excel Is Fun

Highline Excel 2013 Class Video 02

January 24, 2015 0

Comprehensive Excel Formula Types & Elements Video 12 Examples DESCRIPTION (00:39) Overview. (03:31)┬áHours worked formula. Type of Formula: Calculating. Formula Elements: Equal sign, parenthesis, cell reference, math operator, cell reference, parenthesis, math operator, number that […]

Excel Is Fun

Excel Magic Trick 1089

January 13, 2015 0

DESCRIPTION Mr Excel did Month, Year To Date and Variances from data set with GETPIVOTDATA function. See excelisfun do it with Formulas Advanced Filter/Unique List. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1083

January 7, 2015 0

Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data DESCRIPTION See how to Add Invoice Amounts Between Start and End Dates using the SUMIFS function, a start and end date […]