### Dueling Excel 108

September 28, 2016

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

### Highline Excel 2016 Class 03-04 Introduction to Power Query

September 27, 2016

Introduction to Power Query What does Query mean? Query = Ask a Question. Query in Data Analysis = Ask questions of Raw Data and Tables In Excel we will ask Power Query to have the […]

### Highline Excel 2016 Class 03-03 PivotTables

September 24, 2016

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

### Highline Excel 2016 Class 03-01 Sort Data

September 17, 2016

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 Magic Trick 1219

August 8, 2016

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 Magic Trick 1218

August 4, 2016

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 89

July 29, 2016

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

### Highline Excel 2016 Class 02

July 24, 2016

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]

### Highline Excel 2016 Class 01

July 16, 2016

Excel Fundamentals: Efficiency, Data, Data Sets, Formatting DESCRIPTION In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class: (00:33) Prerequisites for class (01:04) Excel Professional 2016 (01:50) Install Com Add-in Power […]

### Excel Magic Trick 1117

April 17, 2015

DESCRIPTION See how to calculate an average for 12 different samples when numbers are in a single column: (00:25) PivotTable (average in one condition/criteria) (02:22) AVERAGEIFS Function (average in one condition/criteria) (05:37) AVERAGE, ROWS and […]