Virtual Assistants - Why Autofill in Excel will save you hours

VAs: Create Traffic Driving Infographics for Your Clients

If you're a virtual assistant that creates blog posts and helps get traffic to your client websites, then you'll love this Infographic Training Course.

I'll show you how to create traffic pulling infographics using Microsoft Office tools. When you do this training you'll wonder how you've not done this sooner!

Subscribe to be the first to know when it's released.

P.S.  You'll love the emails you'll receive and there will be great deals on additional training for you. You won't be spammed and your privacy is protected.

Virtual Assistants – Why Autofill in Excel will save you hours

Autofil in Excel

What is Autofill?

Simply put, Autofill automatically fills a series of data whether that is a range of numbers, days of the week, months of the year or any sequence that you care to set. For example in the image below I created a telephone rota or office staffing rota. Using Autofill I could set up the days of the week along the top without having to type them all.

Autofill in Excel

I started out by typing Monday and formatting the cell. Then using the little fill handle in the bottom right hand corner, I hold it down and click and drag across all the columns. Then as I don't want Saturday and Sunday I can choose Fill Weekdays from the button also known as a Smart Tag that pops up.

So what?

Well, not only can it create the series of days starting from any day of the week, but it can also fill in a sequence of months or even increment dates. When you type in a date and use the Autofill handle to create the series you get to choose whether to increment by one day at a time, or fill months or years so creating a monthly or annual schedule.

If you are in the business of managing an event and have timings - then it will save you time filling in the session times. Just set the first two and Excel will do the rest.

Autofill Excel

Want to learn about this and many other Excel tools?

To learn how to use Autofill , build your formula properly and learn what happens when you need to add subtract divide and multiply, plus what order Excel will perform calculations in, then you need to take my course - Essential Excel Skills for Virtual Assistants.

In this course you will learn how to set up your worksheet in seconds, create calculations and formulas with flair, format everything so that it looks clean and professional (and easy to understand!) and make sure the whole thing works without a worry!

What are you waiting for? Head over there now.

The first 10 people who sign up qualify for a 20% discount. Add the coupon code AUTOFILL20% at checkout.

Or click the button that already has the discount applied.

About the Author Shelley Fishel

I will help you be more productive and earn more money as a virtual assistant. As a trainer with 20 years experience, you'll love how you'll get between 4-8 hours a week back when you use Microsoft tools to their fullest potential. I'm also the author of several best-selling books on Microsoft Word, PowerPoint, Excel and Outlook, published at www.bookboon.com . Subscribe and get more productive!

follow me on:

Leave a Comment: