Excel Is Fun

Excel Magic Trick 1211

Array Operations on Different Size Arrays & CHISQ.TEST Function DESCRIPTION See how to: (00:10) Problem Setup. (01:20) Mixed Cell References to calculate Expected Frequencies (03:20) Array Operations on Different Sized Arrays, and the Resultant Array. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1210

Power Query to Combine 4 Columns into 1 Table For PivotTable Report DESCRIPTION See how to: (00:10) Problem Setup (01:40) Delete Empty Columns (01:55) Create and Name Excel Tables (02:37) Import into Power Query and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1209

BINOM.DIST.RANGE Function for Calculating Binomial Probabilities DESCRIPTION See how to use BINOM.DIST.RANGE Function for Calculating Binomial Probabilities. BINOM.DIST.RANGE Function can calculate individual probabilities or probabilities between an upper and lower x value: (00:10) Introduction to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1208

Combine 4 Columns into 1 Table For PivotTable Report (without Power Query) DESCRIPTION See how to take 4 columns with Survey results for error rates (Yes/No) for the years 2011, 2012, 2013 and 2014 and [Read More >>>]

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

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

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

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

Excel Is Fun

Excel Magic Trick 1203

2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change DESCRIPTION See how to: (00:08) Problem Setup: 2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change (00:48) Create PivotTable (01:21) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1202

Conditional Formatting For a Cross Tabulated PivotTable DESCRIPTION See how to add Conditional Formatting to a Cross Tabulated PivotTable: (00:08) Problem Setup (00:28) Set up PivotTable including Group by Year for Date column and Number [Read More >>>]