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

class schedule uclaucla campus bookstoregoldratt goalremove duplicates in excel columna stacked column charthow to draw normal distribution curve in exceltable pivot excelcountif in rangesymbol microsoft excelhow to compare two columns in excel using vlookuphow to use hlookup functionexcel iferrorwhat is isna in exceliferror function in excel 2010excel delete rowexcel formula is blankmultiple vlookupcool excel graphsexcel tip and tricksgaussian random number generatorusing a lookup table in excelhow to find duplicates in excel 2013excel vba delete duplicate rowsinventory excel templatecreate histogram in excel 2013rumus index excelwingding for checkmarkchart gridlinesexcel 2010 vlookup functionhlook up exceldouble if statement excelexcel formula list with examples 2007excel remove duplicatesw-4 allowance calculatorcompare two columns in excel for matches using vlookupwhat is vlookupshow to divide in excel with decimalsexcel remove duplicates from two columnswhat is hlookup in excel used forhow to use countifsexcel shortcut for paste specialcharacter code tickexcel paste values shortcutexcel alt shortcutserror bars excel 2007random number vbaconsulting boutique firmsexcel sheet formulaexel bookexcel 2007 match functionnested if and statements in excel 2010excel how to identify duplicatesdrag dates in excelvlookup columnvlookup hlookup in excel2015 w 4 withholding calculatorexcel string comparemacro to remove duplicatesexcel 2003 lookupvba delete duplicate rowsexcel comparing two lists for matcheswrite down the 3 different formulae of ms-excelbootleg software downloadsexcel currency formathow to find difference between two columns in excelcolumn graph excelformula excel vlookupusing the countif function in excelmicrosoft access 2010 free trialcheck mark in windingsrand formula in excelquick keys in excel