Tech Tips & Tales from The MS Office Maestro

Welcome Welcome Welcome to all my new subscribers!

Here you will find a mix of personal, training and tips here.😃

The PA Show - been and gone!

Last week I wrote to you from my stand at The PA Show in London. Today I am writing to you from the kitchen table in the motel we are staying at in Hollywood Florida.

I can't quite believe that The PA Show is over - so much work went into the preparation. 4 sessions - did you attend one? All the promotions etc.

The show wrapped up on Thursday evening and on Sunday we flew to Florida where 2 of our kids live.

If you are new to the newsletter, you will note that the first part is always a bit of personal news - what I am up to, what our kids are up to and then the rest is given over to tips and tricks and links to learning sources.

Here are a few photos from The PA Show.

Follow Up

For those of you who run your own VA or PA Business you will know that following up with connections is super important and following up in a timely manner is also important. For those of you working in an organisation, you will still need to follow up with connections, clients, appointments etc.

I wrote to all the lovely assistants whose badges we scanned at the show and to you I wish to say another welcome 💖

Then today I will be following up with all the people who asked to chat with me about training for themselves or their organisation. Tomorrow I will be sending out the slides to those who requested them.

It's not just a holiday!

Those of you who have been with me for a while will know that David and I work whilst here in Florida. Our children and grandchildren are at work and school so we take the opportunity to catch up on things. The afternoons are for family - it is a great balance and yes, we do manage to sit in the sunshine and do some shopping too 🤣

Weekly Excel Tip

Using Flash Fill for Data Entry

Flash Fill is a handy feature in Excel that automatically fills in values based on patterns it detects in your data.

This can save you a lot of time when entering repetitive data. For example, if you have a column of full names and you want to split them into first and last names, you can start typing the first name in the adjacent column and Excel will automatically fill in the rest. To use Flash Fill, start typing the desired values and when Excel detects the pattern, press "Enter" to accept the suggestions. You can also go to the "Data" tab and click on "Flash Fill" to apply it manually

Excel Boost- Tips and Tricks for Data Analysis - happening March 11th.

In this March webinar, learn my tips and tricks for using Excel for data analysis.

This session is designed to elevate your Excel skills and enhance your data analysis capabilities. Whether you're a beginner or an experienced user, you'll discover a range of powerful techniques and shortcuts that will help you work more efficiently and effectively with your data.

The content will cover everything from the basics of creating a formula, using autofill and flash fill, formatting as a table, and sorting and filtering, to more advanced topics like pivot tables and slicers, VLOOKUP, and XLOOKUP.

This webinar will provide you with the tools and knowledge you need to take your Excel proficiency to the next level.

Register Today for just £59 to attend and you get access to the replay for 30 days.

Only 6 days left to register - save your seat now!

Virtually Amazing Assistants Podcast

Episode 12 with Paula Edwards

Episode 12 is now live!

In this episode, I chat with Paula Edwards, founder of Advance Virtual Assistants Ltd. She shares her journey from solo virtual assistant to running a thriving agency and academy. We discuss the role and importance of online business managers (OBMs) along with tips for those looking into transitioning into the virtual assistant world.