Excel Tables: Why you should be using them.
If you have data that is in a table structure, i.e. column headings and rows of information then formatting your Excel data as a table has a lot of advantages. To format your data as a table, you can use the Format as Table button on the Home Menu, (Shortcut keys Alt, H, T), or […]
Conditional Formatting
Conditional Formatting, such a great tool. On the home tab of your #excel sheet. I have used it to highlight all the cells in my column that are over 85. You can use it to automatically highlight the top 10 values, or the lowest 5%, or cells that contain a certain word, or many other […]