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 …
