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 “Flip” or Transpose Data in Microsoft Excel
Have you ever typed data into an Excel worksheet only to realise that rather than going across the sheet you should have gone down or vica versa? It’s easy to do, we are under so much time pressure to get things done. Rather than have to retype your data, Excel has a feature that enables you to quickly and easily flip or transpose your data to save you having to retype it! Watch this video to see how easy it is! If you found this tip useful why not subscribe to my YouTube channel by clicking the subscribe button below. …
