Excel videos - by Laugh in the Box

Excel Magic Trick #190: Rearrange First Last Name w Formula

Length: 3:54
Rating Average: n/a
View Count:
Author: ExcelIsFun

See how to rearrange three parts in a text string (Last, First, Middle name) using the RIGHT, FIND, LEN, & LEFT functions in one formula.

Excel Magic Trick #189: Count Days Not Sunday

Length: 5:34
Rating Average: n/a
View Count:
Author: ExcelIsFun

Tags: array Co Community Count Days Excel formula functions Gel Girvin Highline IF INDIRECT Mike Not ROW SUM SUMPRODUCT Sunday

From a start date and an end date, see how to count all the days except for Sunday using an array formula that uses the functions SUM, IF, ROW, INDIRECT, SUMPRODUCT and TEXT. See a list of 10 different formulas from the mr excel Message Board that will blow your mind.

Excel Magic Trick #188: Page Setup Across Multiple Sheets

Length: 6:29
Rating Average: n/a
View Count:
Author: ExcelIsFun

Tags: Across College Community Copy Excel Gel Girvin Highline Mike Move Multiple Page Setup Sheet Sheets

Page Set Up Across Multiple Sheets Or To Another Workbook. Headers and Footers.Highlight all the sheets you want to add Page Setup to and then add the Page SetupTo highlight multiple sheets, click on the first sheet, hold shift, click on the last sheetIf you copy a sheet to another workbook, the...

Excel Magic Trick #187: Unique List w Dynamic Formula

Length: 9:41
Rating Average: n/a
View Count:
Author: ExcelIsFun

Tags: array Community COUNTIF Excel formula functions Gel Girvin Highline IF INDEX List Mike ROW ROWS SMALL SUMPRODUCT Unique

Create a unique list of items for a large list that contains duplicates with 2 array formula that contain the functions: SUM, IF, ROWS, COUNTIF, INDEX, SMALL, and ROWRelated Videos:Excel Magic Trick #180: COUNTIF function formula 21 Examples05 Excel Series: Array Formulas 1-14Various INDEX Lookup...

Excel Magic Trick 186.5 Advanced Filter Data Extract 2criter

Length: 2:34
Rating Average: n/a
View Count:
Author: ExcelIsFun

Tags: Advanced College Community criteria Excel extract Filter from Gel Girvin Highline records table to with

See how to use Advanced Filter to extract records from a table with 2 criteria.Related Videos:Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteriaExcel Magic Trick #81: Advanced Filter AND OR Data Extract

Excel Magic Trick 186 Dynamic Formula Extract Data 2criteria

Length: 11:5
Rating Average: n/a
View Count:
Author: ExcelIsFun

Tags: array College Community COUNTIF Excel formula functions Gel Girvin Highline IF INDEX Mike ROWS SMALLROW with

This formula will extract records that meet two conditions (criteria) and list them in order with no extra rows between records. Create a formula to extract part of a table from a larger table based on two criteria. Similar to a query in Access, but with a array formula in Excel that uses the...

Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter

Length: 7:46
Rating Average: n/a
View Count:
Author: ExcelIsFun

Tags: Advanced College Community criteria Excel extract Filter from Gel Girvin Highline records table to with

See how to use Advanced Filter to extract records from a table with 1 criteria.Related Videos:Excel Magic Trick 185 Dynamic Formula Extract Data 1 criteriaExcel Magic Trick #81: Advanced Filter AND OR Data Extract

Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria

Length: 10:12
Rating Average: n/a
View Count:
Author: ExcelIsFun

Tags: array College Community COUNTIF Excel formula functions Gel Girvin Highline IF INDEX Mike ROWS SMALLROW with

Create a formula to extract part of a table from a larger table. Similar to a query in Access, but with a array formula in Excel that uses the functions: INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW. This formula will extract records that meet one condition (criteria criterion) and list...