Excel Is Fun

Excel Magic Trick 1175

November 5, 2015 0

Decaying Average in Standards-Based Grading in Excel DESCRIPTION See (00:10) How Decaying Average in Standards-Based Grading works (02:00) Calculating in Excel Method 1: Two formulas that use IF function and Absolute Cell References (04:02) Explaining […]

Dueling Excel

Dueling Excel 048

November 4, 2015 0

Screen Tip & Excel Is Broken DESCRIPTION See Mr Excel and excelisfun show how to break Excel by moving a data validation screen tip. WORKBOOKS

Excel VBA

Excel VBA File Dialogs

November 3, 2015 0

Excel VBA Introduction Part 24 – File Dialogs DESCRIPTION Using FileDialogs in VBA provides a convenient method for selecting files and folders and performing useful actions on them. This video covers how to use the […]

Excel Is Fun

Excel Magic Trick 1174

November 2, 2015 0

Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) DESCRIPTION See three methods for lookup situations where you have two lookup values: (00:10) What to do if you have two look values […]

Excel Is Fun

Excel Magic Trick 1173

October 29, 2015 0

Conditional Format Dates When they are 90 Days of Set Expiration Date DESCRIPTION See how to use Logical Formula to Conditionally Format Dates When they are 90 Days of Set Expiration Date