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 no problem, but due to the scale at which the world is now used to, a relatively small piece of data would be thousands, if not hundreds of thousands of items long. VLOOKUP effectively and efficiently cross-checks and compares lists in seconds. So, let’s get our hands around this and choke it. VLOOKUP The VLOOKUP function is essentially a function that COMPARES LISTS. So, it would look at one list of items and tell you if another list you have contains the same items. If you had a list of all the items in your store and a client asked you if you could supply

read more Excel’s Most Important Function.

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. Here is a list of suspects in a database.  All of them have a name and a ‘Status’, whether they are ‘Wanted’, ‘Acquitted’ or ‘Missing’.  They also have a column next to their ‘Status’, indicating the ‘Action’ to be taken if they are seen – to ‘Apprehend’, ‘Issue Warning’ or just to ‘Inform Police’. Step 2: Let’s create a dropdown list of all the suspects in our list. Go to ‘Data’ tab and select ‘Data Validation’.  Select ‘Data Validation’ again. Step 3: An option box will appear with the title ‘ Data Validation’. Under the field ‘Allow:’, select the option ‘List’ and click ‘OK’. Step

read more Be THE MAN in your company with an interactive database!

Be an Excel star and own it like a boss!

Welcome to ExcelPunks! Ever since Uncle Bill dreamed of putting a computer in every home, his company’s programs have become as much a part of our lives as well…computers. Excel isn’t new to any of us, but haven’t you wondered if it could be used as more than just a piece of digital paper? Ever wondered if Excel could start working FOR you?  Making YOUR life easier?  Allowing you to spend more time developing your staff or talking to your kids, or maybe spending an extra hour with a loved one who doesn’t have much time? I know, we don’t normally think about things like that, but that’s the truth of how some of us see work.  We place work above our own lives and before we know it, life is over.  There must be a better way, shouldn’t there? Someone taught ME once and I’d like to pay that forward in my own little way. By teaching others how to use Excel to

read more Be an Excel star and own it like a boss!