excelpunks. Training – Consultancy – Solutions.

recent posts

about

Category: Aesthetics

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

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

  • Live it Large with Number Formatting!

    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…