﻿ Excel Analysis Videos
Welcome

# Excel Analysis

• 09:17 Popular

### Excel 2013 Flash Fill : 23 Amazing Examples (Preview #7) (Excel Magic Trick 955)

by Admin Added 129 Views / 0 Likes

Download: http://people.highline.edu/mgirvin/ExcelIsFun.htm The Amazing Flash Fill Excel 2013 Feature will Extract, Concatenate (Join), Insert or Reverse Dat...

• 06:19 Popular

### Mr Excel&excelisfun Trick 131: Prevent VLOOKUP From Returning A Zero (4 Methods)

by Admin Added 123 Views / 0 Likes

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Mr Excel and excelisfun use two methods to Prevent VLOOKUP from Returning a Zero: 1....

• 18:02

### Excel Magic Trick 744: Break Even Analysis Formulas Chart&Plotting Break Even Point On Chart

by Admin Added 90 Views / 0 Likes

Download file: http://people.highline.edu/mgirvin/ See how to do Break Even Analysis Table with Formulas, Chart (X-y Scatter Chart Diagram), and Conditional ...

• 08:29 Popular

### Mr Excel&excelisfun Trick 116: Extract Individual Letters From Cell And Do Lookup Adding, Then...

by Admin Added 117 Views / 0 Likes

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Mr Excel and excelisfun use two methods to do lookup adding from a cell and then sho...

• 04:29 Popular

### Mr Excel&excelisfun Trick 28: Find Earliest Date From List Of Dates Given 2 Criteria

by Admin Added 111 Views / 0 Likes

See Mr Excel and excelisfun find the record with the earliest date given three criteria. See Filter and Sort, an array formula that uses the MIN and IF funct...

• 05:54

### Slaying Excel Dragons Book #4: Table Format Structure For Raw Data&Data Analysis

by Admin Added 64 Views / 0 Likes

Download files: https://people.highline.edu/mgirvin/ExcelIsFun.htm Learn Excel from beginning to end. Complete Lessons about Excel. This video series accompa...

• 07:52

### Mr Excel&excelisfun Trick 91: Rank Scores, But If Tie Award Highest Rank To The Largest Weight

by Admin Added 98 Views / 0 Likes

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Mr Excel and excelisfun use two methods to rank scores with the heights Weight: 1. S...

• 09:41

### Mr Excel&excelisfun Trick 75: Dynamic Range VLOOKUP&Data Validation OFFSET Or INDEX?

by Admin Added 90 Views / 0 Likes

See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation using the OFFSET and INDEX functions.

• 19:35 Popular

### Slaying Excel Dragons Book #39: Data Analysis Pivot Tables&Pivot Charts, PivotTables&PivotCharts

by Admin Added 101 Views / 0 Likes

Download files: https://people.highline.edu/mgirvin/ExcelIsFun.htm Learn Excel from beginning to end. Complete Lessons about Excel. This video series accompa...

• 06:41 Popular

### Mr Excel&excelisfun Trick 102: Remove Duplicate Records Based On Partial Text In A Cell

by Admin Added 114 Views / 0 Likes

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Mr Excel and excelisfun use two methods to Remove Duplicate Records Based On Partial...

• 07:24 Popular

### Mr Excel&excelisfun Trick 12: Sort Numbers With Formula

by Admin Added 135 Views / 0 Likes

See Mr Excel and excelisfun create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest. See the functions MAX, LARGE...

• 08:18 Popular

### Excel Magic Trick # 254: Data Table Creates 100 Formulas

by Admin Added 120 Views / 0 Likes

See how to create a Contribution Margin Income Statement Analysis across various units using a 1 Variable Data Table (What if analysis). See how to create 5 ...

• 11:33 Popular

### Highline Excel Class 22: Budgets, Scenarios&Scenarios Report

by Admin Added 124 Views / 0 Likes

Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm Create a Budget with Formula Inputs in an assumption area and formulas. Then do what i...

• 07:26 Popular

### Mr Excel&excelisfun Trick 136: Variable Rent Calculation Based On Days: VBA, IF Or VLOOKUP?

by Admin Added 108 Views / 0 Likes

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Mr Excel and excelisfun use two methods to calculate the total rent for a container ...

• 02:15

### Excel Magic Trick 1052: Best New Feature In Excel 2013: Recommended Charts&PivotTables

by Admin Added 94 Views / 0 Likes

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm Mind-blowing awesomeness: 1. Recommended Charts&PivotTables take transaction data, u...

• 05:50

### Mr Excel&excelisfun Trick 90: Remove Earlier Duplicates, Keep Last Duplicate

by Admin Added 96 Views / 0 Likes

See excelisfun create a silly formula that is WAY too long, then see Bill Mr Excel Jelen demonstrate two quick and easy methods for removing the earliest dup...

• 04:40 Popular

### Mr Excel&excelisfun Trick 10: Turn Column / Row Upside Dow

by Admin Added 101 Views / 0 Likes

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

• 06:21 Popular

### Excelisfunner&Mr Excel&Excelisfun Mr Trick 104: Truel With 5 Year Old Exceler

by Admin Added 114 Views / 0 Likes

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See 5 year old Isaac play around with Excel and the Mr Excel and excelisfun jump in too....

• 15:02

### Slaying Excel Dragons Book #7: Excel Data Alignment: Pitfalls&Advantageous Tricks

by Admin Added 75 Views / 0 Likes

Download files: https://people.highline.edu/mgirvin/ExcelIsFun.htm Learn Excel from beginning to end. Complete Lessons about Excel. This video series accompa...

• 14:42 Popular

### Excel Magic Trick 1023: Extract Unique List Of Names For Dynamic Data Validation Dropdown List

by Admin Added 116 Views / 0 Likes

Download workbook example from video: http://people.highline.edu/mgirvin/excelisfun.htm Excel Array Formula solution to create a Dynamic Data Validation Drop...

• 08:21

### Mr Excel&excelisfun Trick 133: Add Nth Largest Values With Three Criteria Dynamic Formulas

by Admin Added 91 Views / 0 Likes

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Mr Excel and excelisfun use two methods to sum the three biggest values that match t...

• 06:46 Popular

### Mr Excel&excelisfun Trick 108: SUM, AVERAGE, STDEV.S, MIN, MAX: Three Methods

by Admin Added 127 Views / 0 Likes

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Mr Excel and Excelisfun calculate descriptive statistics: MIN, MAX, Standard Deviati...

• 07:03

### Mr Excel&excelisfun Trick 125: Conditional Formatting Date Four Days Old&Not Paid

by Admin Added 89 Views / 0 Likes

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Mr Excel and excelisfun use two methods to Conditional Formatting Date That is Four ...

• 06:56

### Mr Excel&excelisfun Trick 77: Top Two Customers In Each Industry PivotTable Or Sort Filter Formula

by Admin Added 59 Views / 0 Likes

See Mr Excel and excelisfun extract Top Two Customers In Each Industry using a Pivot Table or Sort Filter&Formula with COUNTIF function and Expandable rang...