Excel Windows Archives > Tomorrow's VA

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.

Category Archives for Excel Windows

VAs – Making Time Add Up in Excel

Make time add up

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 […]

Continue reading

VAs – Why Number Formats Matter in Excel

Why do Number Formats Matter? When working in Microsoft Excel you may have noticed that the data you enter does not have a Number Format when you first enter it, rather it has a General Format. You may be wondering why it matters what kind of format the data has. Excel spreadsheets are set out […]

Continue reading

VAs – How to add Headers and Footers in Excel

headers and Footers in Excel

Headers and Footers Headers and footers appear on every printed page. This is how you add page numbers, date and time, the file name and path and where you can add a logo to every page in the Header. Headers and Footers are added via the Page Layout View and are typed into the Header […]

Continue reading

What’s New at tomorrow’s VA?

Excel Training

Exciting timesI set up tomorrow’s VA to enable Virtual Assistants to hone their Microsoft Office skills and get more done in less time. I have been diligently creating mini online training courses for hot topics in Microsoft Office. Today I am excited to announce that there are now two Excel courses. Well, when I say two, […]

Continue reading

What every VA needs to know about dollar signs in Excel formula

Absolute Cell References

You have just been sent a spreadsheet. It has been set up for you and you are eager to get to work filling in the blanks and completing the calculations. But what’s this? You suddenly notice in some of the formulas there are some Dollar $ signs lurking. What do they mean? Why are they […]

Continue reading

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 […]

Continue reading

Virtual Assistants – Everything you know about sums is wrong

Sum in Excel

How did you learn to write a sum at school? When you went to school you may have learned how to add up a sum like this : 12+3=15       And when it comes to putting that into an Excel spreadsheet, you assume it is the same. Excel will add up the numbers […]

Continue reading

Gain Insights into your data – new Excel feature

Insights

New Sign-in Experience The other day when I opened Microsoft Office I found that the screen that opens when you start has changed. It has changed across all of the Microsoft Office programs – however I am showing it here in this post about Microsoft Excel. Figure 1 Note that Excel opens on the Home […]

Continue reading

How can Matt find joy analysing Data with Excel?

data analysing

How can Matt find joy analysing Data with Excel? Matt was a marketing executive who had recently started in a new London firm. Part of his role was to collect and analyse market research data and present the findings to a team meeting each week. He loved his job as a creative team player and […]

Continue reading

How Jill could save time by filtering data

show filtered data

How Jill could use the filter button to save time! Remember Jill? She has been wasting so much time. Up to 4 hours on just one task every week! Could be even more to be honest. If Jill had learned just this one thing it would have cut down her time wasting significantly. Filtering data […]

Continue reading

How to print an Excel spreadsheet on one page – using Print Scaling

how to print one page from excel

How to set Print Scaling in Microsoft Excel 2013 I am often asked how to make everything typed on a spreadsheet fit on to one piece of paper. It can be a little frustrating to make things fit. Using Print Scaling can help you do just that. Scaling your worksheet allows you to make all […]

Continue reading