Dueling Excel

Dueling Excel 110

October 5, 2016 0

3 VLOOKUPS Calculate Cost Based on Product, Packaging, Discount DESCRIPTION See Mr Excel and excelisfun use two methods to calculate the total costs when there are three factors that go into calculating costs: Product Name, […]

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

Dueling Excel

Dueling Excel 101

September 9, 2016 0

Sum Numbers from Cells That Contain Both Text & Numbers DESCRIPTION See Mr Excel and excelisfun use two methods to add the numbers from cells that have both numbers and text. See these tricks: 1. […]

Dueling Excel

Dueling Excel 96

August 24, 2016 0

LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type) DESCRIPTION See Mr Excel and excelisfun use two methods to lookup a column of sales amounts in order to create a single cell formula that will add […]

Dueling Excel

Dueling Excel 92

August 10, 2016 0

Round Invoice: ROUND or SUMPRODUCT – ROUND DESCRIPTION See Mr Excel and excelisfun use two methods to round the amounts on an Invoice so the SUM total is correct. WORKBOOKS

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

Excel Is Fun

Highline Excel 2016 Class 01

July 16, 2016 0

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

Dueling Excel

Dueling Excel 81

June 8, 2016 0

Extract Multiple Records Based on Two Criteria VBA or Formula DESCRIPTION See Mr Excel and excelisfun Extract Multiple Records Based on Two Criteria using VBA and formula. See the functions AND, SUM, VLOOKUP, ROWS, COLUMNS […]