Pivot Table and Reports

By elitecpas | November 23, 2014 | Comments Off on Pivot Table and Reports

Do you have the concept of Excel Pivot Tables but need help in creating reports? This video can help.

Read More

Simple in Six – How to enter Excel data just one time!

By elitecpas | February 27, 2013 | Comments Off on 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…

Read More

Simple in Six – Excel Tables

By elitecpas | February 13, 2013 | Comments Off on Simple in Six – Excel Tables
Excel Logo

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