Excel Is Fun

Excel Magic Trick 1267

February 2, 2017 0

DESCRIPTION PivotTable Automatic Date Grouping: New in Excel 2016 See that in Excel 2016, a Date Field from a Table that is dropped into the Row Area of the PivotTable automatically groups into Years, Quarters […]

Dueling Excel

Dueling Excel 127

February 1, 2017 0

DESCRIPTION Adding After & Before Dash: Array Formula or VBA? See Mr Excel and excelisfun use two methods to solve this very difficult adding problem: you must add numbers from a column of text strings […]

Excel Is Fun

Excel Magic Trick 1266

January 30, 2017 0

DESCRIPTION NETWORKDAYS.INTL: Each Employee has Different Weekend Schedule? Learn how to create one formula you can copy down column that will calculate net workdays where each employee has a different weekend schedule. See how to […]

Excel Is Fun

Excel Magic Trick 1265

January 26, 2017 0

DESCRIPTION NETWORKDAYS.INTL Function: Calculate Net Workdays (8 examples) Learn how to use NETWORKDAYS.INTL function to calculate net working days when you are given a start and end date, what days in the week are weekends […]

Dueling Excel

Dueling Excel 126

January 25, 2017 0

DESCRIPTION SUM Daily Totals from Text Dates with Text Day Criteria See Mr Excel and excelisfun use two methods to 1. Add up daily sales from a template that is not setup properly: multiple columns […]

Excel Is Fun

Highline Excel 2016 Class 04

January 24, 2017 0

WReferences: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Tableā€¦ DESCRIPTION In this video learn about: (00:04) Download Files (00:30) Introduction to types of References (01:38) Example 1: Not Copying Formula. Goal: Calculate Net Income. (02:09) Example […]

Excel Is Fun

Excel Magic Trick 1264

January 23, 2017 0

DESCRIPTION Gross Pay From Start & End Date, Weekends Sun & Mon and Weekly Pay Scale Learn how to Calculate Gross Pay From Start & End Date with Weekends of Sun & Mon and a […]

Excel Is Fun

Excel Magic Trick 1263

January 19, 2017 0

DESCRIPTION Power Query M Code: 10 Cross Tabulated Transformed into 1 Proper Data Set Tabulated Transformed into 1 Proper Data Set. These are the steps in using Power Query: 1. Select A1, Ctrl + Shift […]

Dueling Excel

Dueling Excel 125

January 18, 2017 0

DESCRIPTION Conditional Formatting Date Four Days Old & Not Paid See Mr Excel and excelisfun use two methods to Conditional Formatting Date That is Four Or More Days Old & Not Paid 1. Conditional Formatting […]

Excel Is Fun

Excel Magic Trick 1262

January 16, 2017 0

DESCRIPTION Convert Times Values to HHMM Text or Text HHMM Values to Time Values Learn how to use the TEXT function and custom Number Formatting to: (00:12) Convert Times Values to HHMM Text with TEXT […]