One Small Win can BOOST Your Productivity
Human nature is when we feel overwhelmed, we just want to resolve it. When overwhelmed with technology, clients and students want to try and get better at everything at once. However, that approach doesn’t relieve the pressure, it increases it. It is surprising simple to quickly reduce your stress. Identify the one program causing you the most grief, and start there. Is it your inbox constantly open and dragging your attention away. Perhaps it is editing Excel formulas and wondering if they are doing what they are supposed to. Maybe it is a Word document that you can’t quite get …
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 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 …
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 …
Make it easier to fix Microsoft Word Document with this simple tool
If you are with formatting issues in your Word documents it can be stressful and frustrating. However, using the Show/Hide tool in Microsoft Word 365 can help you troubleshoot and fix problems with ease! To show you just how helpful it can be, I put together a quick step-by-step tutorial, to guide you through using this handy feature to reveal hidden formatting marks like spaces, tabs, and paragraph breaks. Perfect for beginners and anyone looking to clean up their Word docs quickly. Check it out below Want more helpful business tips with Microsoft 365 programs? Subscribe to my free monthly …
Microsoft Word 365 – Populating Text
Don’t waste time typing repetitive data into your documents. Make it easy to populate data from one location to another with Bookmarks. Check out how easy it is in this video. For more Microsoft 365 Core Four (Word, Excel, PowerPoint & Outlook) tips, subscribe to my free monthly eNewsletter here or go to www.donnahanson.com.au/subscribe. …
