Excel 2013 PowerPivot Basics

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

Dueling Excel

Dueling Excel 020

DESCRIPTION See Mr Excel and excel is fun summarise survey data with a Pivot Table (Grouping & Report Filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function. Adding Counting [Read More >>>]

Dueling Excel

Dueling Excel 007

DESCRIPTION See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) excelisfun uses a formula with INDEX, IF, [Read More >>>]

Excel Is Fun

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