Excel Shortcuts, Formulas and Tips(Based on Mike Girvin's excelisfun youtube channel)
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 ...