Excel Is Fun

Excel Magic Trick 1212

What To Do If You Filter Data Set & Chart Disappears DESCRIPTION See how to: (00:10) Problem Setup (00:29) Keyboard to highlight Columns NOT next to Each Other (Non-contiguous data) (01:02) Make Line Chart for [Read More >>>]

Dueling Excel

Dueling Excel 84

Count Calls Every 15 Minutes Count Times Between Upper & Lower Limit DESCRIPTION See Mr Excel and excelisfun use two methods to count calls every 15 minutes: 1. a PivotTable and a Helper Column using [Read More >>>]

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

Dueling Excel

Dueling Excel 83

PowerPivot or Helper Column & PivotTable & Custom Number Format DESCRIPTION 1. See Mr Excel and excelisfun try to take a database with repeat names of students with failing Grades and create a unique list [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 >>>]

Dueling Excel

Dueling Excel 82

Allow Below Limit: Data Validation or Conditional Formatting DESCRIPTION See Mr Excel and excelisfun prevent cell from accepting a value above a limit using Data Validation and Conditional Formatting. WORKBOOKS

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

Dueling Excel

Dueling Excel 81

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

Dueling Excel

Dueling Excel 80

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