Dueling Excel

Dueling Excel 80

Chart Titles DESCRIPTION See Mr Excel and excelisfun show some chart title tricks WORKBOOKS

Excel Is Fun

Excel Magic Trick 1207

PERCENTILE.EXC, PERCENTILE.INC, QUARTILE.EXC, QUARTILE.INC DESCRIPTION See how to use the different percentile and quartile functions in Excel:: (00:11) What is a percentile? (00:47) Difference between PERCENTILE.EXC and PERCENTILE.INC functions AND the difference between the QUARTILE.EXC [Read More >>>]

Dueling Excel

Dueling Excel 79

Formula, PivotTable or PowerPivot? PowerPivot Wins For Big Data Sets DESCRIPTION See Mr Excel and excelisfun calculate the percentage of each city in each in each region using the New Excel 2010 % of Parent [Read More >>>]

Excel Is Fun

Excel Magic Trick 1206

Day & Night Shift Time Calculations: Add Total Hours Single Cell Formula DESCRIPTION See how to create a single cell formula that calculates the total hours worked for the week given a column of start [Read More >>>]

Dueling Excel

Dueling Excel 78

Extract Top Two Customers In Each Industry with Formula (2 Examples) DESCRIPTION See Mr Excel and excelisfun Extract Top Two Customers In Each Industry with 2 array Formulas that use the AGGREGATE, IF, COLUMNS, INDEX, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1205

Rearrange Data with INDEX Function & Formula Number Incrementers DESCRIPTION See how to Rearrange Data With INDEX Function & Formula Number Incrementers: (00:00) Problem Setup. (01:57) Formula Number Incrementer to generate the pattern: 1,1,2,2,3,3… or [Read More >>>]

Dueling Excel

Dueling Excel 77

Top Two Customers In Each Industry PivotTable or Sort Filter Formula DESCRIPTION See Mr Excel and excelisfun extract Top Two Customers In Each Industry using a Pivot Table or Sort Filter & Formula with COUNTIF [Read More >>>]

Excel Is Fun

Excel Magic Trick 1204

Conditional Formatting For Day’s Change: Up & Down Icon Arrows DESCRIPTION See how to: Add conditionally format the change in error rate from day to day using the Green, Red and Yellow Arrow Icon Set [Read More >>>]