Do you want to learn how easy it is to create pivot tables in Excel? Would you like to learn how to use pivot tables for Job Costing? If so, then join Chuck Vigeant, M.Ed. (creator of QQube™ and founder of CLEARIFY℠) as he teaches you the simple components of working with pivot tables, while demonstrating that pivot tables are NOT hard to use. He will use several frequently requested, real world QuickBooks examples.
Chuck presented this webinar last week but there were some technical difficulties so it was not recorded. As a result, he has offered to do it again! There are two parts in the FREE webinar so you can attend the entire webinar or part of it (you only need to register once). There will be a small break in between around the top of the hour.
Sample Files for the Webinar
You may want to follow along using the sample Excel files Chuck will use during the webinar. You will need Excel on your computer and it is recommended that you have two monitors (or one large monitor) to be able to see the webinar and your Excel sample file at the same time. To get the sample files for the webinar:
- Register for the CLEARIFY community: http://community.clearify.com/spaces/18/learning-center
- Download the sample files here.
Introduction to Pivot Tables
The pivot table is the most underutilized data analysis and reporting tool, yet it comes free with the most widely used spreadsheet known to mankind – Excel. 
What you will learn:
- Advantages and disadvantages
- Requirements
- Two steps to create a pivot table
- Pivot table options
Using Pivot Tables for Job Costing
In minutes you can create reports for cost to complete, over/under, bonding – or analyze employee costs and overtime trends.
You will learn how to:
- Create a simple job cost report in less than 5 minutes
- Add calculations to a pivot table e.g. % complete, earned revenue
- Analyze job hours
- Filter jobs by project manager, job status, job end dates
Space is limited, register now!
- Tuesday, June 5 — 10:00 – 12:00 Central time
- See above for info on how to register and obtain the sample Excel files prior to the webinar.
This free webinar is a thank you to my subscribers, Linkedin group members and other followers. I appreciate you all! Thank you Chuck Vigeant for helping us learn about pivot tables!
Thanks for being willing to host these webinars. I just now finished the one on Pivot Tables with Chuck and when I first started using them it was the 2003 version of Excel and was very frustrating to use. 2007 and 2010 versions are so much easier to use. Once again, thank you so much for your assistance.
I won’t be able to make the webinar, but would love to be able to see the recording. Thanks Michelle for a fantastic group. I learn something new on a regular basis, and I’ve been using Quickbooks daily for 12+yrs.
Go ahead and register for the webinar so you’ll get the follow up email with a link to the recording. I’ll try to post the recordings on my website too — here: http://www.longforsuccess.com/resources/webinars
Will you send out a notice if the recording is a go? I have been interested in a few webinars that you have posted but the timing does not work for me. I would greatly appreciate access to the recordings as well.
Chuck tried to record it last time but he had technical difficulties & had to log back in which messed up the recording. He’ll record this one (fingers crossed no tech problems this time) so you can listen to it at your convenience.
I only wish these webinars were scheduled later in the day for us West Coasters 🙂
Michelle,
I had registered for the last webinar you did for this subject and I thought I read somewhere that if you were unable to attend that it was being recorded and we could go back and watch the recorded version? I am unable to attend webinar’s during the day due to my employment. Is is possible to view this on my own time?