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.
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 them (around the top of the hour).
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.
- Advantages and disadvantages
- 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!
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!