Dueling Excel 044

Count Mondays Between 2 Dates WEEKDAY or TEXT? DESCRIPTION See Mr Excel and excelisfun count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and [Read More >>>]

Dueling Excel 038

Weekly Report Formula or Pivot Table? DESCRIPTION See Mr Excel and excelisfun take daily transactional data and create Weekly Summary Reports using a Pivot Table (PivotTable) and a series of formulas. Learn about: 1.Formula for [Read More >>>]

Excel Magic Trick 1146

Create ISO Dates using TEXT function and Custom Number Format DESCRIPTION See how to: 1. Create ISO Dates using TEXT function and Custom Number Format. Like; =TEXT(A5,”yyyymmdd”) 2. Compare two columns of formulas to check [Read More >>>]

Excel Magic Trick 1145

Create Random Data Set with Formulas: 4 Unusual Formulas DESCRIPTION See how to: (00:08) Overview of Different data Types (01:02) FORMULA 1: Create Random Serial Number Dates with RANDBETWEEN and actual Serial Numbers (02:10) Keyboards [Read More >>>]

Excel Magic Trick 1144

Top 3 TEXT Function uses ISO Date to Date , Text Time To Time , Date To Month DESCRIPTION See how to: (00:07) Text Function and Custom Number Formatting (01:08) Convert Serial Number Date To [Read More >>>]

Excel Magic Trick 1140

VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels DESCRIPTION See how to Create Text Formulas For Finance Tests where you can change the variables PV, APR, Years and compounding periods per [Read More >>>]

Excel 2013 Power Query 03

DESCRIPTION See how to import three text files (Tab Delimited) that contain Student Grade Data for a 35 year period using the Power Query 1 Step Method, and then make an amazing Pivot Chart with [Read More >>>]

Excel 2013 PowerPivot Basics 07

DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name [Read More >>>]

Excel Magic Trick 1088

DESCRIPTION Show All B7 values From Across Sheets that are Named 01, 02, 03, …10, 11… using the functions: INDIRECT, TEXT and ROWS WORKBOOKS