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.😃

Hello from Florida

As you may have read last week, I am now in Florida spending the mornings working and the afternoons with our children and grandchildren. So far, we have been out for ice cream, visited a science museum, baked chocolate cakes and played nicely.

Work

In the mornings, I have been preparing for the Excel webinar that ran on Tuesday, editing podcasts and catching up on the follow-up from The PA Show.

My next job is to get some blog posts written. I have a list and realised that I haven't written one for a while, so it's time to get on with that now.

Let me know what topics you would like me to write about. I am always happy to receive suggestions.

Weekly Excel Tip

Using VLOOKUP for Data Retrieval

VLOOKUP is a powerful function in Excel that allows you to search for a value in one column and return a corresponding value from another column. This is particularly useful for looking up information in large datasets.

To use VLOOKUP, enter the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), where lookup_value is the value you want to search for, table_array is the range of cells containing the data, col_index_num is the column number of the value you want to return, and [range_lookup] is an optional argument to specify an exact or approximate match.

This function can help you quickly find and retrieve data from your spreadsheets

Boost Your Productivity with The New Outlook - New date announced 22nd May 2025

Following the success of the webinar that I ran in January and as over 70 people have joined the waitlist, I am excited to announce that I will be running this webinar again in May.

Here is what you can expect

Join me for an exclusive webinar tailored specifically for Assistants eager to enhance their productivity with the New Outlook.

This session promises a blend of practical insights and hands-on demonstrations designed to help you become an Outlook expert. We will delve into essential features, share time-saving keyboard shortcuts and explore quick actions that streamline email management. My goal is to equip you with tools and techniques that will make your daily tasks more efficient and enjoyable.

Areas to be covered:

🚩Introduction to the New Outlook interface

🚩Essential features for enhanced productivity

🚩Time-saving keyboard shortcuts

🚩Quick actions for streamlined email management

🚩Common issues and effective solutions

🚩Highly interactive session where you can ask your questions as we go

The webinar will also include a dynamic Q&A session where you can bring your questions and get detailed answers from our experts.

We will address common issues users face and provide effective solutions, ensuring you leave with a thorough understanding of the New Outlook.

Additionally, you will have the opportunity to provide feedback and suggest topics for future webinars, helping us tailor our sessions to better meet your needs.

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

Virtually Amazing Assistants Podcast

Episode 13 with Suzy Sanders

Episode 13 is now live!

In this episode, I welcome Suzy Sanders, founder of Alchemy Virtual Assistants. We discuss Suzy's journey from an executive assistant to a virtual assistant, overcoming challenges, her coaching practice and launching a successful franchise. Suzy also shares insights on the importance of mindset, investing in yourself and the organic growth of her business. It's filled with valuable tips and inspiration for assistants and small business owners alike.