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.

Top 5 Microsoft Transferable skills

Top 5 Microsoft Transferable skills

If you ever attend one of my training sessions you will hear me go on about transferable skills.  Compare it to the deals you get of ‘buy one get one free’ or ‘two for the price of one’. These are the things you can learn in one package which work in the same, or a...

How to use data validation lists to produce consistent data

How to use data validation lists to produce consistent data

I often talk about the rubbish in / rubbish out scenario.  If you don’t have consistent data then you cannot analyse it properly.  Using lists in data validation in Microsoft Excel can really help with this.  Creating a data validation list  There are 2 steps to...

Working with Long documents effectively using Outline View

Working with Long documents effectively using Outline View

If you are working with long documents in Microsoft Word it can be time consuming and fiddly producing a consistent structure and moving large chunks of text and other information around.  Outline view can be a huge help with this.  Accessing Outline View  Click on...

Can I work offline in One Drive and Teams?

Can I work offline in One Drive and Teams?

Microsoft Teams and OneDrive are both part of the Microsoft 365 suite which is referred to as cloud based software.  This appears to indicate that the software can only be used when you have access to the cloud, in other words are connected to the internet.  If this...

Removing sensitive data from Microsoft Files

Removing sensitive data from Microsoft Files

When we create any documents we add all sorts of sensitive and personal data for all sorts of reasons, some of which we may not even be aware of!!  What we don’t want is to send these documents to clients or others without getting rid of all these things.  We could...

Top 5 Excel Data Tips

Top 5 Excel Data Tips

One of the key things that Excel is used for is storing data but there are some pitfalls to avoid.  Here are my top 5 tips when working with data. 1. Arrange data in a table format  If you are using Excel to store information then it’s a really good idea to always set...

Why is my inbox always full?

Why is my inbox always full?

This post was prompted by one of my delegates who was having exactly this issue and didn’t know why!!  Have you ever had a message to say your mailbox is full?  You clear out loads of emails from your inbox and within a few days the same message reappears?  How can...

How to use YouTube Videos in a PowerPoint Presentation

How to use YouTube Videos in a PowerPoint Presentation

Adding a video to a presentation can provide some well needed variety to your slide show.  As more and more businesses are realising the power of movie content they are often creating promotional videos that are available from a corporate YouTube channel or other...

2 ways to compare information in a Microsoft Word document

2 ways to compare information in a Microsoft Word document

A short while ago I wrote a blog about how you can view 2 different sheets in Excel at the same time and it has proved so popular I thought that the equivalent in Microsoft Word would be useful too.  If you are working on a long Word document you may need to be able...

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...

MEMBERSHIPS

FOLLOW LARA