How to set up a table of contents in Word
A TOC, or table of contents, is a ruddy useful thing to have in your Word document.
A great way to save time, it takes minutes to set up and ensures you can easily find sections within your document, saving you endless scrolling time.
This video shows how to do it.
#virtualassistant #howto #toc
How to setup styles in Word
Styles are a really useful tool in Word when you want to apply consistent formatting or your company branding to documents.
Using Styles can save a huge amount of time compared to format text as you go along or even compared to using the Format Painter.
I've done a quick 'How to', showing you how to set up your own styles.
Do you use Styles? If not, why not?
#virtualassistant #businesssupport #tipsandtricks
How to wrap text in Excel
Excel cells aren't really designed to hold a lot of text but sometimes we need to input long sentences, or even paragraphs, and that can lead to readability issues.
The Wrap Text function enables us to read all our text without having monster-sized columns and it's super easy to use.
#virtualassistant #businesssupport #exceltips
How to freeze rows and columns in Excel
It's so annoying when you have a large spreadsheet in Excel and you lose sight of your row headers when scrolling isn't it?
Fear not! There's a very easy way to solve your problem and my handy video shows you how. In less than a minute.
#virtualassistant #businesssupport #howto
How to use COUNTIF and COUNTBLANK in Excel
There are many wonderful things about Microsoft Excel but my absolute favourite has to be the COUNTIF formula.
(Yes, I have a favourite formula and I probably should have started this post with an anorak alert but never mind.)
It's such a useful function, especially if, like me, you use Excel to collate event registers or download and analyse survey results.
Watch this 'how to' vid to find out how to use COUNTIF and its sister formula COUNTBLANK.
You can find more 'how-tos' on my YouTube channel (https://lnkd.in/d-SCCmH)
#virtualassistant #businessupport #howto
How to auto-adjust columns and rows in Excel
Did you know you can automatically adjust all the columns and rows in your Excel spreadsheet to exactly the right size in one easy move?
Here's how to neaten up your spreadsheet quickly and efficiently.
#virtualassistant #excelskills #businesssupport
How to get started with Outlook Tasks
If you're an Outlook user who struggles to keep track of your to-do lists you might want to consider using Tasks in Outlook. It's a really simple and effective way to manage your to-do list.
Watch this video for a quick intro on how to get started.
#virtualassistant #businesssupport #outlooktasks
How to create email templates in Outlook
Did you know you can create email templates in Outlook?
Templates are a great way to simplify client interactions and save you time and energy.
The latest 'how to' shows you, well, how to.
#virtualassistant #howto #businesssupport
How to use categories in Outlook
Do you use Categories in Outlook?
It's a great way to assign tasks, organise, see where you are with each project and/or client.
Watch this 'how to' for an introduction to using Categories
#virtualassistant #businesssupport #outlook
How to use folders in Outlook
If you're getting your inbox organised for 2021 you'll need to set up (and use) folders.
Watch to find out how to create folders and sub-folders and use them in Outlook.
#howto #virtualassistant #microsoftoutlook
How to customise bullet points in Word
Did you know you can customise bullet points in Word? You can change the shape, colour or even make it a picture or your own logo.
Find out how in this week's video.
#virtualassistant #microsoftword #bulletpoints
How to use pictures with tables in Word
Do you like to put pictures in your Word documents?
What a daft question. No-one likes to put pictures in a Word document.
We like to have them in the document but getting them in there is one of the trickiest things to get right. And frequently leads to bad swearing.
An easy way to get them lined up and not mess up your text is to use tables.
Check out the vid to see how.
#virtualassistant #wordtips #wordtables
