Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet

February 19, 2015 by Admin  
Filed under Learning Magic Tricks

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. Select From Drop Down and Pull Data From Different Sheets using Data Vali…
Video Rating: 4 / 5

Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting

December 13, 2014 by Admin  
Filed under Learning Magic Tricks

See how to create a basic Attendance Sheet for a classroom in Excel. See THESE TRICKS: 1)See how to Freeze Panes for Large Spreadsheet 2)Ctrl + 1 to open For…

Excel 2010 Magic Trick 789: Extract Records That Match Criteria for Multiple Reports Across Sheets

November 9, 2014 by Admin  
Filed under Learning Magic Tricks

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. See how to create Multiple Reports On Multiple Sheets That Extract Records That Match Cr…

Excel Magic Trick 1024: SUMIF & SUMIFS function & Mixed Cell References & Dynamic Table Range

May 15, 2014 by Admin  
Filed under Learning Magic Tricks

Download workbook example from video: http://people.highline.edu/mgirvin/excelisfun.htm Add with one or more conditions: 1. Learn how to add with one or more…
Video Rating: 5 / 5

Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples

May 14, 2014 by Admin  
Filed under Learning Magic Tricks

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm If you have a hard time understanding what VLOOKUP does, this video is for you! Topics c…

Excel Magic Trick 944.5: Formula For Total Interest Over Life Of Business Amortization Loan

April 16, 2014 by Admin  
Filed under Learning Magic Tricks

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Topics: 1) Create Defined Names to use in formula using the Create Name From Selection f…
Video Rating: 4 / 5

Excel Magic Trick 629: HR Salary Calculation Based On Relevant Years Worked (2 methods)

March 21, 2014 by Admin  
Filed under Learning Magic Tricks

See the functions VLOOKUP, MATCH, DATEDIF, SUMIF, SUMPRODUCT, and INT to lookup Salary based Relevant Years worked. See two methods: 1) Non-array formula tha…
Video Rating: 5 / 5

Excel Magic Trick 515: Amortization Table Pay Off Early & Trouble Shoot Formula Creation

January 9, 2014 by Admin  
Filed under Learning Magic Tricks

See how to create an amortization table that will update when you pay extra principal so that loan is paid off early. See how to make changes to a template, …

Excel Magic Trick 326: Hyperlink Worksheet To Worksheet

December 3, 2013 by Admin  
Filed under Learning Magic Tricks

See how to create a hyperlink from one sheet to another sheet in the same workbook.

Excel Magic Trick 947: Defined Name 3-D Cell Reference For Making Calculations Across Sheets

November 28, 2013 by Admin  
Filed under Learning Magic Tricks

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm When making calculations across many sheets that have the same demensions it can be usef…
Video Rating: 4 / 5

Next Page »

Switch to our mobile site