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 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 >>
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 >>
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 >>
When I started rusinfomos.ru, I never really gave much thought to Excel's broader web community, which I was implicitly joining.  At the time, I was really just posting Excel tips and tricks because I thought they were interesting and would be useful to fellow MBA students.  While my engagement and capacity to contribute to ... Continue Reading >>
Learning the VLOOKUP formula is, for most people, the first step taken towards becoming an advanced Excel user.  For me, this milestone actually occurred in 2004 during an internship at Microsoft in the company's Commercial Operations Division.  One of the senior analysts showed me the ropes by teaching me the formula.  While Continue Reading >>
OFFSET MATCH MATCH is the final lookup combination I'll cover among the lookup formula options you have available to you in Excel.  Of all the different lookup options you have to do a two-way lookup, INDEX MATCH MATCH is still probably your best bet and the approach I would generally recommend.  However, OFFSET MATCH MATCH ... Continue Reading >>
VLOOKUP and HLOOKUP are two of the most popular formulas in Excel and using them together is one of the first formula combinations that people learn.  While using INDEX MATCH for vertical lookups and INDEX MATCH MATCH for matrix style lookups are superior approaches, it's still a good idea to learn this formula combination and 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 >>
I generally give Excel a lot of credit for being an intuitive and easy to learn tool.  However, writing criteria statements that link to cells is probably one of the most un-intuitive aspects of formula writing in Excel.  This is a very common mistake that occurs and therefore, should always be error-checked whenever you are ... Continue Reading >>

Related pages

online random name pickerhow do you put a tick in a word documentline graphs in excellookup from pivot tableexcel vba cell referenceapproximate symbol in excelpre mba consulting internshipvlookup in excel step by stepexcel horizontal lookupvba else without ifexcel financial templatesexcel vloopexcel pivotingsymbol of tick mark in wordhlookup excel 2013how to delete specific rows in excelmaking histogram in excelexcel formula to check for duplicatescompare duplicates in excelhow to use iserror in excelcharts in excel 2013stacked bar graphs excellabour histogramhow to use excel to compare two lists of datacomplicated excel spreadsheet examplesshortcut in excelexcel userform examples downloadcompare to columns in excelw-4 worksheet calculatorinsert check mark in powerpointhistogram charthlookupsexcel deduplicationhow to perform vlookup in excel 2007excel logic formulasvlookup with match functionadd chart title excelexcel power query examplesvba offset selectiondelete duplicate row in excelremove na from vlookupvlookup based on 2 criteriahistograms excelfind duplicates in tableexcel create random numberslookup formula excelwebsite ranking alexavlookup comparevlookup and hlookup tutorial pdfhow to create a bar graph in excel 2013excel stacked bar graphforecast calculation in excelhow to remove in excel formulahow to create a lookup table in excelcool excel graphsucla gradesexcel bell curve charttick icon wordexcel cumulative chartshortcut for pivot table in excel 2010excel pivot count distinctdata labels excel 2010how to insert a tick in a word documentprobability excel formulaexcel random selection from listcompare two excel spreadsheets for matchesfind duplicates in excel spreadsheetthe goal process of ongoing improvementdata labels excelexcel vertical axisexcel password templatehow do you use vlookup in excel 2010excel custom format thousandsuse of vlookup in excel 2007 with exampleexcel formula unique valuespivot queryhow to use a vlookup function