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 >>
Excel's MATCH formula is an extremely useful yet underutilized function within Excel's toolkit of formulas.  The reason people underestimate its value is because the MATCH formula's primary objective is fuzzy and ambiguous.  Without the proper context, its usefulness and potential applications are not obvious. The MATCH 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 >>
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 >>
The Goal: A Process of Ongoing Improvement, by Eliyahu M. Goldratt, is a book pretty much every business school student is required to read.  Below are the key takeaways from this book: Accounting vs. Operational Measures Accounting cost figures misleading for operations purposes Productivity per machine is meaningless; Continue Reading >>

Related pages

excel substitute examplefilter unique records exceldifference between lookup and vlookupformulas for excel 2007charting excelcheat sheet for excel formulaschecking duplicates in excelusing vlookup excel 2010combine two lists in excelautomatic row numbering in excelfree 60 day trial microsoft office 2013how to put error bars in excel 2007insert tick symbol in excelthe goal eliyahuucla mba gmat scorehlookup excel 2010 exampleexcel bell curveoffset vlookupzs associates employee benefitsucla schedule classescustom number format in excelexcel nested if statement examplesvlookup using 2 criteriavlookup duplicate valuescompare cells in excelexcel reverse vlookupexcel stacked barexcel remove non duplicatescommon excel formulasxcel shortcutsformatting excel chartswhat is countif in excelexcel macro worksheetcumulative chart in excelhow to do multiple if statements in excelduplicate rows excelfind duplicate values exceltrue false formula in excelwebdings keypasting in excelexcel formula matchrandom chart generatorhow to make a 100 stacked bar chart in excelhow to do if statements in excelmicrosoft excel iferrorusing arrays in excelrandomize list excelvlookup reversevlookup celladvanced excel tricks pdfhow to nest if functionsms excel lookupgraph template makerexcel formulas valuevlookup in exelvlookup function for dummiestracking sheet excelrandom number sequence generator excelgoogle spreadsheet tick boxbuy excel templateshow to select multiple rows in excelmicrosoft excel adding columnsvlookup with if conditionif function excel multiple conditionscountif function in excel examplemba checklisthow to build a forecast model in excelthe goal movie goldratt freeexcel tutorial booksnested if functions in excel 2010how to make vlookuphow to make a line graph on excel 2010break schedule template excelthe goal eliyahu goldratt movietable pivot excelhow to use comma separator in excelhow do i use vlookup