Power Query
If you are having to collate information from different sources into one place, learn about Get & Transform. (It used to be called Power Query in #excel.) It will change your life. Here is an example: Seven spreadsheets, all with some columns in common, but inconsistent column headings, and the need for the client to […]
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 […]
Top ten shortcut keys in Excel
Ctrl+; —Inserts today’s date.Ctrl+Shift+:—Inserts the current timeCtrl+0— Hides the current column.Ctrl+9—Hides the current row.Ctrl+`—That’s the accent mark, up by the 1 key. Toggles the view in the sheet to show all the formulas or cell values.Ctrl+PageUp or PageDown—Moves to the next worksheet in the currently open workbook.F2—Start editing the current selected cell.Shift+F10—Opens the right-click menu for the cell […]