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 …
Excel Flash Fill: Save Time by Joining Data in Seconds
Introduction Ever found yourself having to manually combine data in Excel, use concatenate or to retype or manually combine cells with data in Microsoft Excel 365? If you have, then you will love this blog post on an Excel 365 feature called Flash Fill that makes it easier to complete and flash fill common tasks. Flash fill was first introduced in the 2013 version of Microsoft Excel 365 and is available in Excel 365. It is an amazing tool that detects patterns in the data you are entering into cells in your work sheet and offers the opportunity to fill …
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 …
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 …
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 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 …
How to Change the Color of a Worksheet Tab
Firstly, why should you change the colour of your worksheet tabs? Primarily, worksheet tab colors provide a visual cue that worksheets in an Excel file relate to each other, for example, team worksheets relating to a single department, data relating to a geographical location. Like anything in Excel, changing the color of a worksheet tab is easy when you know how. 1/ Right click on the worksheet tab you want to change the color of. 2/ Choose Tab Color 3/ Click the desired colour and the tab will change NOTE: To change multiple tabs to the same color at once, …
