How-To Geek on MSN

These 5 little-known Excel features save me hours every week

To use this feature, first, select the range you want to search, or select any cell to search the whole worksheet. The fastest method is to press F5 (or Ctrl+G) to open the Go To Dialog box, then ...
How-To Geek on MSN

I use these 3 Excel formulas to organize my daily life

=LET (Spend,SUMIF (T_Budget [Category],E2,T_Budget [Cost]),IFS (Spend>F2,"Over budget",Spend=F2,"Budget hit",Spend> (F2*0.9), ...