Real Excel power users know these 11 tricks

Real Excel Power Users Know These 11 Tricks

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 […]

Read More
How to create relational databases in Excel 2013

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 […]

Read More
10 Top Excel Keyboard Shortcuts

The 10 most useful Excel keyboard shortcuts

The 10 most useful Excel keyboard shortcuts Why complicate your spreadsheet life with a bunch of tricks you’ll never use? These 10 shortcuts will expedite the Excel tasks you perform every day. It’s great to know the resources are out there. But on a practical level, mastering 10 genuinely useful shortcuts will get you a […]

Read More
Summarize Pivot Data by Average or some other formula

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 […]

Read More