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

w 4 allowance calculatorhow to find out duplicate records in excelcheck mark symbol microsoft wordcustom number formats in excelarray calculation excelgenerating random numbers in excelms excel offsetcool excel templateshow to locate duplicates in exceldelete repeated rows in excelremove conditional formattingfind unique records in excelhow to do bell curve in excelexcel list of values from another sheetidentify duplicate rows in exceldownload free trial of microsoft office 2010mba checklistchart labels excelchart gridlinesdownloadable w4what is the use of vlookup function in excelcell location lookupvlookup how to useexcel norminvvlookup similarcreate histogram excelmatch formula in excel 2007what is tax liabilities on w4random formula in excelhlookup excel 2007excel formula if a cell containsexcel custom chartshow to draw line chart in excel 2010excel vlookup arrayhow to find duplicates in excel sheethow to stack graphs in excelindex and match multiple criteriams excel formula cheat sheetbin lookup databasehow to drag down a formula in excelexcel compare rowsfancy excel templatescumbersome tabexcel combine tablesremove duplicate entries in excel 2010excel macro templateshow to find duplicate entries in excel 2007excel duplicate countcomparing two columns in excelformula excel sheetsheet formula excelexcel if statement with multiple conditionsvlookup comparew 4 worksheet calculatorvlookup excel tableexcel array lookupsample spreadsheetsexcel consolidate duplicateshow to check for duplicates in excelcreate macros in excelzs associates vaulthow to delete columns in excelvlookup range of valuesvlookup range of valueshlookupschess lookupexcel histogram bin rangeexcel graph generatorms excel histogramhow to use hlookup formula in exceltips for excel formulashow to use hlookup and vlookup togetherhow to make column graph in excelexcel lookup table examplevlookup in excel formulacolumn graphs in excelhow to randomize in excelrange of cells in excel formula