Dueling Excel

Dueling Excel 114

October 19, 2016 0

Cross Tabulated AVERAGING 3 Criteria: PivotTable or AVERAGEIFS DESCRIPTION See Mr Excel and excelisfun use two methods to create Cross Tabulated AVERAGING with Three Criteria: Pivot Table or AVERAGEIFS function. See Grouping Numbers in PivotTable […]

Excel Is Fun

Highline Excel 2016 Class 03

October 1, 2016 0

Data Analysis Fundamentals: PivotTables, Power Query & Data Model DESCRIPTION In this video learn about the fundamentals of Data Analysis and Business Intelligence in Excel 2016: Sort, Filter, PivotTables, Power Query, Power Pivot Data Model: […]

Dueling Excel

Dueling Excel 109

September 30, 2016 0

Electoral College: PivotTable or Formulas DESCRIPTION See Mr Excel and excelisfun use two methods to extract records that sum to 270 points using a PivotTable or Formulas. WORKBOOKS

Dueling Excel

Dueling Excel 108

September 28, 2016 0

SUM, AVERAGE, STDEV.S, MIN, MAX: Three Methods DESCRIPTION See Mr Excel and Excelisfun calculate descriptive statistics: MIN, MAX, Standard Deviation, Average using three methods: 1) Data Analysis Toolpak Add-in, Descriptive Statistics 2) PivotTable 3) Functions […]

Excel Is Fun

Highline Excel 2016 Class 03-03 PivotTables

September 24, 2016 0

PivotTables What does a PivotTable do? PivotTables create summary reports that contain aggregate calculations with conditions/criteria. The words “Conditions”, “Criteria” and “Filter” are all synonyms for adding criteria to the calculations in a PivotTable. Example: […]

Excel Is Fun

Highline Excel 2016 Class 03-01 Sort Data

September 17, 2016 0

Basic Data Analysis in Excel: Sort Data 1. Requirement to use Data Analysis features: Features such as: Excel Table feature Sort Filter PivotTable Charts Get & Transform (Power Query) Power Pivot Requirements: Raw Data must […]

Excel Is Fun

Excel Magic Trick 1219

August 8, 2016 0

Paste Special Linked Picture so PivotTable is not Hidden When Filter Applied DESCRIPTION Learn how to create a Linked Picture of a PivotTable: (00:10) Problem Setup (00:25) With a PivotTable next to a Filtered Data […]

Excel Is Fun

Excel Magic Trick 1218

August 4, 2016 0

PivotTable & Slicer To Show Historical Adj Stock Price by Year & Month DESCRIPTION Learn how to use a PivotTable & Filter Slicer To Show Historical Adj Stock Price by Year & Month: (00:10) Problem […]

Dueling Excel

Dueling Excel 89

July 29, 2016 0

PivotTables Grand Totals To Left: LOOKUP or GETPIVOTDATA function? DESCRIPTION See Mr Excel and excelisfun use two methods to shows PivotTable Grand Totals to the left of the PivotTable (Since there is no way to […]