I help assistants make the most out of Microsoft 365 - becoming more productive and saving time. Sign up to the newsletter today.
Share
Tech Tips & Tales: From Conditional Formatting to Social Media Savvy
Published 6 months agoΒ β’Β 4 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.π
It's the final countdown
I am writing this edition on Wednesday 19th February. I have been very busy since the last edition. Last week I ran 3 workshops on concurrent days with lovely feedback.
Then I took Friday off!
This week I spent most of Monday recording a session for the EA Campus Evolve Summit. That will go live on March 28 when I will just have arrived back from the US so it had to be done this week. The session is all about Microsoft Loop which is a fun collaboration app. More about Loop in future newsletters.
Then on Tuesday, I spent the day finalising all the presentations for the workshops I am giving at The PA Show next week. They are rather good if I say so myself π€£π€£
Today I have been learning about CoPilot Agents and I am very excited about the possibilities that this new way of working can bring. More on this in the future.
This afternoon I am re-recording one of the Virtually Amazing Assistants Podcast - with the lovely Ginette Tessier, as when I started to edit the episode, I realised that the sound was just not up to scratch. So that will be this afternoon.
Tomorrow and Friday will be all about making sure that I have everything I need for the trip - going from freezing cold London to hot Florida - where 2 of our 3 children live.
We will be in Florida for 3 weeks and whilst there I will deliver the Excel webinar detailed below. Grab your spot today!
β
Weekly Excel Tip
Conditional Formatting for Better Visualisation
Conditional Formatting in Excel allows you to highlight cells that meet certain criteria, making it easier to spot trends and outliers in your data.
For instance, you can use Conditional Formatting to highlight cells with values above a certain threshold or to colour-code cells based on their values.
To apply Conditional Formatting, select the range of cells you want to format, go to the "Home" tab, and click on "Conditional Formatting."
Choose a rule type, set the conditions, and select the formatting style you want to apply.
In the example below I have chosen to Highlight Cells Rules - Highlight cells that have a value greater than 1500. The cells that match the condition are filled in with light red fill and darker red text making them stand out from everything else.
Set up conditional formatting
There are several rule types to choose from and they will all give you great visualisations of your data. Have a go and let me know how you get on and how you will use it in your spreadsheets.
Virtually Amazing Assistants Podcast
Episode 10 with Karen Cureton
Episode 10 is now live!
In this episode, I chat with Karen Cureton of Cureton Consulting. She is a seasoned social media trainer. We discuss her transition from corporate sales to social media consultancy, her approach to training and the importance of strong communication and clear expectations in social media management.
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.
The PA Show - It's Next Wednesday & Thursday!
How on earth did that happen? It has come around so fast. This time next week it will be Day 2 of the show and I will be busy delivering three out of the four workshops.
Day 1 - VA Conference Theatre
14:50 Saving Money and Boosting Efficiency with Microsoft Tools for Virtual Assistants
Day 2 - Tech Theatre
10:00 Unveiling Hidden Gems in Microsoft Office
12:30 Top Time Busting Tips for Microsoft Office ( New tips this year!)
14:50 Excel Mastery - Top Tips to Transform Your Data
β
β
The free ticket does not give you access to the workshops. Grab your tickets now.
Use Coupon Code TOMVA10% when you register to receive 10% off.
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...
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...
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...
β
β