Now I have been an Excel enthisiast and user for around 20 years now, but one of the most talked about features in Excel I have experienced is the VLOOKUP table. I recently changed over offices in my day job, and one of the first things someone said to me when they found out about my Excel exploits was ohhh so you know all about them VLOOKUPS and stuff. ... Love them or hate them they are awesome in their power of analysis from just a few clicks of the mouse! A book/video I have had in my … [Read more...]
Compare Two Excel Lists To Highlight Missing Items
by Barbara

A really common task used frequently in Excel is to compare two lists to highlight items that appear in one list but are not in the other. Here is a great way to combine two great Excel features to get exactly the results we need. We can combine the VLOOKUP function along with Conditional Formatting. The VLOOKUP will be used used to look up an item from one list in the other, and the Conditional formatting will highlight the missing items for us. In my example I have two lists of … [Read more...]
Why You Should Use MS Excel To Build Business Dashboards
by Barbara

Dashboard skills are in great demand by employers, if you can build great dashboards; it is a valuable skill to have. Even better if you can build them in one of the most widely used pieces of software- Microsoft Excel. Essentially dashboards are a technique of report used to visually present critical metrics or a data summary to enable quick and effective business decisions. This would be in the same way a car dashboard will display only the main pieces of data needed when driving your … [Read more...]
Quickie Tip: Shrink Your Cell Data
by Barbara

Here is another fab Excel tip. Excel is kind of clever as if you didn't already know. Excel will automatically fit your data to your cells by shrinking it. The data in the cell is fitted within your column width by the reduction of your font size- which then changes with the width of the columns. Yes clever! So, if you want to shrink your data into your Excel cells. Select a cell or a range of cells Home Tab Cells Group Format Format Cells OR select CTRL+1 for even quicker … [Read more...]