Dueling Excel

Dueling Excel 123

January 4, 2017 0

DESCRIPTION Lookup Column and then Add With Criteria See Mr Excel and excelisfun use two methods to lookup a column based on a date and then add all the values for the North Region 1. […]

Excel Is Fun

Excel Magic Trick 1250

November 24, 2016 0

DESCRIPTION Add Times to Get Total Minutes & Seconds From Downloaded Music Data Learn how to add times to show total minutes and seconds for copy and pasted downloaded music data. Learn about Time Math, […]

Dueling Excel

Dueling Excel 118

November 9, 2016 0

DESCRIPTION Formula To Calculate Commissions for Four Scenarios See Mr Excel and excelisfun use two methods to calculate the commissions based on the fact that the two sales people may both be at work for […]

Dueling Excel

Dueling Excel 112

October 12, 2016 0

Two Way Lookup Cell Address to Create Dynamic Range: Formula or VBA DESCRIPTION See Mr Excel and excelisfun use two methods to lookup a cell reference in a two way table and create a dynamic […]

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