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

ucla anderson gmathow to do a vlookup for dummiesremove excel duplicatesexcel probability distribution functionusing index and match in excelhow to make a vlookupcustom number formatting in excelexcel custom format codesif not blank in excelirs underpayment penalty calculatorbc reverse lookupexcel advanced formulas cheat sheetbell curve standard deviationswww transportation ucla eduexel shortcutscheck mark for wordarrays excelmatch rows in exceleasy excel shortcutsfree trial microsoft access 2010bin histogram excelexample for vlookupuseful excel shortcutscreating histograms in excelcount unique values in a pivot tablewhere do i find a tick in excelexcel formula previous cell plus 1the most popular websiteexcel match offsetmultiple if formula in excelisna function excelexel histogramparking structure 32 uclaexcel nested if statement examplesexcel compare 2 lists for duplicatestask tracker excelmultiple rows in pivot tableaaa jerseysunderstanding formulas in excelwriting excel macrohow to build excel macrosnormal probability plot generator onlinecompare 2 columns in excel using vlookuphistogram excel binstacked bar charts exceldownloading microsoft excel 2007 for freev lookup and h lookuptranspose formula in excelmatch function excel 2013excel 2007 vlookup tutorialhow do i create a lookup table in excelcreate vlookupexcel formula for columnscenario modelling excelcurving grades formulavba offset valuems excel hlookupgraph a circle in excelwebmail uclavlookup all matchesexcel fuzzy matchingucla grading systemtick mark powerpointhow do you handle ambiguity interview questionwhat is a hlookuppivot table queryissue tracking excel templatevlookup explained in simple termshow to convert excel file to pdfucla gpa scaleformulas in excel not workingpivot a table in exceldeduping in excelhow to eliminate duplicate records in excelexcel double lookupformula of vlookup and hlookupinsert column excellabel columns in excelhow to create vlookup in excel 2007what is isna in excel