Fed up of seeing constant email notifications with updates about the broken elevator, blocked sink, missing milk? (That’s an in-joke for my work colleagues.)
Distractions can break your flow, and email notifications can be a constant distraction, leading to a very unproductive day. But this article is about more than just switching off email notifications altogether, which I think frightens many.
If you have a column of data that you need to divide into separate columns, and there is something logical between each ‘section’ such as a space or a special character like a dash or slash then you can easily divide it in Excel.
At my work we’ve just been given the opportunity to buy Microsoft Office 2016 Professional Plus for just £9.95. A bargain, right? I’ve been thinking of writing an article on options for getting Word and Excel equivalents at home, so let’s review…
We touched on date formats in Excel knows what year it is. However I keep seeing a certain inefficient practice that I want to specifically address, and that is the practice of manually typing in the day of the week in the cell next to the date. Continue reading
Excel has quite a lot of file formats to choose from. We’ve moved from Excel 2003 which really only had a single format (xls), to Excel 2010 which has three main file formats to contend with (not to mention the original xls format).
Did you know that since Microsoft Office 2007 you can save a copy of your work as PDF? Do you even care?
Do you know how to zoom really fast? No I’m not suggesting you break the national speed limit!
Fans of TSA will know that I love my keyboard, but I don’t hate my mouse. In fact, look at this little cutie that recently won my heart… Continue reading
Are you always hunting around the ribbon in Excel (or Word/Outlook) to find your favourite button? Have you configured your Quick Access Toolbar (QAT) in each MS Office application? It’s easy to set up – just think about what you need on a regular basis, and keep adding as you go.
So click on this little down arrow:
Okay, so I wanted to call this article “Mousey sensuals”. #cringe
I see a fair number of people who don’t know how to use a mouse properly. Sad, but true. A mouse is a powerful tool in the right hand (or the left, if you’re one of those odd types).
One click or two?
I think the best way to put this, although not without its exceptions, is this: