Sometimes data is perfectly shaped and structured — other times, it’s not. If you’ve used pivot tables, you’ll be familiar with the cross-tabular format, which summarises data based on two or more categorical variables. While this layout is great for…
In Excel, it’s common practice to store percentage values as numbers under the General number format; for example, 12, 6, and 16. By only including the percent symbol (%) in a column’s header, you can avoid repetition and extra clutter….
As a rule of thumb, referencing a whole column in Excel isn’t considered good practice. It’s better to include only the cells you need in a range. And it’s even better to use tables so you’re working with structured references….
Those familiar with Google Sheets will be aware of the helpful little box that pops up when you type a function followed by an open parenthesis. It reveals the function’s syntax, an example, and a description for each argument. Moreover,…
There’s a brand new keyboard shortcut in Excel. You can now launch the Power Query Editor by pressing Alt + F12 instead of going to Data > Get Data > Launch Power Query Editor. A small but welcome addition.
Have a look at Value A and Value B on page 1. They’re the same, right? “They are definitely the same.” Nope, they’re not. “Okay, I’m guessing there’s an extra space at the end of one of them then.” You’re…
End of content
End of content
