Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 04

DESCRIPTION See two examples of Array Formulas and two examples of PowerPivot DAX formulas that count unique values in a column (Distinct Count) and compare and contrast: (00:09) Array Formula For counting unique values using [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 03

DESCRIPTION See how to replace VLOOKUP with Excel 2013 Data Model and Relationships. See how to get two or more tables into a PivotTable Field List: (00:11) Get Two Tables into an Excel 2013 PivotTable [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 01

DESCRIPTION Basics of PowerPivot: Why PowerPivot?, Add to Data Model, Relationships, Calculated Column, Calculated Field, Build report with PivotTable based on Data Model: (00:22) Smartest People with PowerPivot (01:31) Which Versions of Excel 2013 contain [Read More >>>]

Excel Is Fun

Excel Magic Trick 1112

DESCRIPTION (01:06) Group By Date In PivotTable Error (Cannot group that selection error) (01:42) Text To Columns To Convert Text Dates To Dates (02:53) Text To Columns Fatal Error (Microsoft Excel has stopped working error) [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 10

DESCRIPTION Topics in this video: (00:34) AND Criteria for SUMIFS, COUNTIFS, AVERAGEIFS (05:18) DSUM (07:53) SUMIFS with 3 criteria. (10:36) Use COUNTIFS or COUNTIF for 1 condition? (12:35) Use SUMIFS or SUMTIF for 1 condition? [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 01

Back To Basics: Number Format, Keyboards, PivotTables, Formulas DESCRIPTION (0:01:14) Cells, Worksheets, Sheet Tabs and Workbooks. (0:02:14) Navigating Sheets in Excel 2013. (0:03:30) Keyboards. (0:08:51) Number Formatting as Façade. (0:21:36) Types of Data in Excel. (0:23:20) Alignment. (0:27:47) Proper Data Sets, Non-Proper [Read More >>>]