Posts from November 2016

Back to recent posts

Take a VLOOKUP at This!

Posted on 27th November 2016 at 11:00

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 ...

F3 AutoText

Posted on 18th November 2016 at 16:48

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 ...

Have you got Style?

Posted on 11th November 2016 at 12:00

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? ......

What’s on the Table?

Posted on 4th November 2016 at 08:00

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!! ......

Posts from November 2016

Take a VLOOKUP at This!

F3 AutoText

Have you got Style?

What’s on the Table?

Tags

Archives