Quick Information: Use the Status Bar
In the bottom right-hand corner of your Excel sheet is the status bar. When you highlight a group of cells the status bar tells you some information about them, such as the average, count(how many cells have information in them) and the sum. You can add or remove which pieces of information to show here […]
Avoid manual data entry with the Fill Handle.
Instead of doing lots of typing, did you know you can fill a series of cells based on just one manually entered cell? Using the Fill Handle, you can. For example, if you write in a date, and take your mouse to the bottom right-hand corner of the cell, the pointer will turn into a […]
Super Powerful: 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 and is still often referred to as this.) It will change your life. The Basics You can find Get & Transform on the Data menu. Basically, Get & Transform is […]
Interpreting Formulas in Tables.
You are probably aware of how formula use cell references in Excel. A1 refers to a single cell, A1:A5 refers to a column of cells and A1:G1 refers to a row of cells. If you have a formula in a table, or a formula that refers to a table then the way that the formula […]
More Conditional Formatting Options.
On the home tab of your #Excel sheet or shortcut key Alt, H, L. You can use conditional formatting to simply highlight values of interest. See this post. Other options from within Conditional Formatting are, Data Bars, Colour Scales and Icon Sets. Data Bars Within Data Bars, you get two Standard options: Gradient Fill, and […]
Make your data colour coded with Conditional Formatting
Conditional Formatting, such a great tool. On the home tab of your #Excel sheet or shortcut key Alt, H, L. Start by selecting the cells that you want to apply the formatting too. I have used it to highlight all the cells in my column that are over 85. You can use it to automatically […]
Make your life easier, use shortcut keys in Excel.
Shortcut keys can make your time on Excel much more efficient. Reaching for the mouse or touch pad to do something is definitely slower than using a shortcut key. Also, some of the best shortcut keys saving typing time and are more accurate. It can take a bit of time to get used to using […]
Line up
When you have graphs(Charts) or pictures in Excel and you want to get them lined up you can use Align. It is available on the Page Layout Menu and also the Format Shape Menu. You need to select the elements first. Use the Shift key (hold it down) while you click all the elements you […]
Custom Number Format the rescue.
You can do a lot with custom number formats. One thing that is tricky is when you are presenting information and you want to have the units correct is allowing for 0 days, 1 day, 2 days. The lack of “s” when the unit is 1 is tricky, but can be sorted with a custom […]
Powerful Filter Button Options.
Once you have added Filter buttons to your data, either via the home menu or because you have a table, you have a lot of options on how to use them. Filter by Color – if you have colours on your cells, either from formatting or conditional formatting, you can use this to filter just […]