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 >>
I’ve emphasized before that the key behind Visual Design is that every formatting decision you make should have a purpose behind it.  In the following post, I plan to demonstrate more of the visual style I use in Excel.  These formatting techniques still do have justifications behind them, but there are no hard and fast ... Continue Reading >>
Visual Design is a concept that many people don’t think about when using Excel.  However, given how much Excel’s visual display capabilities have improved over the years, the concept is becoming more and more important.  There are a number of great books on Visual Design and they all have very similar themes. The following Continue Reading >>
Pasting chart formats is an Excel function that’s somewhat un-intuitive to find and therefore underutilized.  One of the main reasons that people don’t bother improving the formatting of their charts is because of the time it takes to make these adjustments.  By using the paste format function for your charts, you can save Continue Reading >>
Because it’s buried deep in the cell formatting menu and has very little documentation, Excel’s custom number formatting is probably its most underutilized feature.  Understanding and mastering this feature can greatly enhance the Visual Design of your Excel workbooks.  The key benefit of custom number formatting Continue Reading >>
One of the most important skills in Visual Design is being able to improve the formatting of your Excel charts.  Even if your displaying the exact same data set, the formatting of a chart can make a huge difference in terms of effectively communicating your data. For any given chart, there is always some level of ... Continue Reading >>
For stacked bar charts, Excel 2010 allows you to add data labels only to the individual components of the stacked bar chart.  The basic chart function does not allow you to add a total data label that accounts for the sum of the individual components.  Fortunately, creating these labels manually is a fairly simply process. Step Continue Reading >>
The chart on the bottom is Excel’s default formatting while the chart on the top has been heavily updated.  Looking at both charts together, most people would agree that the chart on the top looks better.  The purpose of Visual Design is to explain why the first chart looks better and do so from a ... Continue Reading >>

How to Learn Excel

by Matthew Kuo on January 16, 2013

in Excel

The majority of people who are really good at Microsoft Excel will tell you that they gained their knowledge simply through experience.  When I was a management consulting analyst, I’d frequently be given tasks that I thought were impossible with a spreadsheet; the process of coming up with an Excel solution was what really Continue Reading >>

Related pages

normal distribution data generatorremove duplicate row in excelhow to change axis labels in excel 2010building a macro in exceltask management excel template freeexcel formulas to find duplicatesexcel headingsmacro open excel filegaussian distribution function excelhow to create a bell curve in excel 2007name picker classroomhow to add error bars in excel 2013how to write vlookup formulaaccounting excel formulasuses of macro in excelwhere is vlookup in exceldelete duplicate values in excelhow to learn excel spreadsheetsselect duplicate rowsshortcut for paste in excelmicrosoft word 2010 free trial downloadhlook up examplerandom formula generatormatching columns in excelvlookup hlookup pivot table tutorialexcel formulas hlookup examplevlookup match indexhow long is harvard mbaexcel find duplicatesexcell vlookupvlookup multiple matchespastespecial pasteremove formatting excelbar diagram in excelmicrosoft excel vlookup tutorialdelete duplicate data excelhlookup samplevlookups in excelexcel formulas countifchess lookuphomework assignment sheet templatenorm invexcel formula to count duplicatesexcel offset columnwhat vlookup in excelexcel data validation unique valueshow to use the vlookup function in excelshortcut for paste special valuesside by side bar graph excelexcel vlookup different workbookvlookup in excellexcel cheat sheet formulascell formatting in excelhow to combine column in excelusing vlookup and if function togetherexcel 2010 create histogramvlookup and hlookup in excel 2007vba histogramexcel tickspaste special shortcut keyhorizontal analysis excelif vlookup exampleexcel formula vlookupfuzzy search excelvlookup and hlookup tutorial pdfharvard case study templatecreate bell curve excelcreating excel templatespower query for excelexcel formulas tipscpk excel formulalearn ms excel formulavlookup refexcel comma separatortrend graph in excelmicrosoft power query for excel add inhighlight duplicate excel