CTRL Key I was talking to someone the other day who had been using Excel for years but was unaware of how to select non-contiguou...

Protect Your Work If you share workbooks with others then I am sure you have experienced someone inserting or deleting a sheet and t...

TRACKING FORMULA ERRORS in SPREADSHEETS Guest Post: J. Helstrom Spreadsheet formula errors may cause other calculations to also yield...

JOINING VLOOKUP FUNCTIONS TOGETHER Between the holidays, Ice Storms and dealing with my daughter's wisdom teeth removal, it has bee...

LOOKUP FUNCTION As I mentioned, I am writing a new Ebook on Lookup  Functions and am having a blast playing around with some of these for...