The AND remix for the popular IF function can save at least 180 seconds of your time. icon smile This Excel Q&A by Philip Gamey […]

Only 150 people in the world prefer static to dynamic chart titles. This Excel Q&A by Philip Gamey will show you how to create dynamic […]

Data Tab…Consolidate [Data Tools]…Select FX…Add Ranges…Select Options…DONE! Today’s Excel Q&A by Philip Gamey, shows you how to use Excel’s Consolidate tool to unite several reports. […]

There are 2 ways to add sub and grand totals in reports, one requires more, and here’s the other This Excel Q&A by Philip Gamey […]

Pivot Table wins the RANK champion! In this Excel Q&A, Philip Gamey teaches how to use Excel’s Pivot Table to rank values. Here’s the video:

Want to get text into meaning full components? In today’s Excel Q&A, Philip Gamey shows how to use RIGHT, LEFT and MID functions to get […]

Discover the DATEDIF() secret before your boss does In today’s Excel Q&A, Philip Gamey shows how to use the DATEDIF function to solve the problem […]

Wow your users with some OPTION BUTTONS This Excel Q&A session with Philip Gamey shows you how to attach some interactivity to a loan repayment […]

Philip Gamey known worldwide as Excel Monster in this video demonstrates how you can perform a two variable sensitivity analysis using Excel. See the video […]

Developing an app in Excel to extract employee records has never been easier, join Philip Gamey to learn this very important technique. See the video […]