Keyboard shortcuts 

 
Prompted by an email from another Excel specialist, this blog is about keyboard shortcuts and their time-saving benefits. All my friends, clients and associates know that I love keyboard shortcuts and I’m always recommending them ... 
 

 WN Images 

 
Image is Everything! I was asked “What is the best file format for logos?” After a bit of thought and research too for the techie bit I have come up with what I hope is a useful overview of the different types and when best to use them… 
 

 Conditional Formatting in Excel 

 
As you know I really rate Excel, and I really get excited about achieving great things in quick and simple ways using its great features. So this blog is for you spreadsheet users wanting your data to be really cool and informative! ... 
 
 

 Mail merge 

 
How does Mail Merge work?  
This can be a thorny problem, and I get loads of questions about it, so I hope what follows will sort a few things out for you … 
 

 Word Styles 

 
Have you got Style?  
You may not be aware of this but when you use Microsoft Word, each paragraph is based on a Style ... 
 

 Excel VLOOKUP 

 
Prompted by a client, I've decided to dish the dirt Excel’s VLOOKUP function. This function is so useful in many ways but it can be a bit tricky to get the right answer sometimes … 
 

 Auto Text 

 
I was talking about AutoText to a 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. So what is AutoText? AutoText is a database of stock phrases or… 
 

 Popping PowerPoint! 

 
It’s LIFE WITH … not DEATH BY… I heard a few moans the other day about using PowerPoint to do presentations, but as I see it, as long as you stick to a few rules and think about how an audience might react to the content then they will be happy… 
 

 Excel Tables 

 
What’s on the Table? Hi everybody and welcome to this week’s blog. I’m hoping that it will prove to be really useful for you when working on lists in Excel. Since Office 2007, there’s been a new kid on the block in Microsoft Excel. It’s called a Table object. Before then,…