What’s the Simplest Way to Create a Pivot Table in Excel if I’m Not a Math or Numbers Person?
If someone says “pivot table” do you break into a cold sweat and your hands get clammy??? You are not alone. The good news is with Microsoft Excel 365, creating and working with pivot tables is nowhere near as hard or scary as it used to be. In fact, it can be one of the fastest and simplest ways to truly make some sense of your data without needing to be a math guru! Let’s work through it together. What is a Pivot Table? A pivot table is simply a table that summarises a big list of data and presents …
7 Strategic Tips to Compress Images in Word and PowerPoint Without Ruining Your File
In this blog post we explore why you should consider reducing the size of images in Word & PowerPoint files and how to do it without ruining your presentation or documents as well as some practical tips to make sharing documents and presentations faster and simpler. Large file sizes can slow down documents or presentations in many ways. Regardless of whether you are emailing your presentation, sharing a document with colleagues or presenting online, Microsoft PowerPoint & Word can help reduce your file size and speed up data transfer minimising file issues. 7 Strategic Tips to Compress Images in Word …
How to Format a Document in Word Without Messing Up the Layout
Introduction It can be both stressful and tricking formatting documents in Microsoft Word. Even more so when a change is made and it unexpectedly messes up your layout. It doesn’t matter what type of document you’re working on, a proposal, report, or workbook, maintaining a clean and professional format is vital. In this post, I outline a step-by-step process, with a little bit of fun, to guide you through formatting your Word 365 documents without messing up your layout. Step 1: Style Like You Mean It! Minimise manual changes to documents by using Word 365’s inbuilt document styles to create …
Excel Flash Fill: Save Time by Joining Data in Seconds
Introduction Ever found yourself having to manually combine data in Excel, use concatenate or to retype or manually combine cells with data in Microsoft Excel 365? If you have, then you will love this blog post on an Excel 365 feature called Flash Fill that makes it easier to complete and flash fill common tasks. Flash fill was first introduced in the 2013 version of Microsoft Excel 365 and is available in Excel 365. It is an amazing tool that detects patterns in the data you are entering into cells in your work sheet and offers the opportunity to fill …
Why Continuous Learning in Microsoft 365 is the Key to Productivity
Introduction Microsoft 365 incorporates everyday programs Word, Excel, PowerPoint and Outlook and well as a range of additional add on applications. However, unlike previous versions of Microsoft programs that updated with a once off fee and a significant change in look and feel, Microsoft 365 (which used to be called Office and the relevant year ie Office 2013) is a constantly changing and evolving ecosystem. Its constant evolution is designed to make working with the various programs faster and easier. Changes tend to be less overwhelming, because they are incremental and ‘gentle’ designed to keep users working in a consistent …
Streamline Your Word 365 Documents with Tables : A Quick How To Guide
For organising data, presenting information with clarity or for structure, tables are a useful tool in Microsoft Word 365. For busy professionals, whilst creating a table might be easy, often the formatting and modifying can end up with you feeling frustrated and stressed. But with a few handy tips in this blog post and video, you’ve have them working FOR you and not against you! Let get started…. Why Should You Use Tables in Word 365 Document? Tables in Word documents offer a range of benefits including: It doesn’t matter if you are a business administrator working with meeting minutes, …
Collaborate with Comments in Word 365
If you are working on a document with colleagues or clients, for example a proposal, report or workbook, clear communication is vital. However, if feedback on the document is spread out amongst phone calls, meetings and emails, managing all the changes and who said what can become a challenge. But not if you know how to use the Comments feature in Microsoft Word 365! In this post I want to share why you should use comments, how to add them and I’ll share a link to a video how to, so if you are like me and need to see …
Need to Recover a Previous Version of an Excel File but Didn’t Save it?
Has there ever been a time where you felt sick in the stomach realising you have saved over the perfect Excel file? Maybe it was a simple edit, or a realisation at a later stage that the previous version of the spreadsheet really was what you needed after all? You aren’t on your own. The amazing news is, if you saved your file to OneDrive or SharePoint, Excel 365 has got your covered! Even if you didn’t save the file separately, Excel 365 has a built in feature often enabling you to easily recover what you thought you had lost. …
Don’t Sort Columns in Excel One at a Time – There’s a Much Easier Way
Ever found yourself sorting one column, then another in Excel trying to isolate the information you need? It’s a common task, but one that could be wasting time and creating unnecessary stress and frustration. There is a better way: Excel 365’s Custom Sort option. In one of my Excel videos, I take you through how using Excel’s Custom Sort it is easy to sort multiple columns in one action. This simple change can significantly enhance the way you work with data. Why Is Custom Sort A Better Solution? Although sorting via multiple filters might seem comfortable, it is not that …
