ICP Training Information

While Excel gives you all the tools you need to create neat, informative reports out of huge lists of raw data, the actual work of writing formulas, cutting and pasting information, and organising your totals into a new table can be extremely tedious. Not to mention that this approach isn't very flexible and often requires you to start from scratch to build a new report from the same data. The PivotTables tool is one of the most powerful yet intimidating features in Excel. This hidden gem allows you to quickly summarise and analyse large amounts of data in lists and tables, independent of the original data layout in your spreadsheet and without writing a single formula or copying a single cell, by simply dragging and dropping columns to different rows, columns, or summary positions. 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. By attending our two one-day courses you'll discover that PivotTables are really just a convenient way to build intelligent, flexible summary tables, nothing more, and nothing less. Microsoft PowerPivot is a free add-in for Excel 2010 that will revolutionise the ability of businesses to access, process and handle large amounts of data. Learn how to load millions of rows of data, easily create relationships between tables and develop interactive dashboards with PivotTables and PivotCharts. Our one-day course will show you how PowerPivot provides the next level of reporting and analysis tools for the Excel user. Excel Power View is a powerful new business intelligence tool in Excel 2013 which allows you to explore, visualise and present your data in ways you never knew possible. Power View is an interactive data exploration, visualisation and presentation experience that improves decision making and gives you strong insight into your business.