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

norminv excelhow to eliminate duplicates in exceldoes deloitte pay for mbabasic excel formulas with examplesexcel functions vlookuphow to use nested if function in excel 2010building macros in excelanderson ucla mbaexcel look up tablesvlookup and hlookup formulaexcel calendar generatorvlookup and if function togetherexcel histogram bin rangehow to create a lookup in excelvlookup match two columnsexcel advanced trickshow to calculate sales forecast in excelvlookup returns valuerandom formula excelisna formula in vlookupwriting excel formulasvlookup not working properlyucla anderson campusfunny excel formulashow to do countif in excelline graphs in exceloffset in excel 2007why does vlookup return 0excel lookup multiple columnszs case interviewexcel stacked bar chart examplelookup command in excelvlookup formula in excel 2007 in pdfbell curve template excelconditional statement in excelexcel tracking templateexcel macro unhide all sheetswhat is a vlookup tablehow to input a formula in excelvlookup simplevlookup for multiple valuestick symbol for wordexcel distribution plotexcel formulas usingif cell is not blank excelexcel 2010 hlookupcreate a bell curve in excel 2010array vlookupusing formulas in excelvlookup row numberhow to paste special in excelp&l analysis exampleexcel remove duplicate datacount if excelnested functions excelmicrosoft office excel free triallogon.ucla.eduexcel if cell equals thencompare two columns in excel 2010how to use true or false formula in excelpartial match in excelnested if else in excelconvert excel spreadsheet to pdfrandom name picker downloadhighlighting duplicates in excelvlookup excel example multiple sheetshlookup dan vlookupexcel formulas with exampleexcel vba syntax guideexcel cell reference definitioncheckmark shortcut