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.

Where has spell check gone? Welcome Editor!

Where has spell check gone? Welcome Editor!

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

18 Chart Types in Power BI

18 Chart Types in Power BI

Power Bi has a wide range of different types of visualisation to help those viewing the published report to understand the data they are portraying effectively.  Many of these are charts or graphs which are great at displaying relative sizes of data, trends over time,...

How to Sort and Filter using Dynamic Array Functions in Microsoft Excel

How to Sort and Filter using Dynamic Array Functions in Microsoft Excel

Dynamic array functions are only available in the Microsoft 365 version of Excel.  They are very different to many of the other functions as they allow you to work with multiple values at the same time in a formula.  The result is not normally one solitary cell but a...

5 steps to create Microsoft Forms

5 steps to create Microsoft Forms

Microsoft Forms is a form creation app.  It can be used to produce surveys, quizzes and polls and is part of the Microsoft 365 suite. There are so many apps available in Microsoft 365 and this is a little cracker!!  It is so simple to use and something that anyone who...

5 video features in PowerPoint including animated GIFs

5 video features in PowerPoint including animated GIFs

Beyond the obvious option of inserting a video file into a PowerPoint presentation there are several other options worth looking into from helping compatibility to reducing file size, from creating a video to send or an animated GIF to use in social media (my new...

Top 10 Microsoft Teams New Features

Top 10 Microsoft Teams New Features

More and more people have been partaking in online meetings over the last couple of months whether that be using Microsoft Teams, Zoom, google hangouts or other software. Microsoft Teams was set up as a business collaboration tool but with larger meetings now being...

Guest Blog: Top 5 tips for tidying up customer email lists in Excel

Guest Blog: Top 5 tips for tidying up customer email lists in Excel

In the third of a series of guest blogs, Alan Sawyers of A.S. Design, Web & Marketing looks at his top five tips for tidying up customer email lists in Excel.​.. I look after several ecommerce sites. Some of them my own, some of them for clients. And one of the...

Top 7 Microsoft Project options

Top 7 Microsoft Project options

Microsoft Project default options are really worth considering changing.  Some of these will depend on how you use the software and others really should be altered. All these options are found from the File menu under options.  Many can be altered for this project or...

Top 8 Sending email options

Top 8 Sending email options

Most of the time when we create emails we type in the information, maybe add a file attachment, and then send across to the recipient. But what options are available that can help us, and the person we are sending to, before we ping that email across?  Here, my top 8...

Top 6 Power BI Conditional Formatting Options

Top 6 Power BI Conditional Formatting Options

If you haven’t some across conditional formatting before then it allows formatting to automatically be applied based on the data.  If the data changes then the formatting automatically updates.  Conditional formatting has been a useful tool in Microsoft Excel for...

Top 7 Excel Date functions

Top 7 Excel Date functions

Excel date functions can be used to manipulate dates in many different ways.  You may need to know how many days it is since you sent an invoice or analyse when your sales take place in the month.  You may need to summarise your data based on the month or calculate...

Microsoft Teams keyboard shortcuts

Microsoft Teams keyboard shortcuts

Microsoft Teams keyboard shortcuts can be used to navigate around this product more quickly.  This latest blog follows on from the series of blogs already written on general keyboard shortcuts and more specific ones for Microsoft Word, Excel, PowerPoint, Outlook and...

Guest Blog: How to Deal with Tech Overwhelm

Guest Blog: How to Deal with Tech Overwhelm

In this second guest blog the lovely Laura Forsyth from Forsyth Business Consultancy talks about how to deal with, and keep on top of, the volume of technology in our lives. Technology has rapidly advanced over the history of mankind, through the recorded pictographic...

Top 5 Tips for opening files quickly

Top 5 Tips for opening files quickly

We open files all the time so anything we can do to make this process quicker has got to be beneficial.  Depending on how often you work with files and where they are located will depend on which of these options are likely to be of most benefit.  Why not give some of...

Use Design Ideas to create mind blowing slides

Use Design Ideas to create mind blowing slides

Have you come across Design ideas in Microsoft PowerPoint?  It is a new innovative option that can help you change a basic presentation into something far more interesting with minimal effort. It is so easy to create presentations where all the slides look very...

Do headers and footers get you in a pickle?

Do headers and footers get you in a pickle?

Have you ever tried getting different headers and footers in different sections of a Word document?  It can be a tricky process but if you follow this logical set of steps you will find it simple. For example, you might need a title page with no header or footer at...

Top 6 Save as types

Top 6 Save as types

The majority of the Microsoft suite of products have these options when you are saving.  Although the default options of Excel Workbook, Word Document, PowerPoint presentation etc are used most of the time these other Save As options are extremely useful in certain...

Top 6 Microsoft Word options

Top 6 Microsoft Word options

Did you know that you don’t have to put up with many of the default settings you get with Word if they don’t fit with the way you work.  Here are 6 of my favourite Microsoft Word options to change.  All these options are available from the File menu and options. Open...

Working with Multiple Projects

Working with Multiple Projects

Individual projects are a great way to plan for what you and your immediate team are doing but sometimes this forms part of a bigger picture and it is important to see how your part fits into the whole.  This is where working with multiple projects becomes useful. ...

Top 8 Excel default options

Top 8 Excel default options

Did you know that you don’t have to put up with many of the default settings you get with Excel if they don’t fit with the way you work.  Here are 8 of my favourites.  All these options are available from the File menu and options. 1. Changing the default save...

Connecting Data in Power BI

Connecting Data in Power BI

I’ve previously written about what Power BI is and why it’s such a useful tool but I’m now going to look in more detail about connecting the data in other applications into Power BI so you can then work with it. Connecting Notice that the data is not copied or...

Guest Blog: Your Start Up Business and Computers

Guest Blog: Your Start Up Business and Computers

In this first guest blog the wonderful Michael Donkin from Northumberland Computer Support talks about what you need to be aware of with regards to computers when you start up your business. So, you’ve started up in business on your own? Well done! That’s the hard...

Top 5 Outlook defaults to change

Top 5 Outlook defaults to change

Outlook has loads of really cool default options that can be altered to make your use of the package even better by tailoring it to your exact requirements.  The default options are available from the file tab and options.  Here are my top 5 favourite Outlook...

Is there an easier way to navigate around large Excel data?

Is there an easier way to navigate around large Excel data?

When you have a large document it can become tricky to move around but with a few special tools it can become a lot easier to navigate Excel. Navigating to the top and bottom of the document There are some great keyboard shortcuts that can help you with this. CTRL +...

What is Power Query used for in Excel?

What is Power Query used for in Excel?

How many times have you ended up using loads of VLOOKUPs to show data from 2 or more different tables together?  Although this works it is very memory intensive which on large spreadsheet can cause delays in updating at best or crashes at worst.  Have you always...

Help!! How Microsoft can put you on the right track

Help!! How Microsoft can put you on the right track

There has always been a help facility with the Microsoft packages but it has certainly changed over the years giving assistance on all aspects of the software. Clippy Remember good old Clippy who used to pop up at the most inopportune moment, waving at you and trying...

5 Useful Tools to Align objects in PowerPoint

5 Useful Tools to Align objects in PowerPoint

It is not always easy to align objects accurately and quickly in PowerPoint but you will need to do this if you re creating a custom design in PowerPoint.  Luckily there are some features in the package that can help. These tips work in a similar way in most of...

How to create a wonderful Watermark!

How to create a wonderful Watermark!

Do you want to mark your documents as confidential or add your company logo subtly in the background on each page.  If so then watermarks are the option you need. Creating a Watermark The watermark option has moved between the tabs on different versions of the...

Microsoft PowerPoint Hidden Options

Microsoft PowerPoint Hidden Options

There are plenty of options available directly on the ribbons in Microsoft PowerPoint but some sections have plenty more options that you might need at some point.  These options are the ones that Microsoft thinks most users are less likely to need but might...

Using COUNTIF, SUMIF and AVERAGEIF to Summarise Data

Using COUNTIF, SUMIF and AVERAGEIF to Summarise Data

You’ve got a whole list of information but what do you do with it?  You may want to know how many records you have of a particular type or the total or average of that set of data.  There are several different ways to get this information.  You could...

Collaborating with Microsoft Teams

Collaborating with Microsoft Teams

Microsoft Teams is one of the most powerful apps in the Office 365 setup.  It is a collaborative tool designed to enable groups of people to share their work files and edit them at the same time, to chat in a shared environment, communicate ideas using a shared One...

Top 4 Email Search Options

Top 4 Email Search Options

Do you find you keep losing emails and can never find them again?  Here are my top 4 tips on how to perform an Email search effectively in Microsoft Outlook. Basic Search By clicking in the search bar at the top of the email list you can type what you need to...

How to Change Working Time in Microsoft Project

How to Change Working Time in Microsoft Project

You need to change working time is Project plans to reflect the hours and days the company is open and the hours and days the individuals in the company work. If you do nothing with the calendars available then Project will assume that work is being carried out from 8...

Are you struggling to filter Pivot Tables?

Are you struggling to filter Pivot Tables?

Pivot tables are great at summarising large volumes of data but even then, the data can sometimes still be too huge to deal with.  This is where filtering, slicers and timelines come in enabling you to work with a subset of the original data. They all effectively...

Colour code meetings and appointments in Microsoft Outlook

Colour code meetings and appointments in Microsoft Outlook

Do you have a calendar that is unmanageable?  To be able to get an overall view of your commitments, both personal and business, you really need them all on the same calendar.  But then you often can’t see the wood for the trees. If only you could colour code your...

Microsoft Excel Hidden Options

Microsoft Excel Hidden Options

There are plenty of options available directly on the ribbons in Microsoft Excel but some sections have plenty more options that you might need at some point.  These options are the ones that Microsoft thinks most users are less likely to need but might require...

How to work with the Table of Contents in Microsoft Word

How to work with the Table of Contents in Microsoft Word

Have you ever created a long document in Microsoft Word and needed a table of contents at the beginning to help you see the structure of the document and find your way around it?  Have you produced this manually and therefore find that if you make any changes to...

How do I use One Drive to Share Files?

How do I use One Drive to Share Files?

Why would you use One Drive to share files? You have a file that you want to share with someone else.  Or even a folder that contains a range of files that you want to work on together.  Emailing the files is OK but you are now working on totally independent...

Working with Page Breaks in Microsoft Excel

Working with Page Breaks in Microsoft Excel

Where do Page Breaks go? In Excel the page breaks naturally fall when you run out of room on the page.  At this point Excel pushes the next row or column of data onto the next page.  But what if this is not what you want to happen. There are 2 ways to alter...

Sending out Similar Emails Quickly

Sending out Similar Emails Quickly

Sending out similar emails quickly can result in a huge time saving if we are doing it regularly. Have you ended up retyping the email from scratch or hunting in your sent items for the last one you sent that was close to what you want and copying and pasting this to...

Microsoft Word Hidden Options

Microsoft Word Hidden Options

There are plenty of options available directly on the ribbons in Microsoft Word but some sections have plenty more options that you might need at some point.  These options are the ones that Microsoft thinks most users are less likely to need but might require at...

Minimise Files Size for Pictures and Videos

Minimise Files Size for Pictures and Videos

If you are working with files that contain lots of high-quality images or any videos in PowerPoint you may need to minimize file size for pictures and videos. Otherwise, the size of your files can become huge very quickly.  This article looks at a couple of...

Top Tips to Sorting and Filtering in Excel

Top Tips to Sorting and Filtering in Excel

Sorting and filtering are 2 of the most used analysis tools in Microsoft Excel.  By arranging the data in a logical order it is easier to see any patterns and using filters to extract specific details tailors our view to exactly what we want to see eliminating...

Microsoft Outlook Hidden Options

Microsoft Outlook Hidden Options

There are plenty of options available directly on the ribbons in Microsoft Outlook but some sections have plenty more options that you might need at some point.  These options are the ones that Microsoft thinks most users are less likely to need but might require...

10 Green Triangles sitting in Excel!

10 Green Triangles sitting in Excel!

You may have seen these green triangles but don’t really know what they are trying to tell you but if you understand them they can be a really useful tool in troubleshooting spreadsheets. The green triangles in Excel tell you if there is potentially some sort of error...

10 step guide to creating Flow Charts

10 step guide to creating Flow Charts

If you have tried to create flow charts in Word or PowerPoint you will know that the SmartArt graphic options are very limited while drawing one using the drawing tools in fiddly and time-consuming.  That’s where Visio comes in.  As a dedicated diagram...

Top 4 Ways to Manipulate Text using Functions

Top 4 Ways to Manipulate Text using Functions

In Excel there are loads of functions and almost 30 of these are designed to specifically manipulate text.  Here we will look at the top 4 different types of text functions. Text Functions to Clean your data There are 2 functions we will look at here.  Trim...

Top 5 Tips for Copy and Pasting into PowerPoint

Top 5 Tips for Copy and Pasting into PowerPoint

So you’ve created all this information in Excel, Word or other packages but you now want to show it in a PowerPoint presentation but when you copy and paste it goes horribly wrong.  What options do you have to rectify this? Don’t do it! The first question to ask...

Planner Vs Microsoft Project

Planner Vs Microsoft Project

Both planner and Microsoft project are project planning tools but which one should you use and why? Planner Planner is one of the tools available in Office 365 Pros Free if you have already purchased O365.  It is one of the apps automatically available with the...

MEMBERSHIPS

FOLLOW LARA