A reader asks: how does the OFFSET function work? When might I want to use it? The OFFSET function allows the user to select a primary cell reference but return... read more →
Problem: A land seller for condominiums or detached houses wants you to sweeten your up-front cash offer for the site by allowing him to also partake in a certain percentage of... read more →
REFM's Free E-Book that teaches individual Excel skills in 60 seconds, and includes a Keyboard Shortcuts reference sheet. Topics covered include: Formula auditing X-ray vision Jumping to a referenced cell... read more →
People often ask me about the "clawback" provision in real estate private equity funds. Note that this is not the same thing as the "catch-up" mechanism, which you can read about... read more →
Problem: You want to merge together two separate text strings, or you want a label in your spreadsheet to be a more customized description of the numeric variables associated with that... read more →
Problem: Long, multi-part formulas can be tough to digest and challenging to audit when they extend a long way across the formula bar, or wrap onto multiple lines based solely... read more →
To save a partially-constructed formula, or to inspect a formula outside of the cell in which it resides, simply put a single quote mark ( ' ) in front of... read more →
Problem: You want to insert a drop-down menu in Excel so a selection chosen in that drop-down can drive certain calculations. REFM 60-Second Skills Solution: First, in the Excel worksheet... read more →
X-Ray Vision Drop-Down Menus Watch Window Jumping with Ctrl + Bracket Acquisition Analysis Financial Calculator FV and PV F11 Insta-Graph Seeing More At Once Checking For Errors
They all solve a common problem in Excel, only take 60 seconds each to learn, and can save you hours of what would otherwise be lost time! Check out the... read more →