When working in Microsoft Excel, have you noticed that the data you enter doesn’t have a Number format when you first enter it, rather it has a General format? So, you may be wondering, why does it matter what format the data has? It is all to do with how Excel sees the data you […]
You are a busy VA – that’s a given! A client has asked you to show her what her data means. What is the top value in the list of sales? Can you see values that meet a condition? Conditional Formatting will show the way. What is Conditional Formatting? Conditional formatting is exactly that, a […]
Perhaps you think of Excel as just a list of numbers – I know I did when I first started using it. And yes, of course it is a useful tool for presenting data, but that doesn’t mean we can’t add some style and interest to our spreadsheets using formatting. Good formatting makes the data […]
Adding and formatting a chart in PowerPoint
You have a client who asks you to create a presentation. Now amongst the information that needs to go into that presentation is some data. Your client really wants this data presented as a chart and asks you to do this. What if you are not sure how to do so? How long is it […]
How do You Make Time Add Up? Do you use Excel to keep track of your time? Most VAs I know use some sort of time tracking software which notes what they do. It can be a professional online piece of software which does all kinds of things from tracking your time to monitoring which […]
If you work with people in the corporate and business arena, they’re going have hybrid working on their mind.
One feature of the global pandemic has been the accelerated drive towards online learning. With in-person training barred or restricted, people have had to adapt the way they deliver their expertise. Gym workouts, yoga, meditation, language classes, IT, cookery demonstrations, have flooded online communications platforms like Zoom. Many consultants, coaches, speakers and trainers have turned […]
If you are new to Excel, you may think that it is purely a spreadsheet application to help us store and calculate numbers. You would be right, but even storing and calculating numbers involves text to explain what the numbers refer to. Not only that but, in my experience, Excel isn’t just for numbers! I […]
Podcasts are thriving so does it make sense for a Virtual Assistant to start one? The decision has to be a combination of personal and professional factors. Is it something that appeals to you? Do you have an idea for one? Can you set aside time to do a podcast? Is there a clear business purpose behind doing one? […]
People are fascinating, aren’t they? It’s widely acknowledged that executives need to be great communicators and yet many seem to struggle – or avoid doing – presentations. There was a survey a while back that revealed insights the smart-thinking assistant would be wise to pick up on: Almost nine out of 10 executives said communicating with […]
Have you ever dropped the pages of a large document or got them mixed up somehow and had to re-sort them into the correct order? I know I have! Were the pages numbered? If not, just think how much easier and quicker the job would have been with a number on each page.
Productivity requires efficiency of time. The more you can do in hour, the more you can get done in a day. The more you can get done in a day, the more you can achieve each week. Part of your role as a VA, EA or PA might to be help leaders and managers keep […]
Welcome to April. It means you’ve made it through the first three months of the year. It also means it’s time to review your first quarter. How has it gone for you? As an Assistant, you are not just providing administrative support to your clients. You are running a business. You wear many different hats […]
You have a document that needs to have the same text in several locations. This may be a contract or some sort of standard document. In our example, Susan wants to have the name of a client appear in several locations, but Susan only wants to type it in once! To do this we will […]
Did you know that you can view your presentation in different ways while you create it? There are a number of “views” available to you, and each is specifically designed to have a use and a purpose. There’s no need to remain in the same view throughout the creation process, you can pick the most […]