LARA MELLOR MICROSOFT TRAINING BLOG

If you’d like to receive a summary of my blog posts in a monthly email bulletin, please sign up to my newsletter.

Looking for something specific? You can search my blogs using the search tool below.

Loop Components in Outlook for the Web

Loop Components in Outlook for the Web

At the time of writing Loop components are currently only available for the web version of Microsoft Outlook.  Loop Components allow you to edit content with others and see the changes instantly wherever you are accessing them from.  They are built for collaboration....

New Chat Features in Microsoft Teams

New Chat Features in Microsoft Teams

Microsoft Teams is constantly evolving and here are 2 new chat features you may not have realised are now available.  It is now possible to record short videos as a response or delay the sending of a chat message id required. Record a Video in Chat This feature is...

Using Polls in Teams Meetings

Using Polls in Teams Meetings

Polls are a fantastic way to add interactivity into a meeting.  They can even be created in advanced and launched during the meeting for a smoother experience. At the time of writing the Forms app and the Polls app work in the same way.  At some point in the future it...

Creating a Bar of Pie Chart

Creating a Bar of Pie Chart

What is a Bar of Pie Chart I hear you say!!  This type of chart is perfect if some of the data in your pie chart is much smaller than others and is such a small segment of the overall data that it barely shows up.  The smallest figures can be shown on a separate...

Implementing Microsoft Teams in your company

Implementing Microsoft Teams in your company

Microsoft Teams is a fantastic tool for company collaboration but there are a few key decisions to make to ensure that everyone is using the software consistently to avoid frustration and ensure the most is made of the software. Can everyone set up Teams and Channels?...

Backing Up and Transferring Email Hosting Using Microsoft Outlook

Backing Up and Transferring Email Hosting Using Microsoft Outlook

If you are moving your website and email hosting, it’s usually a quick and easy job to switch over your domain to your new host by changing your DNS name severs. However, doing this without losing all your existing emails takes a little bit of extra work. We recently...

Search Folders in Outlook

Search Folders in Outlook

Are you constantly doing the same searches over and over again?  You don’t want to move the emails into a specific folder or the emails you are searching for have been filed in more than one folder?  Then search folders could be a great addition to your Outlook...

Attendance Register in Microsoft Teams

Attendance Register in Microsoft Teams

When you are running a meeting in Microsoft Teams it can be useful to have a list of those that have attended the meeting.  This may be because you are running a session for an external company and they aren’t attending the meeting themselves or for an internal...

Using the EXPAND Function to expand an array

Using the EXPAND Function to expand an array

The EXPAND Function expands an array to a specific number of rows and columns.  The expanded array can be padded with any character you require. At the time of writing this function is only available to some Microsoft 365 Insider users but is likely to roll out to...

Top 3 Problems people have with Microsoft Teams Meetings

Top 3 Problems people have with Microsoft Teams Meetings

Microsoft teams is a great tool for online meetings but every now and then you come across and problem and don’t know how to solve it.  Here are the top 3 issues that people have related to online Teams meetings and some things to try to solve the problems. My meeting...

How to show negative numbers in brackets in Excel

How to show negative numbers in brackets in Excel

Excel has some great standard formatting options in Excel included plenty for numbers but sometimes you need something a little bit different.  This is where custom formatting comes in. Show negative numbers in red using preset formatting If preset options work then...

How to move files from One Drive to Teams

How to move files from One Drive to Teams

How do you move a file that you have started working on in your own personal One Drive into Microsoft Teams once you have realised that it would be useful for all your department or group to see and/or work on it?  Many of my blogs come about due to questions that...

Allocating work resources in Project is a nightmare

Allocating work resources in Project is a nightmare

If you are using Microsoft Project and are allocating work resources in your plan (these are normally people) you may have felt that Project has a mind of it’s own!!  Particularly what happens to the duration of the tasks when more than 1 resource is added.  It is...

Changing what slicers control in Power BI

Changing what slicers control in Power BI

Slicers are a fabulous tool in Power BI producing a great user experience for filtering the visualisations in a report.  By default the slicers control all the visualisations on the page but you may need the flexibility to allow the slicer to only slice some...

Change data in a range of cells into a single column or row

Change data in a range of cells into a single column or row

A couple of new functions that are available are TOCOL and TOROW.  These allow a range of cells to be transformed into a single column or a single row of data. This is much easier than performing the same task manually. A range of cells larger than those required can...

Syncing and Unsyncing files and folders in OneDrive and Teams

Syncing and Unsyncing files and folders in OneDrive and Teams

OneDrive and Microsoft Teams are part of the Microsoft 365 suite of apps.  Both allow for file storage in the cloud (Teams is much more than just this).  This is great when you are on the move, allowing access from any computer or even your tablet or mobile phone but...

New Shared Teams Channels

New Shared Teams Channels

Teams was originally designed very much as an internal collaboration tool to be used only within the company.  However, the need to communicate with external clients or with people who work in different parts of large organisations which may have separate team sites...

Shortcuts to access Apps in Windows 11

Shortcuts to access Apps in Windows 11

There are a huge numbers of apps available when you are using your PC. Finding the quickest and most convenient way to open these based on how you work can unlock hours of saved time. Pinning and Unpinning from Start  The start button provides a list of pinned apps...

Using Number and Date Slicers in Power BI

Using Number and Date Slicers in Power BI

Slicers produce a user friendly filtering experience in Power BI Desktop. In an earlier blog I talked about Text slicers but Number and Date slicers are a little different. An example of what each could look like is shown below. Adding a Number or Date Slicer  From...

Creating a chart with vastly different numbers

Creating a chart with vastly different numbers

Creating a chart with 2 or more sets of figures, with one set much larger than the others, will often produce a diagram which is not that useful.  One set of the figures will show up perfectly but the other set are so small they can barely be seen as shown below. The...

Conversations Vs Chat in Microsoft Teams

Conversations Vs Chat in Microsoft Teams

Communication at work has more options now than just email.  Emailing has been the go to communication tool for ages and has been around for over 50 years but as the volume of emails being sent has spiralled a different approach was long overdue.  This is where Teams...

Why can’t I get my pictures to go where I want?

Why can’t I get my pictures to go where I want?

When working with pictures in Microsoft Word many people have a lot of frustration.  When you try and move the pictures they just won’t go where you want them to go and they seem to have a mind of their own!!  There are a couple of key things to be aware of when...

Using Text Slicers in Power BI Desktop

Using Text Slicers in Power BI Desktop

Power BI Desktop has many different ways to filter the data that is displayed.  One of these is using slicers.  The slicer provides a much better user experience than the filter pane making the dashboards created much more intuitive for people to use.  They also blend...

Using Immersive Reader in Microsoft Word

Using Immersive Reader in Microsoft Word

It is important that anything created in Microsoft Word is accessible to everyone. If you have trouble reading and editing your Word documents then Immersive Reader may be just what you need.  There are many options you can adjust depending on what disability you have...

Work effectively with tasks using the To Do App

Work effectively with tasks using the To Do App

Do you get overwhelmed with the number of tasks you need to complete? To Do may be just the tool you need.  It is one of the many apps available from the Microsoft 365 subscription. It can even integrate with Outlook, Planner and Teams. You can use it on a mobile...

Enhancing Sound and Video in Microsoft Teams

Enhancing Sound and Video in Microsoft Teams

Sound and video in Microsoft Teams meetings has been variable and depended to a large extent on where your meeting was taking place.  While your working environment may have been controllable to some degree this has not always been the case.  Being able to control...

TEXTJOIN Function

TEXTJOIN Function

The TEXTJOIN function in available in Microsoft Excel and is used to join the information in multiple cells together with each entry separated by a character (delimiter) of your choice.  Using this function is much simpler than having to concatenate multiple cells and...

How to quickly add a subject line to your emails

How to quickly add a subject line to your emails

Do you find that you are sending out emails with the same, or similar, subject line on a regular basis?  Do you want to find a quicker way to do this?  I have a solution for you using quick steps.  What are Quick Steps?  Make sure you are in the Mail part of Outlook ...

How do I record my slide show?

How do I record my slide show?

Recording your slide show has been a feature in Microsoft PowerPoint for a long time but it was recently revamped to make the experience more flexible and easier to master.  How do I access the recording functionality? There are 3 ways to start recording in...

How to avoid copying hidden rows and columns in Excel

How to avoid copying hidden rows and columns in Excel

It’s often what appears to be the simplest things that are frustrating and can waste us loads of time.  Copying data that contains hidden rows and/or columns is just one of these.  You might expect anything that is hidden to not be copied but that is not the case. At...

Conversations in Outlook

Conversations in Outlook

If you are familiar with using conversations in Microsoft Teams or Facebook chat or similar you will already be aware of the benefits they provide.  Everyone in the conversation or chat sees all of the messages once. This is very different to emailing when a message...

How to solve errors with calculations to external Excel files

How to solve errors with calculations to external Excel files

Have you ever created a file with loads of calculations where the information is stored in external files and then found that you need to move the original files or rename them. The problem is that if you do that the calculations break. They are looking for the files...

Working with Dates in Microsoft Excel

Working with Dates in Microsoft Excel

Dates behave quite differently to other data when using some of the features in Microsoft Excel.  It’s helpful to understand what options are available to ensure you work with them as effectively as possible.  Entering dates It is vital that dates are entered...

I don’t know how my Word document is set up

I don’t know how my Word document is set up

Word documents are often cobbled together from many different documents created by many different people all with different ideas about how they should be structured.  Getting this information copied into one file is only half the battle.  The other its to get the...

6 Windows 11 Tips

6 Windows 11 Tips

Do you want to know some really cool things you can do with Windows 11?  Here are 6 tips and tricks to check out. (Some of these will work with Windows 10 too so always worth trying if you haven’t yet updated to the latest version of the software.)  Night light  Night...

Top 5 Outlook Time Savers

Top 5 Outlook Time Savers

Microsoft Outlook (or other emailing packages) are something that most of us use on a daily basis so if we can set things up so we can save a little time then it’s got to be a good idea. This blog is aimed at Microsoft Outlook users but many of the features are also...

Working with basic questions in Microsoft Forms

Working with basic questions in Microsoft Forms

Microsoft Forms is a form creation app that is part of the Microsoft 365 suite. There are a total of 8 question types available to use. Here we explore 4 of the most popular ones.  Most question types can have a picture added to the question if you want and a subtitle...

Adding multiple subtotals in Excel

Adding multiple subtotals in Excel

Subtotals are always a popular topic on my training sessions and is often a feature even the regular Excel users have missed out on.  Even if you have used them before are you aware that you can add more than one subtotal should you need to.  Adding the first...

Why are there so many different parts to Power BI?

Why are there so many different parts to Power BI?

Power Bi is a bit different to most other packages in many ways and one of these is that there are different parts to the software which are used at different times for different reasons.  These comprise of Power BI Desktop, Power BI Service (sometime known as Power...

How to quickly create an Organisation chart

How to quickly create an Organisation chart

Organisation charts allow you to show the hierarchical structure in something like a company. If you try to create them by hand they are a nightmare because every time the structure needs to be changed a load of manual alterations follow. Countless hours can be spent...

5 New Features in Teams meetings

5 New Features in Teams meetings

New features are appearing in Microsoft Teams meetings all the time and it’s difficult to keep on top of the changes. Here are 5 changes that have occurred recently that might make all the difference to you. Assign a new meeting organiser in breakout rooms One of the...

Top 5 Powerpoint Time Savers

Top 5 Powerpoint Time Savers

Most of these options I have chosen not only save time but also help improve consistency in the PowerPoint Presentation. I love double wins!! Here are my top 5 options.  Slide Master  You sometimes need to invest time to save time and this is one of those.  By setting...

How to solve errors with calculations to external Excel files

How to solve errors with calculations to external Excel files

Have you ever created a file with loads of calculations where the information is stored in external files and then found that you need to move the original files or rename them. The problem is that if you do that the calculations break. They are looking for the files...

How do I assign a new meeting organiser in breakout rooms?

How do I assign a new meeting organiser in breakout rooms?

Breakout rooms have been part of the Microsoft Teams meeting experience since October 2020 but one of the bug bears that many people have had is that the meeting organiser has been the only one who is able to set them up and adjust them.  That isn’t a problem if the...

Top 8 improvements in the Format Pane in Microsoft Power BI

Top 8 improvements in the Format Pane in Microsoft Power BI

Formatting from the visualisations pane in Power BI has always been a little clunky to say the least.  It has often left you tackling scroll bars within scroll bars which has been really fiddly and the options available have gone on and on in one long list.  The...