There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical formula and macro tricks. You, obviously, are one of the latter—or are you? Check our list of 11 essential Excel skills to prove it—or discreetly pick […]
Articles Tagged: Pivot Tables
How to create relational databases in Excel 2013
Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up. Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated […]
Summarize Pivot Data by “Average” or some other formula
Summarize Pivot Data by “Average” or some other formula By default excel summarizes pivot data by “sum” or “count” depending on data type. But often you may want to change this to say “average”, to answer questions like “what is the average sales per product”. To do this, 1) Right click on pivot table values […]