Microsoft is not perfect. What company is?

But it does follow up its talk about improving its applications with action. It makes changes, often based on customer feedback, as part of an ongoing iterative process.

This can be seen in the recent updates made to Excel for the web – for people who like to work in a browser.

It’s worth keeping an eye out for new features and functionality. Microsoft appears keen to make working in a workbook, and finding your way around it, faster and easier for improved productivity and efficiency.

These little time-saving updates could make all the difference to a professional assistant with many tasks on the go.

Favourite Formatting

You may have noticed that Excel for the web now offers more customisation in the way your documents look and feel.

With the custom colour palette, you can explore and choose from a vast range of shades and tones in the ‘more colours’ dialogue box. Click to pick a colour. Change the shade by moving your cursor around and see how it looks in the preview box.

You can also put in RGB or hex values directly to select a specific colour match. This is especially useful if you do brand work with your company or clients.

The cell styles gallery helps to provide consistent formatting of data. This makes it easier for people to read and take in. Match up fonts, number formats, and cell borders and shading with more ease.

If you like to present neatly and precisely, it’s a feature you’ll enjoy using.

And that’s also true for the function that allows you to easily create, change or remove borders and gridlines. Select the action from the drop-down menu and away you go.

This feature is useful if you want to highlight data or set one set of data apart from another.

A Different Kind of Minibar

You may also have seen that Excel on the web has a new mini toolbar. This gives you fast access to the most popular formatting commands and it pops up like magic with a single right-click.

It’s one of those time-savers you probably won’t even think about. However, just imagine all those seconds saved over a year from using the feature and the time it gives back to you.

Topping the Tables

If you’re an Excel user, you are probably familiar with Tables.

For the web (and desktop) version, Microsoft added some updates earlier in the year around design and styling options, renaming tables, adding a ‘total’ row for a quick calculation, and formatting any data as a table.

Now, you will also see improvements to the PivotTable functions in Excel for the web.

I love a great PivotTable and putting one together has become easier with these changes.

You can create your own layout style or pick from a ‘Recommended’ table in the sidebar. Select your fields, move fields around or use a new PivotTable ribbon to adjust settings or change the way the whole thing looks and feels.

For example, you can choose where you place sub-totals, put fields from rows in a separate column or single column. There’s also a neat right-click access to change things in a specific column with ease.

Complete the job by selecting a style for your PivotTable.

If you’ve never used or are a little rusty with PivotTables, my online course about how to create excellent spreadsheets will show you the way. It also includes practical tips for features like autofill, autosum, table formatting, conditional formatting and charts.

Sorting it Out in Style

If you use Excel for data analysis, the likelihood is sorting functions are going to be your best friend.

In the web version, it’s now possible to sort by cell colour, font colour and conditional formatting icon. That’s on top of being able to sort by cell value, of course.

The updates also include a feature that allows you to sort by more than one column.

This will help you to work with data and ‘interrogate’ the figures in different ways, to build a clearer picture of what’s happening with the numbers.

Chart Success

In Excel for the web, it’s now also possible to directly select and interact with chart elements when formatting a chart.

You work from the format task pane and, as you make your selections, you can see how that changes the look and style of the chart. It’s like a preview.

Non-data chart elements can also be taken out of the chart using the delete and backspace keys. Intuitive and interactive.

No Limits with Delimiters

Finally, there’s a neat function for Excel for the web which allows you to split the text into columns.

This could be really useful if you receive data that needs a bit of organising so it’s in the best format to work with.

For example, let’s say you have an Excel document that contains a list of addresses. Each address is squeezed into a single cell. House number or name, street name, town or city, county, postcode (and possibly country). All in one cell.

What you want is to have each element of the address in different but adjacent cells.

Instead of having to do that with the fiddly moving of copy, or intricate cut and paste, you can now use delimiters.

Each address is converted and spread into five (or six, if including country) cells:

1. House number or name

2. Street name

3. Town or city

4. County

5. Postcode

6. Country

So much easier to work with the information in this format. For mail merge, for postcode analysis, for understanding the geographical spread and mix of a list.

Address lists are not the only thing you can use this text to column feature for.

It can be for words and phrases, too. Have a play and see how you might use it in your work.

These are just some of the updates users of Excel for the web are now able to enjoy.

If you are one of them – and productivity and efficiency are important to you – then it’s worth checking out these improvements.

Every tweak is designed to make your life simpler and easier. Every minute you save in completing a task gives you a minute back. That all adds up over time.

And best of all, you get to choose what to do with that extra gained time. Put more focus on delivering more wow for your boss or client, take on an extra project or reward yourself with a break.

The session was well structured and the explanation was very clear. It was amazing how Shelley managed to squeeze so much info in just one hour and a half! Colin’s support and contributions were also very valuable, and so were “Virtual Veronica”‘s. Thank you for a most interesting and useful training session at the Miss Jones Virtual Summit!

Laura Carizzo- Royal Norwegian Embassy in Argentina

I haven’t used PowerPoint in 20 years, this has really boosted my confidence.

Lyn Parker

Course is packed with so much valuable information in a easy-to-understand and follow language, even for a complete beginner. I can respect the fact that sometimes it’s very hard for an expert to break the information down to basics. but Shelley has done it brilliantly. I was sure that I knew quite a bit but Shelley has proven me wrong even at the very beginning of the basics of PowerPoint. Lessons are short and precise which allowed me to easily transfer the new skill into practice without being overwhelmed and to carry on adding on more with each lesson. I had so many ‘Aha!’ moments and for most of them I couldn’t believe I used to pay graphic designer to do it for me, now, thanks to Shelley, I am looking forward to creating, designing, converting my presentations all by myself!

Iva Freeman – Vertex Human Capital

Shelley was very thorough and knew a lot of tip’s for using Teams, thank you 🙂

James O’Connor – Cavannah Homes

Very informative, constantly getting everyone in the meeting involved, loved every bit of it!

Dylan Teal Hopkins – Cavannah Homes
Fantastic and informative training and great to see all of the exciting functions with Microsoft Teams.
Laura Rigby – The Apprenticeship College
Shelley was really clear in her teaching and went at a pace that was helpful to us. We covered all we needed to know to get us started, as a small team, using MS Teams. She was also very helpful in the run up to the session, with check in calls and ensuring our platform was set up correctly. I would highly recommend Shelley to anyone wanting to learn to navigate their way around MS Teams.
Leigh Dowling – Innuous

Microsoft Teams One to One Training Session

Shelley was approachable, easy to work with, and agile with answering questions to apply the session to my specific needs

Melissa Marshall – Present Your Science

A course on Outlook had been on the top of my list when Shelley asked VA’s what they wanted to learn.

It was a real case of ‘so that’s how you do it’ or ‘I never knew that’. I have to say that I learnt so many great tips it has definitely improved the way I work in Outlook and my inbox is looking colourful and organised and I can’t wait to share this knowledge with my clients.

Jacqueline Leake – JLeake VA Services – Outlook

A great course with lots of examples and step by step instructions. I can now confidently create infographics and as a bonus, I learnt a lot of new PowerPoint functionality that will enhance all my PowerPoint work and save me so much time.

Jessica Bailey – Integral Resource

I really like Shelley’s courses. She has a clear and easy to follow teaching style. In ‘How to Create Fillable Forms’ I’ve learned about the functions of the Developer ribbon which will mean I’ll be able to create a bespoke Returns Form for a client who has an online shop

Freya Henderson – Virtual Office Orkney

Shelley was really clear in her teaching and went at a pace that was helpful to us. We covered all we needed to know to get us started, as a small team, using MS Teams. She was also very helpful in the run up to the session, with check in calls and ensuring our platform was set up correctly. I would highly recommend Shelley to anyone wanting to learn to navigate their way around MS Teams.

Sarah Clements – Inuous

Absolutely superb course, easy to follow and to refer back whilst putting it all into practice! I was unaware of the extent you can customise a presentation and it’s just made me want to know more – what’s next Shelley?

Denise Williams

I thought I had a pretty good grasp of Outlook until I did this course! In her videos, Shelley is clear and concise, and the language she uses is straightforward and jargon-free. Each module is broken down into manageable chunks, which helps keep your attention and means the course is easy to fit in around other commitments. I’ve created email templates and implemented rules that are already saving me time, and as all the other things I’ve learnt start to become second nature, the positive impact on my efficiency is fast becoming clear. This course has been incredibly beneficial and I would highly recommend it to anyone looking to strengthen their skills and boost productivity.

Pip Doleman VA

I thought I knew Powerpoint really well, but I wanted to specifically learn how to use Powerpoint to create better infographics, easily and quickly. Shelley explains everything in a very logical and clear way, so I understood everything the first time I heard it. The most useful thing I learnt was that Powerpoint can do so much more than I thought it could. By also using the short cuts that Shelley showed me I am much quicker than I have ever been and I thought I was already quick!

Susan Marot

Shelley Fishel of Tomorrow’s VA has a wealth of experience in Microsoft Office. I met her in person 2 years ago at the PA Show in London. I also saw her in action in a fab workshop and knew she was the whizz that everyone had told me she was. I have since bought a lifetime access to her HUB and all the courses in there are a MUST if you are a VA on a mission. The courses will give you confidence in all the Office 365 components and will catapult you to dizzy heights

Alex Hughes