Advanced Excel: PivotTables and Pivot Charts
Would you like to save time and increase your productivity by 80%? The PivotTables tool is one of the most powerful yet intimidating features in Excel. Sadly, many otherwise experienced spreadsheet fans avoid them because they seem too complicated at first glance but the real problem is that PivotTables are rarely explained properly.
Excel PivotTables make it easy to summarise and aggregate data in Excel. Once you've mastered them, Excel does the work for you, easily analysing business data and creating management reports with a couple of clicks of the mouse, using drag and drop interactions, thereby saving you time and allowing you to be more productive.
The ability to use Pivot Charts and graphs to highlight data through conditional formatting using PivotTables also vastly improves the ability of the Excel user to communicate trends and management information effectively.
Excel PivotTables make it easy to summarise and aggregate data in Excel. Once you've mastered them, Excel does the work for you, easily analysing business data and creating management reports with a couple of clicks of the mouse, using drag and drop interactions, thereby saving you time and allowing you to be more productive.
The ability to use Pivot Charts and graphs to highlight data through conditional formatting using PivotTables also vastly improves the ability of the Excel user to communicate trends and management information effectively.
On this two-day course you'll discover that PivotTables are an easy and convenient way to build intelligent, flexible summary tables, allowing you to quickly derive insight from your data. Learn how to easily format and create powerful graphs to highlight PivotTables and create AMAZING dashboards!
Workshop Content
|
Unit Standards
SAQA US ID 116943: Use a Graphical User Interface (GUI)-Based spreadsheet application, enhance the functionality and apply graph / charts to a spreadsheet. NQF Level 4 3 Credits Duration
2 days Requirements
Good knowledge of Excel, preferably having completed Introduction to Excel and Intermediate Excel. Your own laptop with Excel 2007, 2010 or 2013. (If you do not have your own laptop, we can provide one for you to use for the course) Cost
R3 600 per person excluding VAT Price is for training in Gauteng. Price is for in-house training for 6 people or more. Assessment and Moderation R500 excluding VAT per person. Valid until 31 December 2017. We are happy to discuss all your training needs and work with you to meet your requirements. |