What a difference a t makes… Sept or Sep?
Sept or Sep? Which looks better? Which is consistent with the other months? Who decides which is “correct”? Microsoft has made an update to the way months are displayed. Well, one month actually. But only if you are in certain places in the world, or at least your computer settings are set to that location. […]
Excel is turning 40!
Excel is turning 40 on September 30. To celebrate this milestone, Microsoft have put together “40 days of Excel” and you can see it all here. If I had to choose my favourite feature, I think I would go with conditional formatting. It is easily accessible for a new user and is often the first […]
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 […]
Automation in Excel: the choices.
Traditionally, the way to automate tasks in Excel, was to use VBA. See this post for how to turn on the developer tab and access this amazing tool. The new kid on the block in terms of automation in Excel is Office Scripts. Both allow you to record your actions, so no real programming knowledge […]
New Window on the world, or at least on your spreadsheet.
When you want to see two parts of your spreadsheet at once, New Window is what you want to be using. Found in the View menu, in the Window Section. (Shortcut keys Alt, W, N) Activating New Window will open another window to the current workbook almost as if it was another workbook. So now […]
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 […]