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

Excel Magic Trick 848: Create List of Dates For Month With Formula

November 14, 2013 by Admin  
Filed under Learning Magic Tricks

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to: 1. Given the month as text and the year as a number, see how to get the first…
Video Rating: 4 / 5

Next Page »

Switch to our mobile site