by Linda | Mar 23, 2021 | Article, post, Tutorial
Microsoft’s own definition of a Pivot Table is “a powerful tool to calculate, summarize, and analyse data that lets you see comparisons, patterns, and trends in your data”. Whenever you have information in a tabular set of data (or list) in Excel, you can create a...
by Linda | Mar 23, 2021 | post, Tutorial
What is a Pivot Table? A Pivot Table is defined by Microsoft as “a powerful tool to calculate, summarize, and analyse data that lets you see comparisons, patterns, and trends in your data”. Whenever you have information in a tabular set of data (or list) in Microsoft...
by Linda | Aug 18, 2020 | post, Tutorial
This short series of videos is designed for the absolute Excel newbie, but if you’ve been using Excel for a while you might still learn something new along the way. I will focus heavily on shortcut keys and other ways to save you time. Today’s video is as basic as it...
by Linda | Aug 18, 2020 | post, Tutorial
In the first installment of the “ABC’s of Excel” mini-course, we briefly explained the different elements on the screen when you open up MS Excel. Today we take a pretty bland and boring piece of data and apply some formatting to it, to make it more...
by Linda | Aug 18, 2020 | post, Tutorial
I wish I could make a list called “150 mind-blowingly awesome Excel keyboard shortcuts” but then no-one would remember anything. So I cut the list down to 14. I’ve also found that people get excited when they learn one new keyboard shortcut, but feel overwhelmed as...