Free Microsoft Office tips and tutorials

5 Compelling Reasons to Embrace Microsoft Power BI

Ready to supercharge your data insights? Watch Jane's training video to uncover the 5 game-changing reasons why Microsoft Power BI is a must-have tool.

Tips for Microsoft Excel Date and Time

Adding the date and time to Microsoft Excel spreadsheets is commonly needed however when doing it for the first time it can be daunting. We have put together 4 Tips to so you can do this easily and efficiently.

What is Microsoft Power Automate?

Power Automate (previously called Microsoft Flow) is an online workflow service that automates actions across the most common apps and services.

SharePoint Tip: Integrating Microsoft SharePoint Online Library with Office 365

Our trainer Jane explains how Microsoft SharePoint library integrates with Office 365.

Microsoft SharePoint Tip: Handling multiple versions of a document

Here our trainer Jane explains how to handle multiple versions of a document using Microsoft SharePoint Online Libraries in under 5 minutes!

Top 5 Microsoft Excel Time Saving Tips

Microsoft Excel is one of the most powerful software tools in the world for collecting, analysing, and summarising data. Discover our top 5 time saving tips using Excel.

PowerPoint tip: Managing objects on a slide

It can get confusing to select and manage objects when a PowerPoint slide has too many items, like this one:

Excel tip: An easier way to AutoFill thousands of rows of sequenced data in Excel

Most people have used AutoFill in Excel to copy a formula or create a sequence in adjacent cell.

SharePoint Tip: searching your site using wildcards and exact phrases

Learn how to search your site with Wildcards and Exact Phrases in SharePoint

Excel Tips: Show leading zeros on numbers

If you want to keep a leading zero on a number, a workaround people often use is to format the cell as text or type an apostrophe before the number – e.g. '0822 will automatically store the leading zero, but keep the text as a number. But what if you want to have numbers that display leading zeros, and keep the numbers as a numeric value?

Microsoft Word tip: updating fields in long documents

Heres how to update all fields at the same time, including those in headers, footers and, and different sections:

Excel tip: Making the most of Excel's conditional formatting

There is so much you can do with conditional formatting in Excel, and you will save yourself a lot of time in the long term if you take a little time to learn a few tricks. If you are new to conditional formatting, one quite easy feature to get you started is highlighting duplicated data.

PowerPoint tip: Resetting a Slide To The Default Layout

In Microsoft PowerPoint, most slides start from one of several predefined layouts. You can insert text, pictures, tables, charts, diagrams, and videos when you use the placeholders included in the layout. You can easily format the page and make sure that slides maintain a standard look and feel.

Excel tip: How to use Get & Transform to Merge Columns

The Get and Transform feature of Excel 2016 sounds new, but some of you may know it by its old name, Power Query. You now get the data, and then you transform it, hence the new name.

Excel tip: Map your data with 3D Power Map

Power Map has become even more powerful in Excel 2016 – you can take a table of data with geographic information and create impressive 3D maps.

SharePoint tip: How to create a form in InfoPath

In our SharePoint Site Owner Advanced course, one of the topics we will teach you is how to create a form in InfoPath, and how it can be easily linked to a SharePoint list or library. Follow these steps to make the link to a form library.

Excel tip: Make an interactive button bar with Power View

Power View is used to examine and analyse data and is just one of the features you will learn about in our Excel Advanced Data Analysis course.

Excel tip: How to copy code into the VBA editor

In the VBA for Microsoft Excel course, you will not only learn how to record macros in Excel, but write the code behind them.

Excel tip: How to create related tables in PowerPivot

PowerPivot is used to for connecting and manipulating data, particularly from external sources. It allows you to connect tables of data that have common fields (just like a relational database) and is just one of the features you will learn about in our Excel Advanced Data Analysis course.

Excel tip: Use flash fill to extract data in separate columns

Flash Fill recognises a pattern in your data and is a great tool to extract a field and break it down into its component elements.For example, in this video tip Column A has the first and last name in one field. Flash Fill makes splitting the names up into two separate cells (first name and surname column) very easy.

SharePoint tip: How to create a Wiki library

Learn how to create a Wiki Library in SharePoint with our free tutorial on Microsoft SharePoint.

PowerPoint tip: How to create slides from a Word doc

Information required for a presentation may already exist in a Word document. You're able to import this information into a PowerPoint presentation without having to retype or cut and paste.

Top 5 Microsoft Excel tips you probably don't know

There are so many hidden features in Excel, it could take a lifetime to learn them all. Thankfully, we have done the hard work for you, and come up with five very helpful Microsoft Excel tips to resolve some of the questions you never even knew to ask about Excel.

Microsoft Word Tip: Using and managing section breaks

Discover our handy tips to use sections breaks in Microsoft Word

Excel tip: How to create a sequence of dates in Microsoft Excel

Need to create a sequence of dates? It's very easy using Excel's AutoFill feature.

Microsoft Word tip: The difference between pressing Enter and Shift-Enter

Most people know that when you press the Enter key on the keyboard when using Microsoft Word, a new line is inserted into the document. What many people don’t realise is the difference between pressing Enter and Shift-Enter.

Microsoft Outlook tip: Create an Quick Step to Automate Actions

A Quick Step is a feature that lets you make a shortcut to any multi-step action. For example, moving emails and marking them as read, or forwarding an email and flagging it. It makes short work of a repetitive task.

Tips to help your team to embrace their SharePoint intranet

Staff intranet sites are driven by people actively contributing and collaborating. If your site doesn’t get this “buy-in” from the users, it is destined to fail.

Excel tip: Custom Cell Formatting in Excel

Want some clever cell formatting in Excel but get confused by the Custom Format Cell options? Here is a quick tutorial to writing clever cell formats.

Excel tutorial: Pasting Values with Drag and Drop

Pasting the values from a formula (so that the numbers never change) has always involved several steps. Often you want to calculate an answer, but store the number, not the calculation.

Excel tip: Generate a pivot chart with a slicer

A PivotChart is an interactive chart that provides a graphical analysis of data. Your data comes from existing tables, databases or PivotTable reports. A slicer is a visual filter that allows further insight into a particular field. You can learn more about PivotCharts in our Excel Advanced and Excel Advanced Pivot Tables courses.

Excel tip: How to create a drop-down list in Excel

In this video, you will learn how to create a drop-down so you can select from a list without having to retype each time. In this example, we have a simple database with a Department field and will create a list of departments as the drop-down list.

Excel tip: Analysing data by date using PivotTables

One of the simplest changes in Excel 2016 relates to date data when you're working in a PivotTable. In prior Excel versions date data was added to the PivotTable as is.

SharePoint tip: How to create a document library

To create a Wiki library you'll need to have the appropriate permissions as a Site Owner.

Excel tip: Enable the Power add-ins

The Excel 2016 Power add-ins allow extra functionality in Excel. This includes Power Pivot, Power View, Power Map, and Power Query (Excel 2013).

Excel tip: Use Get & Transform to connect to a website

Taking data from a web page and linking it to a spreadsheet has never been easier. Here is a website with the latest currency exchange rates. This data at xe.com refreshes regularly. We want to bring this data into cells in the spreadsheet, even if it currently isn't laid out the way we want to display it in Excel.