excelpunks. Training – Consultancy – Solutions.

recent posts

about

Category: Functions

  • Excel’s Most Important Function.

    Functions 9: VLOOKUP Time to learn: 25 minutes You will find this perhaps the most powerful function within the Excel framework. Why? Because one of the most tedious tasks in data management is keeping track of it all. During the age of the dinosaurs, if you had 10 items to keep track of, that would be…

  • They will call you MASTER after this!

    Functions 8: SUMIF, COUNTIF & AVERAGEIF Time to learn: 30 minutes Do you need to get the breakdown of sums, averages or a count of your data?  Need to get them by SEPARATE CATEGORIES?  Needed it yesterday? This series of formulas has so many uses, it’s amazing. You’ll be able to get the sums, counts and…

  • Up your game with a Wildcard!

    Functions 10: Wildcard Time to learn: 10 minutes Ever wanted to find out something about your products just from their names?  Tired of counting stuff BY HAND?  God forbid. Ready to save yourself hundreds of hours doing manual work that can be better spent conceptualising and innovating? Let’s get it on! Let’s start with some…

  • Excel Voodoo with Functions: IF, AND & OR!

    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…

  • Pivot Tables!

    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.