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 …
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 …
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 …
How to easily separate a single worksheet in Excel to email.
Don’t laugh, but I’ve worked with a client where they want to send a single worksheet in a file to a colleague. They would do a “Save As” and delete what they didn’t want their colleague to see. Whilst it does the trick, it’s not the most efficient or effective way to do it. In this video I share how to separate a SINGLE worksheet from an Excel file so you can easily send just that one worksheet to someone rather than ALL the data in the file. Take a look…. Like this tip? Get more by signing up for …
How to save time and frustration with Microsoft Word tables
If you’ve ever inserted a table only to find you waste ages trying to resize the column widths, get the exact size you need or get the headings onto the next page? It can be so frustrating right? When I present at a conference or internal workshop, 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 Microsoft Word easier. If …
How to automatically insert text in multiple parts of a Word document
As a corporate workplace trainer, I am often asked how to insert the same text in multiple parts of a document. So often we create a document inserting a piece of text, only to find we have to type it in again somewhere else. Wouldn’t it be so much easier if you typed it in in ONE place and it automatically populated elsewhere??? Watch this video to see how. Like this tip? Take a look at my short course on How to Create Professional Documents in Microsoft Word. Click here for more information. …
Lead by example
Human nature is to replicate the behaviours of those we are closest to. If you turn up to meetings late, others assume it is acceptable and they will replicate that behaviour. The best way to get increase the personal productivity of others, regardless of whether they report to you or not, is to lead by example. If you demonstrate you are productive by delivering on your promises and putting your hand up when something goes wrong, others around you are more likely to do the same. Being productive as a leader or a team member requires courage to commit to …
Do you budget your time as well as you do your money?
Regardless of who you are, we only have 24 hours each day. Leading productively means budgeting your time as you would your money. So much time can be lost on activities that add little value. You can reclaim time by asking yourself “Is this the most productive use of my time?” If the answer is NO, then communicate quickly and if necessary provide a bit more detail. Let others know you can’t attend that meeting because you have a client deadline at the end of the day, or you can’t complete a task within the desired timeframe, but you can …
