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

cumulative bar chartexcel delete doubleshow to add a chart title in excelexcel generate random passwordusing countif function in excelexcel functions tutorial with examplesvlookup vlookupvlookup on excelexcel sample meantask tracking template excelremove duplicates in a listexcel beginners tutorial pdfshuffle numbers in excelvlookup is not workingremove duplicates from two columns in excelexcel vloopuphow to delete duplicate items in excelexcel macro templateshow to insert symbol in excelmicrosoft word insert check markhow to use the vlookup function in excel 2013find duplicates in excel 2013random number generator no repeats excelwhat is hlookup in excelhow to copy formatting in excelexcel formatirs tax liability calculatorpopular excel formulasvlookup duplicatevlookup and hlookup togetherexcel probability functionsms excel array formulamicrosoft excel graph templateshow to use a vlookuphlookup excel 2010remove duplicate from exceltick windingssort ascending in excelvlookup processexcel compare 2 columns for differenceslookup functions exceltick yes symbolhow to convert excel file to pdfexcel vba function return arrayexcel shortcuts in excelhow to make column chart in excel 2010vlookup if isnamatch excel formulahow to label axis on excel graphisna meaningassignment trackerexcel graph ideasv lookup and h lookupmost complex excel spreadsheetnormal bell curve distributionmycareer ucla andersonthe goal goldratlook up function in excelwhat is the newest version of exceloffset excel vbacpk calculator excelhow to use the transpose functionexcel multiply matrixhbs consulting case bookhow to find the duplicate values in excelv look ups excelhow to learn formulas in excelvlookup formatexcel formula remove duplicatesexcel vloopupsample excel spreadsheet with formulasexcel remove duplicate recordstax calculator xlsucla academic probationhow to create a bar graph in excel 2013