How to Create Tables in Microsoft Word 365
Ever wasted time after inserting a table in a Word document trying to resize column widths and end up tottally messing up your table? Or perhaps you want to get the column headings onto the next page without copying and pasting them? When I present at conferences or in house workshops, when I show people how easy it can be to work with tables, they get so excited and so do I! Take a look at how easy it is to do when you know how! Sometimes it is simple things that can make all working with programs such as …
How to Filter Multiple Columns at once in Microsoft Excel
When I work with clients I often seem them filtering data lists slowly one column at a time. When I show them how easy it is to filter multiple columns at once, it literally blows their minds! Check out how easy it is to do in the video I put together below. Want more Microsoft 365 Core Four (Word, Excel, PowerPoint & Outlook) tips? Subscribe to my free eNewsletter here or go to www.donnahanson.com.au/subscribe …
How to Save an Email
Ever had an email you wanted to save? Generally, you want to save it somewhere other than in Microsoft Outlook, well you can…. In the same way you can only open a Word document in Microsoft Word and an Excel spreadsheet inside Microsoft Excel, emails can only be opened inside Microsoft Outlook. However, there may be times where you want to save that email somewhere else, for example in a customer folder, or in a personnel file so all documentation such as proposals or in the case of personnel contracts are in the one location. Here is a super simple …
How to rename worksheet tabs in Microsoft Excel
It may sound crazy, but renaming worksheet tabs in Microsoft Excel can be a game changer. Especially if you share your worksheets with others. It makes it easier to find information and simplifies the process of finding the right data quick and easy for users who may not be as experienced as you with Microsoft Excel. To see how easy it is to do and why you would do it, check out this video I put together. Get more free Microsoft 365 core four (Word, Excel, PowerPoint and Outlook) tips and shortcuts.Subscribe to my free monthly eNewsletter here. …
How to Hide Zero Values in a Microsoft Excel Pivot Table
I love pivot tables because they require absolutely NO formula or function knowledge in Microsoft Excel. With the click of a few buttons you can easily summarise your data and look like a pro with Microsoft Excel! However sometimes pivot tables look messy because there are so many zero values. Here’s a quick tip to hide zero values in your pivot table so they don’t display. You’re welcome!! For more Microsoft 365 Tips and Shortcuts for Business, subscribe to my free eNewsletter here. or go to www.donnahanson.com.au/subscribe …
5 Must Know Excel Hacks
In business today we don’t have enough time to do all the things we want or need to get done, as a result we are always looking for hacks or shortcuts to fast track common tasks. Here are 5 of my favourite must know Excel hacks that are so simple you may be overlooking them and their ability to immediately improve your productivity and reduce your stress with Microsoft Excel. 1. Duplicating a Worksheet So many people copy and paste data from one excel worksheet to another only to find they lose column widths, along with any formatting such as …
Pivot Tables: Your Secret Weapon in Microsoft Excel
So many clients I work with want to know how to create complex formulas or functions to analyze large data sets in Microsoft Excel. Reality is, you don’t need to be a math genius to do this, you just need to understand a powerful tool in Microsoft Excel called Pivot Tables. When I mention pivot tables I often see eyes glaze over! Like macros, pivot tables can seem overwhelming and complex. However, when you understand what they do and Excel’s tools to make creating them EASY, enormous amounts of time can be released to do other tasks. The bonus is, …
How to Find a Previous Version of a Word Document.
Ever worked on a document only to realize that the previous version of it was much better? Most people think if you edit a document, it changes the document for good. Well it does, but if your document is saved to either OneDrive or a SharePoint library, Microsoft 365 enables you to access various versions of the document based on time and date autosave. This is a handy feature if you are working on a document but decided that you want to go back to a previous version to review it, or to simply go back to it to start …
5 Tips to Improve Your Efficiency with Microsoft Outlook
First of all, let me clarify what Microsoft Outlook is used for. Microsoft Outlook is a software tool that enables emails to be sent and received, management of calendar and contacts as well as creation and management of tasks or things to be done. Given the sheer volume of email we receive on a daily basis in business, as a productivity speaker, trainer and course creator, I am regularly asked how to effectively plan your day so you get stuff done and don’t end up wasting your time dealing with other people’s problems or issues…..unless of course, that IS your …
