cafeconomics

 Here are some tips and tricks for Excel users. Pending minor edits.   1               Use tab to select a formula when it is selected in blue. 2               Number formatting is a façade. 3               Count function counts only numbers. Count function does not count words. 4               CountA function counts everything both words and numbers. Only those cells that are not empty. 5               Use SUM IFS and COUNT IFS rather than SUMIF and Count IF even if you have only one condition. 6               Pivots need to be refreshed for data updates. 7               You can adjust QAT and ribbons with the tools that you use frequently. 8               To exactly know what is contained in the cell,you must format it to general. 9               You can use 0,-1,-2 for rounding in ROUND formula. If you want to round to 100s or 1000s. 10            Under dates, there are serial numbers, which are the number of days since Dec 31, 1899. 11            Use evaluate