Excel Is Fun

Highline Excel 2016 Class 04

January 24, 2017 0

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

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

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

September 20, 2016 0

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

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

Highline Excel 2016 Class 02-02 Error Messages

August 9, 2016 0

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

Excel Is Fun

Highline Excel 2016 Class 02

July 24, 2016 0

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