Tips – Using VLOOKUP in Excel
When I teach Excel to my delegates, there are many who at first think they do not need formulas in their spreadsheets as all they do is sort lists. They don’t...
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...
Do you have results from a VLookup that are wrong?
VLookup is one of those functions that can be incredibly useful once mastered. However, while it seems simple to use, there are a few simple errors that people make which lead...
Tips – Chairing a meeting part 4
Our fourth part for tips on chairing meetings is focussed on the agenda. This document can provide the skeleton of a meeting, its time keeping and its focus. However there are several items...
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...
Tip – Drawing Tables in Word
I often see people struggling with tables in Word. They create a table by inserting it. There is nothing wrong with that. But what they then need is different sized cells...
Calculating number of workdays between two dates where weekends are not Saturday and Sunday
A recent tip of mine showed how to calculate the number of working days there are between two dates. Also where there are bank holidays involved. Today I shall investigate the...
Tips – Using the Today() function in Excel
I have been training for a fair few years now, and I still get surprised by what people do not know what Excel can do. When it comes to dates and...
How to maintain customer success when your key contact leaves
How to maintain customer success when your key contact leaves from Geoff Pople @KimbleApps
Tips – AutoCorrect in Word
This Tip is written in Office 2016 so images of tools or ribbons may differ from your version. The features still work the same.
In an earlier tip I showed you how...