How to put text from one part of a Microsoft Word 365 document into another automatically.
So often we have documents that have text such as a client, customer, student or patient name that needs to be placed in several areas of a document. Rather than retyping the data in each location and risk missing one, watch this step by step video I created that involves setting up bookmarks to mark the specific text and then cross references to insert the bookmarked text into the relevant places in your document. PS The video also shows you how to update cross references to keep the document up to date! Check it out here Want more help with …
How to easily insert one document into another in Microsoft Word 365
When combining multiple documents from various sources into one document, so many people do it the long way via copy and paste. Not only is this clunky and cumbersome, it is also frustrating and time consuming…. especially if you are interrupted part way through and need to go back to check on which documents you have combined, and which need to be added! To make it easy I put together a quick little video (just over 2 minutes) to show you how to easily insert one or even more documents into another in Microsoft Word 365. But of course, everything …
What’s the difference between Microsoft’s Outlook app and Outlook 365?
With the introduction of Microsoft 365, Microsoft programs can be accessed in multiple ways. The most common ways to access Outlook and email are via the desktop, or via the web app, however Outlook can also be accessed via a mobile app. Firstly, some definitions. App – an app is the abbreviated term for application or program. Microsoft 365 – covers the range of Microsoft programs available as part of what is a Microsoft Office program subscription which is paid on an annual or monthly basis. It covers the core four programs Microsoft Excel, Word, PowerPoint and Outlook plus additional …
How to summarize your sales data by staff member
If you have a list of sales data that you want to analyze by staff member here’s how to make it easy. This may be a list of sales data you have downloaded from another system or could be a list that has been created in Excel and added to. Note: If this isn’t downloaded data, before you start, make sure you create a duplicate of the data just in case you need it. Do this by copying the worksheet or creating a duplicate of the file. First, Open Microsoft Excel 365. Step 1 – Before you start, make sure …
Need the Previous Version of a Word document?
Ever saved a Microsoft Word document and circulated it to colleagues only to get feedback that the previous version was better, or perhaps you need to get a paragraph or two from the previous version to add back into the updated document? I know as a former Executive Assistant, this has happened to me on more than one occasion! Don’t stress, I’ve got you covered! Did you know that Word 365 automatically saves versions of your document without you having to remember to save individual files? This is a life saver if you have a manager or colleagues who like …
Understanding the Basics of Microsoft Excel 365
New to Microsoft Excel and have no idea about terminology or the basics. This video is for you! Don’t be overwhelmed, bring yourself up to speed on the elements of Microsoft Excel and common language and terminology used in this simple and quick how to video. Understand WHY Excel treats the data you enter in certain ways. Want help getting productive with Microsoft’s Core Four (Word, Excel, PowerPoint & Outlook) programs? Subscribe to my free eNewsletter here or go to www.donnahanson.com.au/subscribe #excel #excelbeginners #excelbeginner #excelbasics #excelbasicstutorial …
What is Autocorrect & how to use it in Microsoft Word 365.
Ever typed in a word that you know you spelt wrong, such as beleive instead of believe and when you look back, the text has corrected itself? Well that’s Autocorrect, a feature of Microsoft Word 365 that could literally save you HOURS… Autocorrect corrects commonly misspelt words in documents. Words such as believe, days of the week, months of the year, capitalising first letters of sentences and many more. However did you know you can leverage this feature to save you having to type in repetitive details such as your own name, a departmental name that is long, or text …
Why you should delay sending your emails all the time!
I once sent an email to my husband to let him know what I had planned for dinner that night. I put dinner in the subject, typed his first name and pressed Enter, then send….. all good so far… About an hour later I received an email from someone named Paul, (which is my husband’s name) saying… “..I don’t think this is for me, but dinner sounds nice” ????????. Of course I was mortified!! But then I realised because emailing is soooo easy we often just send them off without checking some “fine” details. As a result, I now delay …
How to copy a PDF into Microsoft Excel
Retyping data from a PDF into a new Microsoft Excel worksheet? Nooooooo! Wouldn’t it be great if a PDF document you’ve been sent that has information in it that you need to work with could just be dropped straight into Excel? Well with a few steps you can save yourself heaps of time, stress and frustration. I put together a quick video (around 1 min and 47 seconds) to show you how. Check it out below If you liked this, why not subscribe to my free monthly Productivity Pointer. A Microsoft 365 Business tip trick or shortcut delivered to your …
How to hide zero values in a Microsoft Excel 365 Pivot Table
Creating and working with pivot tables can be challenging at the best of times, let alone if your pivot table contains messy zero values. In this quick video I show you how to easily hide the zero values in your pivot table to make them look “cleaner”. Check it out Got no idea what a pivot table is? I got you… check out this video on how to use Microsoft Excel Pivot Tables. Want help with Microsoft 365 programs? Subscribe to my free monthly Productivity Pointer here or sign up at www.donnahanson.com.au/subscribe …