In 2012, back when I was in business school, I created a spreadsheet-based task tracker to manage my various commitments.  Because I'm somewhat of a visual design nerd, I leveraged Excel as my platform of choice because of all the detailed conditional formatting options available. It's now been more than 4 years since I created Continue Reading >>
If you work in consulting or some other profession that requires you to analyze data, sooner or later, you'll need to build a histogram.  This is because the histograms is one of the most effective methods to visualize and understand a data set.  Averages, sums, and counts are calculations that only tell you part of ... Continue Reading >>
When writing a series of VLOOKUP formulas, one of the annoying things is having to see the "#N/A" error after Excel has determined a lookup value is not available.  While we don't want to show any values when they are truly unavailable, from a visual design perspective, it's sometimes better just to show a blank space ... Continue Reading >>
The IFERROR formula was designed to solve a common aesthetic problem that most of us have encountered when using Excel - when we know that there are errors in our data, but we'd prefer not to see Excel's standard error message notation.  Error messages usually consist of all caps lettering that is preceded with the "#" ... Continue Reading >>
Photo by adamr Taking over another person's Excel file always has the potential to become a difficult task.  While some people actually create documentation, consider a new user's point of view, and take the time to call out the mousetraps that you might encounter, most of the time, you'll be getting a straight file dump.  Therefore, Continue Reading >>
Checking for errors in your Excel files is always a pain.  It's generally a very manual process that takes a lot of time, with a certain level of ambiguity regarding your return on investment - you could spend hours checking for issues in your Excel file, find nothing wrong, and your only tangible benefit is ... Continue Reading >>
If you've ever gone online to research improving your Excel skills, you've undoubtedly come across a post or two listing all of Excel's keyboard shortcuts.  In the latest version of Excel, Microsoft has made it easier than ever to learn shortcuts, by assigning shortcuts to nearly every function and making the discovery of the Continue Reading >>
Five Ways to Find and Remove Duplicate Values in Excel For people who work with large data sets in Excel, or databases for that matter, one of the most common error checking tasks is the removal of duplicates values.  Some people refer to this process as de-duping.  The main reason this is necessary in data sets ... Continue Reading >>
Your resume is probably the most important document you will create during your two years in business school.  When I started my MBA, I actually thought my resume was in great shape.  But my initial review with a career counselor proved otherwise and made evident the time I needed to spend on this process. During fall ... Continue Reading >>
The following post is the third in a series of posts about Excel Model Building.  To review the previous posts on this topic, please click through the links below: Click here for Part 1 of this post, How to Build an Excel Model: Key Principles Click here for Part 2 of this post, How to Build an ... Continue Reading >>

Related pages

shortcut key for filter in excelmatching two lists in excelexcel vlookup countremoving duplicates in excel 2010column graph excelh look up in exceladding axis labels in excelvlookup example to compare two columnsexcel 2010 chart titleadobe acrobat download cnetexcel paste functionexcel vlookup maxvlookup vs hlookupexcel vba distinct valuescalculating a bell curveexcel bracket templatetick sign in excelexcel highlight duplicatescreate a lookup table in excelhistogram template excelrosenfeld library uclaexcel formula is blankexcel vlookup pdftranspose array in exceltick symbol in wingdingsexcel hlookup functionmultiple if then statements in excelbar graph maker excelhow to draw normal distribution curve in excel 2007vlookup & matchvlookup and if statementcombine vlookup and hlookupindex match with multiple criteriastacked bar chart excel 2010how to remove shading in excelalexa ranking websiteexcel accumulated sumexcel macro databasehow to filter duplicate values in excelucla business cardsexcel compare two lists and return differencestutorial vlookup excel 2010stacked bar charts in excelhow to write tick mark in excelexcel repeat formulascientific notation in excelcreating a matrix in excelvlookup using 2 criteriadedupe excelucla ursahow to enter a checkmark in excelexcel randbetween no duplicatesvlookup in tableshortcut for checkmark in excelanderson fembaerror bars excel 2007excel vlookup pdfexcel binning dataname picker for contestmicrosoft excel tick symbolhistogram excellremove duplicate values excelexcel lookup and replaceisna matchhow to use a vlookupfilter shortcut exceltick icon in worducla course listingexcel macro enabled worksheetexcel highlight duplicate rowsexcel duplicatestypes of bar charts in excelvlookupexcel