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 nested vlookupucla mba recommendationexcel count duplicate valuesmultiply formula for excelexcel find duplicate values in columncountif conditionnested if in excel 2010how to construct a normal probability plot in excelucla mba employment reportsum columns in excelconverting adobe to excelhistogram excelexcel countif rangevba histogramword picker generatorucla ctoucla mba employment reportor symbol in excel formulacompare two columns in excel and find matchesdifference between filter and advanced filter in excelcombine vlookup and hlookuppaste special excel shortcutsequential number generator excelharvard business school cases solutionsexcel probability distribution functionexcel custom format codesiserror excelusing vlookup in vbaexcel conditional lookuppdf file convert to excel sheeta stacked column chartif statement examples in excellookup vlookupexcel tutorial examplessumit bansalcheck mark symbol microsoft wordtypes of bar charts in excelcount identical cells in excelhow to vlookup with multiple criteriavlookups excel 2010probability calculation in excelmaking charts and graphs in excelvlookup multiple rangesmacro example in excelinsert column in excel shortcutkinross gym uclaexcel paste value shortcutexcel create column chartcharts in excel 2013histagram excelexcel 2007 compare two columnsursa uclamicrosoft word 2010 free trial download full versionexcel histogram toolhow to use transpose in excel 2007random name selector for contestexcel formulas meanhistogram chartexcel lookup not workinglearning formulas in excelvlookup with if conditionhistograms on excel2d column chart excelwhat are nested if statementshow to identify duplicates in excelvlookup duplicatescool excel charts and graphsmatch formula in excel 2007vlookup maxexcel formula example sheetpdf file convert to excel sheet