excelpunks. Training – Consultancy – Solutions.

recent posts

about

Category: Sample

  • Sample 3: Collating of Data Using a Pivot Table and Macro

    For My Driving Instructor Download: https://drive.google.com/file/d/0B1pEq2dN7H9AWi1qNHdBY2J1QVk/view?usp=sharing I came across an interesting situation with my driving instructor.  He was collating a list of all the lessons the instructors in his team had taught for the day and the result of the lesson, being a pass or fail. He was collating this data by hand and I…

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