Posts from November 2016

Hi everybody and welcome to this week's blog. 
 
I did a Webinar for BizSmart last Tuesday which concentrated on Excel's VLOOKUP function and other related functions.  
As a consequence, I thought I would use the prep that I did and focus on VLOOKUP in my blog this week.  
 
This function is so useful in many ways but it can be a bit tricky to get the right answer sometimes unless you are fully aware of the pitfalls ... 
 
Hi everybody and welcome to this week's blog - trying to do these every weekend at least! 
 
I was talking about AutoText to a breakfast networking group the other day.  
Lots of the Word users became very excited when I explained what AutoText was.  
 
So I thought that I would pass this on to a wider audience ... 
Hi everybody and welcome to this week's blog especially for Microsoft Word users. 
 
Did you know that each paragraph you type in a Microsoft Word is based on a Style?  
Bog standard body text in a fresh document is based on the Normal style in the Normal template.  
There are many pre-set styles such as Heading1, Heading 2, List Style … 
 
So, how do you use styles and what are the benefits of using them? ...... 
Hi everybody and welcome to this Excel post. 
Since Office 2007, there’s been a new kid on the block in Microsoft Excel called a Table object. 
Before then, Data Lists were the name of the game. Converting a data list into an Excel Table is easy so here's a few Table tips for you to adopt and adapt. 
 
Have fun laying the Table!! ......