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 …
Want to be More Productive? You Don’t Need an All Day Course… Here’s why…
People often think that to become more “productive” they need to enrol in a full day training course, usually at an intermediate or advanced level because they’ve been using Excel for a few years. This generally means blocking a day out in their calendar and preparing themselves for information overload! But the truth I wish more people understood is that: It’s not full day training you need. You need a few better tips. Having been a trainer who delivered full day training programs, I know all too well how much attending a full day training session actually increased rather than …
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 …
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 …
