Excel Is Fun

Excel Magic Trick 1271

February 16, 2017 0

DESCRIPTION Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? Learn how to extract Top 20 values and dates for those values using Formulas when there are no duplicates, Array Formula for […]

Excel Is Fun

Excel Magic Trick 1270

February 13, 2017 0

DESCRIPTION Calculate Retirement Date with EDATE and EOMONTH functions Learn how to Calculating Retirement Date with EDATE and EOMONTH functions. The rule for calculating the retirement date is: 1. Retirement age is 60 years. 2. […]

Excel Is Fun

Excel Magic Trick 1269

February 9, 2017 0

DESCRIPTION Without Power Pivot: DAX Measures, Relationships & Data Model Using Excel 2016, learn how to access the Data Model, build Relationships between tables and create DAX Measures (Formulas in Pivot Tables) without having PowerPivot […]

Excel Is Fun

Excel Magic Trick 1268

February 6, 2017 0

DESCRIPTION Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List Learn how to build a PivotTable report from two tables without using VLOOKUP. Learn that in Excel 2016 when you add two tables […]

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 […]

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 […]

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 […]

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 […]