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 >>
The following is a fairly quick tip within Excel Visual Design.  One of the things I like to put in tables is a checkmark symbol to indicate that something is complete.  In certain situations, it's more appealing than writing the word "Done" or "Complete."  There are multiple ways to do this and I'll cover them ... Continue Reading >>
The Anchored COUNTIF is one of my favorite Excel formula tricks.   Using this technique provides a number of unique benefits, which make the formula worthwhile to learn.  While not as common as some of the more popular lookup formulas out there, being able to write an Anchored COUNTIF is still a great tool that can ... Continue Reading >>
Overall Summary Being an Excel blogger, I've taken a number of Excel courses throughout my career.  As my proficiency increased, both my need and interest to take Excel courses began to diminish over time.  Therefore, when Rishabh Bhandari from Yoda Learning reached out to me to review an Excel course, I took it more from the Continue Reading >>
The following is a guest post from Rishabh Bhandari, co-founder of Yoda Learning, a site that helps working professionals become faster and better in Microsoft office suite using high-quality video tutorials.  Before founding Yoda Learning, Rishabh worked with an Education-focused Private Equity fund in Mumbai, Continue Reading >>
Auditing an Excel file with a ton of tabs is one of the least enjoyable experiences in Excel.  When I worked in consulting, it wasn't uncommon for me to receive a file from a client containing 50 more spreadsheet tabs.  And as an analyst, I had the unfortunate task of having to review all of ... Continue Reading >>
If you work in consulting or some other profession that requires you to analyze data, sooner or later, you'll need to build a histogram.  This is because the histograms is one of the most effective methods to visualize and understand a data set.  Averages, sums, and counts are calculations that only tell you part of ... Continue Reading >>
Whether you're building a model or trying to simulate a scenario within your analysis, at some point in your Excel career, you're going to need to use a randomized set of data.  If you need to create a purely random set of numbers, with no specific constraints or parameters, you can just use the RAND ... Continue Reading >>
If you're brand new to VLOOKUP or haven't used the formula in a while, the following quick reference guide is a great resource to have handy.  It's created by the folks at Microsoft, so you know it's legitimate. Reference Guide Summary The quick reference guide is in PDF format and is three pages long.  It goes into ... Continue Reading >>
The vast majority of Excel users have never used VLOOKUP's range lookup feature.  Most Excel users familiar with the VLOOKUP formula are just conditioned to know that, when they get to the range lookup option portion of the VLOOKUP syntax, they should just put in the word "FALSE" because they want an exact match.  This ... Continue Reading >>

Related pages

multiple if statements in excelhow to label a graph on excelhow to shade on excelexcel formula lookupexcel graph legendhow do i insert a checkmark in excelbar chart in excel 2010nested if functions in excel 2010how to make a percentage bar graph in excelhow to find duplicates in multiple excel sheetsexcel overlapping bar charthow to make hlookup in excelexcel vlookup functionsucla store discountif na vlookupcheap microsoft licenseshow to conditional format in excel 2010excel insert row with formulatick symbol codehow to insert a tick symbol in wordline graphs in excelgaussian fit excelhlookup in excel 2010 with exampleexcel 2007 vlookupucla bruin storetroubleshooting vlookupsyntax for vlookuphow to check duplicate records in excelwhat is the newest version of excelexcel file convert to pdfvlookup code in vbahow to delete a cell in excelvlookup 2 columnsexcel how to delete duplicate rowsexcel how to delete duplicate rowsvlookup across multiple columnsexcel formula unique counttax excel templateexcel remove duplicate rowexcel formula arrayhow do i insert a tick in wordstandard deviation of a bell curveremove header excelvlookup named rangemultiple ifs in excelms excel countifcompare column in excel for differencesexcel match function not workingcumulative graph excellookup vlookupvlookup basicsgraph probability distribution excelhow to subtract multiple numbers in excelexcel 2013 indirect functioniserror with vlookupvlookup simplifiedp&l excelvlookup based on two conditionsexcel gaussian distributionvlookup excel example multiple sheetsmacro to find duplicates in excelwebsite with most trafficvlookup in excel step by stepwhat is a stacked bar chartgoals excel templatehow to insert data bars in excelhow to build an excel spreadsheetpdf vlookup in excel with examplebeautiful graphs in excelinventory in excel sheetwingdings 2excel find duplicate values in columnhow can use vlookup in excelsearch duplicates in exceldraw bar graph in excelbin lookup databasegenerate lotto numbers in excelremove dupes in excelhistogram chart in excelexcel remove duplicates