by Nico Mellett | May 10, 2021 | post, Tutorial, YT Vid
In the video above, I demonstrate just how powerful keyboard shortcuts can be when using Microsoft Excel. I put the mouse aside and just fly through them one by one. If you’ve been meaning to learn a few new keyboard shortcuts but not sure where to start, then...
by Nico Mellett | Apr 16, 2021 | Excel Functions, post, Tutorial
The CHAR function returns a character specified by the code number from the character set for your computer. For example, CHAR(34) returns a double quotation mark (“) and CHAR(10) returns a line break. The full list can be accessed easily from within Excel by...
by Nico Mellett | Apr 8, 2021 | post, Tutorial
Problem How do I display double quotation marks in an Excel formula? Background Usually, the purpose of double quotes in an Excel formula is to indicate the beginning and end of a string of text. The characters themselves aren’t displayed....
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 Nico Mellett | Mar 15, 2021 | post, Tutorial
Summary Never again present a spreadsheet to your boss that is purely black and white. Change the formatting within cells by adding colours and changing the size of the text to make it more interesting to the reader. This tutorial will provide simple examples of what...