Author: excelpunks
-
Function: IF, AND & OR Want to know how to make your spreadsheet look like it’s a thinking being? Looking for a way to make your data talk back to you? The most interesting aspect about Excel is the ability to execute logical equations or FUNCTIONS. IF One of my favourite functions is the IF…
-
Number Formatting For those of you dealing with large sums of numbers – maybe in a currency that has a lot of zeros in them, here’s something that may help! Step 1: Let’s start with some data. What if we needed to format the numbers in a way that multiplies every number by 1,000? Step…
-
Hi everyone, I see there has been a lot of attention on pivot tables. Well, the page is ready! Have a look and have fun! Josh.
excelpunks. Training - Consultancy - Solutions. 