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.

Email signatures in Microsoft Outlook

Email signatures in Microsoft Outlook

Creating an email signature that is added to the bottom of any emails you send out is really useful.  It not only saves time but it can also be used as a tool to share further contact details with clients and even newsletter sign ups.  These can be added automatically...

Update to Screen Sharing in Microsoft Teams

Update to Screen Sharing in Microsoft Teams

Screen sharing has been available in teams meetings for a long time now but has recently been revamped with some extra cool features that can make sharing information with others an even more seamless experience.  Starting Screen Sharing  To start screen sharing click...

Lara’s Top 5 Keyboard Shortcuts

Lara’s Top 5 Keyboard Shortcuts

I always love a quick way to do something and shortcuts are a huge timesaver.  Now, I’ve posted about shortcuts before but I bet you have wondered which ones I find most useful in my day to day life and why so here goes!!  1. F4 – Fixes cells in Microsoft Excel  This...

How to run polls in Microsoft Teams

How to run polls in Microsoft Teams

In a meeting you may need to ask your attendees a question and be able to quickly monitor these responses. A poll is a perfect way to do this.  They can even be created and sent out before the meeting or created on the fly as a meeting progresses when required. They...

3 ways to get data into columns in Word

3 ways to get data into columns in Word

Have you got a list of data?  But it takes up a lot of vertical space and there is nothing to the right of it?  Putting the information into multiple columns could be the trick to save this wasted space.  Did you know there are 3 ways to do this though?  Columns  With...

Comparing sets of Data in Microsoft Excel

Comparing sets of Data in Microsoft Excel

Are you needing to compare different sets of data?  Do you end up copying the data several times to do this?  This is OK but what if that data then changes?  You now have multiple versions of the same data that you need to update.  But why not use scenarios instead? ...

Action queries that change data in your Microsoft Access Tables

Action queries that change data in your Microsoft Access Tables

Microsoft Access has 4 queries that change data in the tables (or create new ones) in the database that you are using. They can help you create a new table to share specific data with others, add data from one table to the bottom of another, update information with...

5 Ways to change your calendar view in Outlook

5 Ways to change your calendar view in Outlook

Getting your calendar set up the way you need to use it can make huge improvements to your productivity. Here are my top 5 tips on changing the calendar views. Add 2nd Time Zone  If you are working in an international company being able to see the time zone other...

Viewing multiple sheets in a workbook at the same time

Viewing multiple sheets in a workbook at the same time

A question I often get asked in courses is how to compare data that’s on different Excel sheets easily without having to constantly flick backwards and forwards or copy one of the sheets into a new file first. Neither of these solutions are ideal and copying the sheet...

Microsoft Templates

Microsoft Templates

Did you know that Microsoft provide pre-created templates for all sorts of things so if you don’t know where to start, want to save yourself some time or have tried to create a document and it doesn’t quite work then why not check out what is already on offer.  There...

Customising the Start Menu

Customising the Start Menu

Speed up accessing applications by customising the Start menu  In Windows 10 everything can be accessed from the start menu and in addition tiles for common applications can be used to get to some of the most popular products more quickly without having to scroll down...

Go back in time with Version History

Go back in time with Version History

There used to be a time when once you had saved a document there was no way to get back to an earlier version. Up to that point Undo is invaluable.  In Microsoft 365 Version History makes it really straightforward to go back in time if you realise that a mistake was...

Top 5 ways to move data in Excel

Top 5 ways to move data in Excel

Who would have thought that there were so many ways to do the same thing!!  The last thing you want to do if you have put things in the wrong place is a full retype.  So take your pick from these options to move data from one place to another efficiently.  Cut and...

What is the To Do Bar?

What is the To Do Bar?

On my recent training sessions I have found that there have been 2 tools that my delegates have loved in Microsoft Outlook which go hand in hand. The first is flagging for follow up, but not just your normal flagging, incorporating a date related element as to when...

Consolidate data in Excel

Consolidate data in Excel

Are you trying to consolidate data or summarise data in Microsoft Excel? You try a calculation but the order of your data is all over the shot and autofilling it just isn’t going to work. This is going to be a long and arduous task – or is it!!  Although I always...

Drink when working at a computer

Drink when working at a computer

I am not ashamed to say I love a good cup of builders tea and try not to count how many I consume before my working day is through but there must be some better alternatives. Isn’t there? In this second guest blog from Gwen from It’s from scratch she explores some...

Teams or One Drive?

Teams or One Drive?

I often get asked this question, particularly by small businesses who are wondering which of these apps they should be using. For tiny businesses One Drive may well be enough but for larger businesses where consistent communication between individuals within the...

Top 3 tips on File Explorer

Top 3 tips on File Explorer

File explorer is one of those things we use all the time but by using it’s full potential it can be much more efficient to work with. These top 3 tips will improve your productivity.  1. Pin to Quick Access  Have you noticed the quick access section on the left of the...

Calculations across worksheets and workbooks

Calculations across worksheets and workbooks

There are many times and many reasons your data will not all be stored on the same sheet. But what if you need to get information from one sheet to another or perform a calculation.  Microsoft Excel is designed to handle this with ease!  Calculations in general ...

Template Pages in OneNote

Template Pages in OneNote

Can I quickly create similar pages using OneNote page templates?  If you haven’t used OneNote before it is a searchable electronic notebook.  Great for use on the go and impossible to lose!!  Each notebook can consist of many pages, amongst other things, and some of...

Squarespace Websites

Squarespace Websites

Why I think a website on Squarespace is a good option Following on from my series of guest blogs the lovely Lucinda will enlighten you on Squarespace websites. I always think it’s important to be aware of what other tech is out there as a technical trainer.  While it...

Using the XLOOKUP Function in Excel

Using the XLOOKUP Function in Excel

Which is better XLOOKUP or VLOOKUP? You may well have heard of the VLOOKUP function, you may even have heard of the HLOOKUP function but the new kid on the block is the XLOOKUP!  What is an XLOOKUP?  The XLOOKUP function is used to look up data in a table.  It is...

Dictate

Dictate

Can I dictate my content in Microsoft Word, PowerPoint and Outlook?  Do you find that you are spending ages typing information into your documents?  Wish you could just dictate the information instead?  Well you can!!  If you are using Office 2016, Office 2019 or...

Use Microsoft Delve for improved searching

Use Microsoft Delve for improved searching

Microsoft Delve is one of the apps that are part of the Microsoft 365 suite.  Delve enables you to search and organise your files more efficiently find information about all the people you work with from one central location.  It will only ever show you information...

IFS Function

IFS Function

The IFS function enables you to perform multiple outcomes based on multiple conditions. This significantly simplifies how to perform this sort of task. Until recently you would have needed to combine IF functions inside of IF functions which was referred to as nested...

Guest Blog: Food when working at a computer all day

Guest Blog: Food when working at a computer all day

Top tips for food when working at a computer all day Being stuck in from of a computer pretty much all day every day can lead to bad habits.  It’s so easy to reach for that packet of crisps or packet of biscuits without a second thought. Gwen from It’s from scratch...

Communicating in Teams meetings

Communicating in Teams meetings

Meeting online rather than face to face has some cons but many pros too. One of the things that is more difficult remotely is being able to read peoples body language.  Here we will look at how the camera, raise hand and new emoticons can be used to help improve...

How to Automatically Number Headings

How to Automatically Number Headings

Numbering in Microsoft Word can cause a bit of a headache particularly if these are connected to headings in your document. If you don’t get it set up correctly then you find that you are manually adding numbering that doesn’t update when you add a new section or move...

How do you SWITCH data in Excel?

How do you SWITCH data in Excel?

Until Excel 2019 the SWITCH function did not exist but since then it has provided a viable alternative to using nested IF functions, IFS or VLOOKUPs. It evaluates one value (called the expression) against a list of values and returns the result corresponding to the...

Finally – Breakout rooms in Microsoft Teams!

Finally – Breakout rooms in Microsoft Teams!

After a long wait breakout rooms have now landed in Microsoft Teams. Although they are available there are likely to be some changes to the finer detail over the next few months as some of the little quirks are ironed out. Breakout rooms can currently only be created...

How do I use Icons in Microsoft Office?

How do I use Icons in Microsoft Office?

Have you come across Icons?  For years we have been able to add pictures and shapes to files to add interest and focus but recently Icons have been added to that list. This option is only available in Microsoft 365.  If you used clipart back in the day then icons have...

What is Snip and Sketch?

What is Snip and Sketch?

One of the many tools that come with Windows 10 is Snip and Sketch (formerly the Snipping tool).  It’s a feature I use all the time whether to add images to blogs, manuals or quick reference guides. What I didn't consider that I can't use the Snip and Sketch tool to...

Can I run a webinar from Microsoft Teams?

Can I run a webinar from Microsoft Teams?

Microsoft Teams meetings are great to get together a few people but for a larger scale online webinar the option of Live event is going to a much better bet. The organisers can line up content for a more seamless experience, changing smoothly from one presenter to...

How to create a Quick Reference Guide in Microsoft Word

How to create a Quick Reference Guide in Microsoft Word

This blog has been prompted by the need to create a quick reference guide (QRG) recently for a client.  A quick reference guide is designed to cover the key points on a topic at a glance but doesn’t go into all the detail you might expect from a manual.  It’s enough...

Microsoft Teams templates and more new features

Microsoft Teams templates and more new features

Microsoft Teams just keeps on giving by adding more functionality or making the existing functionality easier to use.  While most of the recent changes have been in the meeting side of teams other parts of the software have also been tweaked to improve the user...

Cell Styles in Microsoft Excel

Cell Styles in Microsoft Excel

Consistent formatting helps to make documents look tidier and makes them easier to read and understand.  One feature that can help with this is cell styles.  There are over 40 pre-created styles for you to get started with or you can create your own bespoke designs to...

What are cover pages in Microsoft Word?

What are cover pages in Microsoft Word?

So you have got this great document but you want it to really stand out with a funky front page.  This is where cover pages can be used.  There are 16 available directly from Microsoft Word which can be modified as required.  There are 3 more available at office.com...

Top 3 reasons to Format as Table in Microsoft Excel

Top 3 reasons to Format as Table in Microsoft Excel

An often underutilised option in Microsoft Excel is format as table.  However, it can have a significant positive impact on your productivity when working with data stored in a table layout. It can be accessed from the Format as Table option on the Home tab or from...

3 Page Background features in Microsoft Word

3 Page Background features in Microsoft Word

 There are 3 page background features that you can change in Microsoft Word.  This article refers to the version of Word available from the Microsoft 365 subscription.  Although these options are available in other versions their location on the ribbon may vary. The...

I have no ideas what to do with my Excel data!!

I have no ideas what to do with my Excel data!!

With the volume of data we now get bombarded with on a day to day basis it’s not always easy to decide what to do with it all. If you have no idea how to get started why not let Excel provide some ideas for you. The ideas button is available in Microsoft Excel if you...

How do I troubleshoot Excel Calculations?

How do I troubleshoot Excel Calculations?

Excel is a brilliant calculation package but when your calculation goes wrong where do you start to troubleshoot Excel calculations?  This article gives some key features that are available that will help. Double clicking on the cell By double clicking on the cell...

PowerPoint Subtitles

PowerPoint Subtitles

Subtitles are a new feature in PowerPoint as part of the Microsoft 365 suite.  I attended a training session about accessibility the other week and realised that many who have created and run presentations for years would probably be unaware this option exists.  A lot...

Filled Maps in Excel

Filled Maps in Excel

Do you work with geographical data?  By showing this information on a map the data can be understood more easily.  It can be used with countries, counties or post codes. Setting up the data for filled maps The first step involves creating a simple summary table...

Manage a Successful Teams Meeting

Manage a Successful Teams Meeting

As a change from my usual blogs about the features available in Microsoft products this is aimed more at how to use the software effectively in general to manage a successful Teams Meeting. Since March 2020 online meeting software has become a staple for many...

Top 3 Calculation Tips

Top 3 Calculation Tips

Want to know my top 3 calculation tips when your calculations go wrong?  When creating calculations in Excel there are some built-in features that are helpful to know about and understand to guide you along the way. Automatic correction In some cases Excel will...

Top 6 tips when creating slides

Top 6 tips when creating slides

Here are my top 6 tips when creating slides.  This is a slightly different post to most that I create because it is less about how to use the software and more about the design side of the PowerPoint slides. We have all seen presentations using Microsoft PowerPoint...

17 fabulous Visualisations in Power BI

17 fabulous Visualisations in Power BI

There are a wide range of Visualisations in Power BI to help those viewing the published report to understand the data they are portraying quickly and efficiently.  The chart options have already been looked at in an earlier blog so here we will be looking at all the...

What is Microsoft Sway?

What is Microsoft Sway?

Sway is one of the apps in the Microsoft 365 suite and is used to create presentations.  While it isn’t as flexible as Microsoft PowerPoint it has a different look and feel which can be a refreshing change and is quick and easy to create once you know how it works....

Where has spell check gone?

Where has spell check gone?

With Microsoft 365 constantly updating all its products it is no wonder that at times options that we have used for years just disappear.  One of these is spell check!!  But where has it gone!!  There is a new kid on the block with the Editor icon on the Review tab....

MEMBERSHIPS

FOLLOW LARA