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.

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

Autofill to Quickly Enter Lists

Autofill to Quickly Enter Lists

Did you know that standard lists can be created at speed in Excel without a lot of manual inputting?  If you are working with standard lists of information then autofill lists are something that could save you significant amounts of time.  Autofilling is...

Baseline and Tracking in Project

Baseline and Tracking in Project

By using a baseline and tracking, a proposed plan can be recorded and then the changes to this plan in relation to the original can be viewed.  Project planning is more than just creating a plan and hoping it stays on track!  By monitoring progress against...

Key New Features in Office 2019

Key New Features in Office 2019

We all like new features and Office 2019 has some really cool new options for you to get to grips with.  These are also available in O365. Scalable Vector Graphics Or icons to you and me!!  There are a whole range of icons that can be added to Word, Excel...

Rubbish in, Rubbish out!

Rubbish in, Rubbish out!

If you have rubbish data then you will get rubbish information from it! So often I find clients who can’t get any decent analysis from their Excel data and it isn’t always because they don’t have the right tools at their disposal.  It’s sometimes because their...

Bullets Points in PowerPoint

Bullets Points in PowerPoint

Bulleted lists are regularly used in PowerPoint to produce key points that can be discussed as part of a presentation.  This article will explore some of the options you can change with these to customise your presentation. Adding Bulleted Lists There are 2 main...

Customised Formatting in Excel

Customised Formatting in Excel

Have you ever found that the number, date or time format that you want to use isn’t available?  These can be customised to provide exactly what you need.  These options are found from the format cells option, selecting number, then custom. Number Formats...

Top 10 Microsoft Features

Top 10 Microsoft Features

I often get asked what are the wow moments that people get in the Microsoft training courses I run?  Those features which you didn't realise were there so you were working in the dark! These are often not the most complicated features but the actions that are...

MEMBERSHIPS

FOLLOW LARA