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 >>
The following post is the third in a series of posts about Excel Model Building.  To review the previous posts on this topic, please click through the links below: Click here for Part 1 of this post, How to Build an Excel Model: Key Principles Click here for Part 2 of this post, How to Build an ... 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 >>

Related pages

histogram creator freeindex match vlookupvlookup with vbavlookup function with exampleexcel vlookup formula examplehow to get rid of na in vlookupmr excel powerpivotcount formula in excel with exampleformula for vlookup in excel 2007excel paste special values shortcutexcel 2010 column headersshow leading zeros in excelhow to use hlookup in excel with examplemicrosoft excel cheapexample of macro in excelexcel compare dates in two columnsexcel delete rowshow to highlight column in excelexcel identify duplicates in columndecimal placementsmyculaucla mba marketingucla summer parkingexcel array formulas examplesif not blank in excelhlookup definitionexcel distributionshow to find duplicate values in excelexcel if statement equalsexcel vlookup testplanner template excelsumproduct with vlookuphow to delete doubles in excelexcel formulas tutorial with examplescreating if statements in excelexcel data analysis histogramexcel programing tutorialvlookup tutorial for beginnershow to check if there are duplicates in excelinventory formulas excelhow to draw a straight line in excelhighlight column excelduplication in excelwww excel shortcut keysexcel estimating templateindividual error bars excellookup functions in excel 2010ms excel standard deviationexcel formulas to find duplicatesvlookup between sheetsclean up phone numbers in excelexcel vba clear autofiltertracking template exceldelete adjacent duplicatesprimo pdf portableif formula in excel 2007 with examplethe goal a process of ongoing improvement cliff notescreate a macro in excelin excel how can i find duplicateseliminate duplicates in excelhlookup and vlookupexcel cell format formulaexcel 2010 compare two columns for duplicatesexcel remove duplicates from columnexcel unique random number generatormultiple if statement in excelvlookup or hlookupexcel vlookup function examplevlookup with and functionexcel pivot shortcutinventory excel spreadsheetexcel bar chart multiple seriesexcel formula commandsremove duplicates excel 2007