Posts Tagged ‘simple in six’
Simple in Sixty – Excel Tables
Learn some of the benefits of Excel tables in sixty seconds!
Read MorePivot Table and Reports
Do you have the concept of Excel Pivot Tables but need help in creating reports? This video can help.
Read MoreSimple in Six – Using Excel Pivot Tables to analyze sales
Excel expert Tom Fragale shows you how to use Pivot Tables to analyze your sales.
Read MoreSimple 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…
Read MoreSimple in Sixty – Excel Tables
Learn some of the benefits of Excel tables in sixty seconds!
Read MoreSimple in Six – Excel Pivot Tables Part I
Learn to use Excel Pivot Tables Part I
Read MoreSimple 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…
Read MoreSimple 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.
Read More