Excel Is Fun

Highline Excel 2013 Class Video 01

January 23, 2015 0

Back To Basics: Number Format, Keyboards, PivotTables, Formulas DESCRIPTION (0:01:14) Cells, Worksheets, Sheet Tabs and Workbooks. (0:02:14) Navigating Sheets in Excel 2013. (0:03:30) Keyboards. (0:08:51) Number Formatting as Façade. (0:21:36) Types of Data in Excel. (0:23:20) Alignment. (0:27:47) Proper Data Sets, Non-Proper […]

Excel Is Fun

Excel Magic Trick 1093

January 22, 2015 0

Extract Date from Middle of Description: Text To Columns or Formula? DESCRIPTION Extract Date from Middle of Description: Text To Columns or Formula: 1. Text To Columns 2. Formula that uses the functions SUBSTITUTE, REPLACE, […]

Excel Is Fun

Excel Magic Trick 1092

January 21, 2015 0

DESCRIPTION See how to build an array formula that uses the COUNTIF & SUMPRODUCT functions as well as a function argument array operation, a comparative array operation and a math array operation in a single […]

Dueling Excel

Dueling Excel 010

January 20, 2015 1

DESCRIPTION See Mr Excel and excelisfun invert a range (Turn a range of cells upside down) with two different INDEX formulas. See the functions: INDEX ROW, ROWS, COLUMNS. See how to flip range 180 degrees […]

Dueling Excel

Dueling Excel 009

January 19, 2015 0

DESCRIPTION See Mr Excel and excelisfun take a table of data and create a column of values that can be used with the Statistical Data Analysis Excel Add-in. Mr Excel uses VBA Macro code. excelisfun […]

Dueling Excel

Dueling Excel 008

January 18, 2015 0

DESCRIPTION See Mr Excel and excelisfun try to deal with the Top 10 Filter with Two Criteria Trouble. Mr Excel solves the problem with Advanced Filter and a Criteria Formulas. Excelisfun solves the problem with […]

Dueling Excel

Dueling Excel 007

January 17, 2015 0

DESCRIPTION See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) excelisfun uses a formula with INDEX, IF, […]

Excel Is Fun

Excel Magic Trick 1091

January 16, 2015 0

Count Number of Items In Row For First Occurrence of Each Group DESCRIPTION See how to count the number of items entered into the row that corresponds to the first occurrence of each Group Number […]

Dueling Excel

Dueling Excel 006

January 15, 2015 0

DESCRIPTION See Mr Excel and excelisfun try and retrieve the last value in a row. See the INDEX, OFFSET, LOOKUP and MAX functions. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1090

January 14, 2015 0

DESCRIPTION See how to use the MEDIAN function is unusual ways that allow you to shorten the formula (for last two examples): (00:09) Deliver an OR Criteria Logical Value. (02:15) Payroll Tax calculation where there […]