Learn some of the benefits of Excel tables in sixty seconds!
Posts tagged "simple in six"
Simple in Sixty – Excel Tables:
Pivot Table and Reports
Do you have the concept of Excel Pivot Tables but need help in creating reports? This video can help.
Simple in Six – Using Excel Pivot Tables to analyze sales
Excel expert Tom Fragale shows you how to use Pivot Tables to analyze your sales.
Simple in Six – Make your Pivot Tables do more
As useful as Excel Pivot Tables can be (see this post on creating pivot tables), sometimes you need to perform calculations on the data that’s inside the table. The normal Excel functions don’t work well for this, but our friend Tom Fragale show us how to force specific calculations on the data inside the Pivot…
Simple in Six – How to enter Excel data just one time!
Do you ever get frustrated formatting a yearly spreadsheet and then entering data in 12 tabs for monthly projections, budgets,etc? What’s really irritating is when something has to be added and you’re faced with 12 tabs to update. Thanks to Excel expert Tom Fragale (@PhillyTom), we have a way to enter your data just once…
Simple in Six – Excel Tables
Arguably, one of the most powerful features in Excel 2007 & 2010 is the new table formatting option. You can learn the basics in less than 5 minutes with the tutorial below.