profile

Shelley Fishel - The MS Office Maestro

Coming to you from The PA Show

Published 6 months agoΒ β€’Β 2 min read

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 is finally here

Hello there everyone. I am writing this from The PA Show. It has finally arrived. We flew over on Sunday and have had a very busy week so far. Today is Wednesday the first day of the show and it has been full on.

I have been talking to lots of lovely Assistants and presented a session in the VA Theatre on Saving Money and Boosting Productivity with Microsoft Applications. It went down really well.

Tomorrow is a full-on day with 3 sessions on different topics to be delivered in the tech theatre.

We then fly off to Florida on Sunday to see our 2 children who live there. Next week's newsletter and tips will come from The Sunshine State.

Here I am on my stand at The PA Show at almost the end of day 1!

​

Weekly Excel Tip

Using Named Ranges for Easier Formulas

Named Ranges in Excel allow you to assign a name to a specific cell or range of cells, making it easier to reference them in your formulas. This can help make your formulas more readable and reduce errors.

To create a Named Range, select the cell or range of cells you want to name, go to the "Formulas" tab, and click on "Define Name." Enter a name for the range and click "OK." You can now use this name in your formulas instead of cell references.

For example, instead of writing =SUM(A1:A10), you can write =SUM(SalesData) if you named the range "SalesData"

Virtually Amazing Assistants Podcast

Episode 11 with Kathy Soulsby

Episode 11 is now live!

In this episode, I chat with Kathey Soulsby, founder of Personally Virual. She shares her journey so far. We discuss her experience, including scaling her business, managing a team and the process behind authoring her two books.

​

video preview​

​

Virtually Amazing Assistants is for ALL assistants and each week I have a guest interview where we discuss lots of lovely topics.

New Webinar - Excel Boost- Tips and Tricks for Data Analysis

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.

Sign up now and take the first step towards mastering data analysis in Excel!

I am going to be delivering this webinar from Florida as I'll be there visiting our kids. Please register early as I will be hiring a meeting room so that I have the best conditions for delivery. I will need a minimum of 6 participants to make it viable.

Keyboard shortcut of the week!

​

In Excel, ALT+M to open the formula tab

​

When you are ready here are 4 ways you can work with me

​

Work with me:

βœ”οΈOne-on-One Training: Personalized Microsoft Office sessions.

βœ”οΈGroup Training: Schedule a discovery call.

βœ”οΈEvent Sessions: Book me for your conference or event.

βœ”οΈCourses: Explore The MS Office Maestro.

​

Until next week - take care and happy learning
​
​

​

First Floor Winston House, London, London N3 1DH
​Unsubscribe Β· Preferences​

Shelley Fishel - The MS Office Maestro

Getting more done in less time with Microsoft 365 Applications.

I help assistants make the most out of Microsoft 365 - becoming more productive and saving time. Sign up to the newsletter today.

Read more from Shelley Fishel - The MS Office Maestro

Tech Tips & Tales from The MS Office Maestro Hello Reader, it's wonderful to have you here! In this newsletter, you'll find a delightful mix of personal anecdotes, training news, and invaluable tips to boost your productivity with Microsoft Office. πŸ’Œ Not sure why you're getting this? Scroll to the bottom for a quick note. Shelley's News The past week has been all about Copilot and my back. For those of you who have been with me a while, you will know that I suffer with my back and every so...

23 days agoΒ β€’Β 5 min read
Microsoft 365 Fundamentals with AI and Copilot

Dear Reader As you will have seen from my previous emails I am launching a new course in September. Microsoft 365 Fundamentals with AI and Copilot. The reason for writing was to tell you about how I have been leveraging Copilot over the past week or so. I find myself going to Copilot regularly, to ask a question, do some research or in fact help me design a session or a course. I have agreed to deliver a session at ESTech in September, and I asked Copilot to look at all the previous sessions...

about 2 months agoΒ β€’Β 1 min read
Tech Tips and Tales from The MS Office Maestro

Tech Tips & Tales from The MS Office Maestro HelloReader, it's wonderful to have you here! In this newsletter, you'll find a delightful mix of personal anecdotes, training news, and invaluable tips to boost your productivity with Microsoft Office. Shelley's News Since the last newsletter, I have been improving my own knowledge in the realm of AI. I have been playing around with the different models. I have been focussed on Copilot and have been blown away by some of its capabilities. The...

3 months agoΒ β€’Β 5 min read