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

lookup from pivot tablecountifs formula in excelnested vlookup in if statementpaste shortcut excelto compare two columns in excelsumproduct index matchexcel change separatorhow to delete duplicates in excel 2010excel comparing two lists for matcheshow to create a stacked bar graph in excel 2010create a bell curve in excel 2010random draw in excelvlookup excel easy stepswww ursa ucla edutick symbol in ms wordtask tracker xlstwo if statements in one cell excelhow to graph multiple lines in excelfind duplicate values excelusing if function with vlookupdelete row based on cell value vbahlookup formula in excel 2010excel simulation examplesdecision tree excel templateexcel macro applicationhow to construct a normal probability plot in excelcheckbox symbol in excelpurpose of vlookupusing vlookup and if function togetherhow to construct histogram in excelvlookup function in excel exampleexcel fx functionsum columns excelexcel 2007 index functionhomework agenda sheetswhere to find the tick symbol in exceliserror vlookupucla salary scalecountif formulassumproduct vlookupexcel divide cellbin range for histogramwhat is a vlookup functionhlookoffset function in vbavlookup and hlookup in excel 2007vba excel formulasdifference between lookup and vlookuphow to write formulas in excellabeling axis on excelexcel formula for blank celltracking sheet excel templateexcel detect duplicateshow to add error bars in excel 2013vlookup with matchremove duplicate cells excelline graph excel 2010excel formula namesgoals excel templateexcel exclamation pointcountif greater than or equal tovlookup in excel exampleswhat is a boutique consulting firmremove duplicate values in excel 2010where to find the tick symbol in excelexcel planner templateestimating excel templatevlookup index match excelnormally distributed random numbersvlookup multiple conditionsvlookup in excel 2010 with examplemaking a line graph in excel 2013excel dgetdelete entire row vbahow to find duplicate entries in excel 2007tax excel spreadsheettax formula for excelhow to learn vlookup