excelpunks. Training – Consultancy – Solutions.

recent posts

about

Author: excelpunks

  • Make your spreadsheet look like a MILLION BUCKS!

    Aesthetics 1: Data Validation Time to learn: 10 minutes Want to make your spreadsheet look ultra-professional and have people asking you for weeks how you did it? You are going to love this. Data Validation is a sweet term for dropdown lists, which we are going to be creating today! So, let’s start with some data…

  • Make your data sexy!

    Data Processing 3: Charts Time to learn: 20 minutes Put an awesome look on your data and make great looking charts in minutes! Charts are easy. Let’s start with some data.  Here we have a list of caps in different colours and how many have been sold in January, February and March. Now, you see…

  • Transfer data, formulas, formats or even perform mathematical operations in a flash!

    Basics 5: Paste Special Time to learn: 20 minutes The Paste Special function allows you to easily transfer data, formulas, formats or even perform mathematical operations just by using good old copy and paste! This aspect of Excel seldom gets much attention as most do not understand how it works.  That is going to change…

  • 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…

  • Be a ONE MAN ARMY in your company!

    Automation 1: Mail Merge Time to learn: 20 minutes Need to send out a standardised form to dozens of your customers?  Hundreds?  Thousands?  Feeling the cramp in your fingers from typing out the same form over and over?  Even good old copy and paste ain’t enough? From the interconnectivity of Microsoft’s Word and Excel comes…

  • 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…

  • Be THE MAN in your company with an interactive database!

    Sample 2: Interactive Database We all work with data – tonnes of it.  Ever wanted to find all the information you need, with just 1 click of the mouse? Let’s build an INTERACTIVE DATABASE. Time to learn: 30 minutes Functions you will need: Data Validation Vlookup Conditional Formatting Step 1: Let’s start with some data.…

  • Stun Everyone at Work with Conditional Formatting!

    Aesthetics 3: Conditional Formatting Ever wish you could tell at a glance who your top performers are? Now you can! Conditional formatting is an exciting aspect of Excel that allows you to change the way your spreadsheet LOOKS, based on the DATA entered. Let’s have a look by starting with some data: Here we have…

  • Magic to make the boss’ jaw drop with Pivot Tables!

    Data Processing 2: Pivot Tables Time to learn: 20 minutes Have tonnes of data that you can’t make sense of?  Need a fast way to organise and view your 10,000 cell spreadsheet?  Then, pull that rabbit out of your hat with pivot tables! A pivot table compiles and summarises all the information in a spreadsheet into…