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 […]
Custom Spreadsheet Solutions – Still going.
I have decided to rewrite some of my old blogs, so this is a rewrite of my first every post where I introduced the business: Custom Spreadsheet Solutions. “A brand new business looking to create customised spreadsheet solutions for organisations.” I am really pleased that I still get to do this work, and the concept […]
Clipboard memory knows what you just copied, and the thing before that as well…
I am generally not a fan of copying and pasting as it is usually an inefficient thing to do. But, sometimes it is helpful and if you are going to do it at least do it well. Did you know that everything you copy is stored on the clipboard memory? This means that you can […]
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 […]