### Highline Excel 2016 Class 04

January 24, 2017

WReferences: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table… DESCRIPTION In this video learn about: (00:04) Download Files (00:30) Introduction to types of References (01:38) Example 1: Not Copying Formula. Goal: Calculate Net Income. (02:09) Example […]

### Highline Excel 2016 Class 03

October 1, 2016

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

### 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-02 Filter

September 20, 2016

Highline Excel 2016 Professional Class taught by Michael excelisfun Girvin WORKBOOKS Highline Excel 2016 Class 03 Start Workbook Highline Excel 2016 Class 03 Finished Workbook Highline Excel 2016 Class 03 2015 Data Highline Excel 2016 […]

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

### Highline Excel 2016 Class 02-03 3 Ways to Enter Cell References Into Formulas

August 13, 2016

3 ways to enter cell references into formulas: 1. Type: Be careful, though, errors may occur. 2. Mouse: Great for when cell reference is far away. 3. Arrow keys: great for when cell references are […]

### Highline Excel 2016 Class 02-02 Error Messages

August 9, 2016

Error Messages Four Steps to finding errors (wrong answer or error message) in formulas: 1. Look at Formula, Look at Range Finder F2 Key puts formula in Edit Mode and shows the rainbow colored Range […]

### Highline Excel 2016 Class 02-01 Excel’s Golden Rule

August 6, 2016

Excel’s Golden Rule Full Rule: If a formula input can change, put it into a cell and refer to it in the formula with a cell reference. If a formula input will not change, you […]

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