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

how to use match function in excelfilter shortcut excelvertical lookup in excelexcel match two columns of datacomplex graphs in excelcool excel tricksindex and match multiple criteriafilter formula in excelexcel financial model templatevba histogramhow to perform vlookup in excel 2007check mark symbol in word 2010excel tutorial for beginners pdfexcel duplicatesvba code to open excel fileexcel probability functionsestimate federal taxes owedtax formula in excelpdf printer primocreate duplicate rows in excelcount formula in excel with exampletranspose formula excelhow to drag formula in excelucla gmat rangeexcel formulas in pdf filedecision tree examples excelwebmail.ucla.edumatch formula excelestimate tax withholding calculatorbookstore near uclahow to delete duplicates in excel 2010how to vlookup in excel 2007 with examplehistogram chart makerexcel deduplicationcharacter code for check marksimple v lookupexcel 2010 conditional formatting datesmost popular webstiesvlookup explained simplyround to the nearest million in excelvlookup usesdefinition of vlookup in excelstacked bar chart excel 2007countif examplefree trial microsoft powerpoint 2010bell curve xlsexcel format millionshistogram normal distribution excelshortcut key for check markpricing excel templateexcel 2010 compare two listsexcel function vlookupexcel graph mean and standard deviationclustered column chart excel 2013hlookup excel 2010excel formatting codesshortcut for pivot table in excel 2010hlookup and vlookup togetherexcel match offsetexcel stack columnsgauss curve exceliserror in excelexcel chart gridlinesexcel hlookup exampletick icon in wordhlookup examplehow to make class intervals in excelhow to make line graph on excelmba interview preparationexcel formula max lengthexcel histogram graphdelete duplicates from excelvlookup with 2 criteriaexcel vlookup example downloadmba behavioral interview questions