Posts Tagged ‘excel’
Simple in Sixty – Excel Tables
Learn some of the benefits of Excel tables in sixty seconds!
Read MoreExcel – what to do when the numbers don’t line up
Can’t make the numbers align on your report? This will help.
Read MoreTax Free Yield calculator
Find the difference between before and after tax yields with our interactive spreadsheet!
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 MoreHow to use Facebook for Business
Most of us spend some amount of time on Facebook. Did you ever wish that you could better use your Facebook “friends” to grow your business? Wouldn’t it be great if there was a way to make someone your business friend without exposing all your personal posts? Look no further. Guest author and Excel expert…
Read More