Learn some of the benefits of Excel tables in sixty seconds!
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…excel, Fragale, pivot tables, simple in six
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…excel, Microsoft Excel, simple, simple in six, spreadsheet, video