Tips – How to place pictures into a Word document
Last week I showed you how to create columns of text in Word for a newsletter type of document. Today I shall show you how to place pictures into this text...
Tips – How to use columns of text in Word
When creating newsletters and the like, you may find yourself wanting to layout the text in a more traditional newspaper way. We are creatures of habit. As such we find reading...
Tips – Merge and Centre in Excel spreadsheets
If there is just one thing that I would do away with in Excel it is the Merge & Centre button found on the home tab in the Alignment section.
This may...
Tips – Pivot Tables part two
I have shown you how to create a simple Pivot Table in my last tip. Now I would like to show you how to expand on that.
This is the result of...
Tips – Creating a Pivot Table in Excel
Whenever I train Excel and Pivot tables are on the menu I get a varied response. Either people are terrified of them or they just don’t understand how to use them...
Tips – Count functions in Excel Continued
In a previous tip – How to create the count functions in Excel I showed you how to use the function Count and CountA. I do hope you found it both...
Tips to staying motivated when your productivity dips
Every afternoon, at around 3pm, offices hit a wall. You're tired from staring at a screen, full from lunch and generally unenthused about your progress. You find yourself scrolling mindlessly through...
Tips – Using Quick Parts in Outlook
You can create anything you like in your email. If you want the same stuff every so often, it makes sense to have it at your fingertips just when you need...
Tips – how to use slides from different presentations but keep to a house...
I am often asked if there is an easy way to use some of a colleague’s slide deck as part of the presentation they are putting together for a conference or...
Tips – How to create the count functions in Excel
There are many times when looking at a spreadsheet you need to know how many items there are in a certain section of how many rows are filled with data. Simply...