Demo Mode
ICAEW
  • Login
  • Events
  • How to Book
  • Contact us
0
Basket

PivotTable refresher and Power Pivot

£990.00 + VAT
-
£1,370.00 + VAT
Available
All Locations
Academy - Insight, analytics and decision support
Jun
5
Mon
-
Dec
31
Mon
09:30
-
PM
16:30BST
Schedule Type Title: Every Day of the Week
Sessions: 259
Session Hours: 1942.50
Description
A one and a half day course to help you improve your knowledge of Pivot tables.
  • Overview
  • Course level
  • Pricing
  • In-house

Date and time

Location

Select a date in the drop-down menu above for details

Select a date in the drop-down menu above for details

Course overview

Forecasting is irrelevant unless you can accurately measure your current business performance. Learn how to use Excel and its related tools to effectively analyse your business.

Beginning with the advent of Power Pivot in Excel 2010, we now have database-like computational power on our desktops, where we can summarise multi-dimensional PivotTables.

This course shows you how you may create bespoke calculations, charts, dashboards and reports using two of Microsoft’s premier tools: Power Pivot and Power BI. It will demonstrate how to create more powerful PivotTable reports and dissect / display data to produce detailed information for business reporting and forecasting purposes. Power Pivot takes PivotTables to the next level and Power BI allows you to design rich and interactive analytical, interrogative tools that look like they have spent weeks in development.

During the course, you will develop a sophisticated case study exploiting many of the powerful tools and functionalities from scratch. Using hands-on examples throughout, you will learn how to convert mountains of data into key business information efficiently and present it to influence strategy.

Learning outcomes:

  • Refresher on manipulating Tables and PivotTables in Excel.
  • Understand how Power Pivot builds on the functionality in Excel’s native tools, such as PivotTables, Slicers and key multiple criteria functions.
  • Be able to import data from a variety of electronic sources and relate them quickly to deliver key information in minutes not weeks.
  • Learn how to write powerful formulae in Power Pivot's Data Analysis Expressions (DAX) language.
  • Convert your knowledge of Excel into powerful and intuitive dashboards by using Power BI to automate your reports.

Who should attend

Excel users, business analysts and financial / management accountants working with large amounts of data and wanting to prepare dashboards and reports more efficiently and effectively.

 

This is Part 2 of the Business intelligence series: We strongly recommend you attend part 1 first, unless you already have good experience of using Power Query

Business intelligence part 1: Power Query

 

Course enquiries 

  • +44 (0) 1908 248 159
  • academy@icaew.com

Related content

 Visit the ICAEW Academy of Professional Development homepage.
 View all our Insight, analytics and decision support courses.
 View upcoming CPD dates.
 Download the catalogue for our full range of courses.
 
 

Excel level:

This course is Basic to General level in our Spreadsheet Competency Framework.

 
 

Capability Framework 123

 

 

Rate Cost
Non-Member £1370.00 + VAT
Faculty/Communities/ICAEW Member £1027.50 + VAT

Our public course programme is deliberately structured to encourage delegates from different organisations to participate. However, if you have six or more delegates who require development in the same area, we are able to run a more cost-effective and much wider range of courses tailored specifically to your organisation.

These are ideal for organisations seeking hassle-free, flexible and cost-effective training delivered to multiple delegates at your location of choice. Whether we use our existing materials or develop new content for your business, our expertise lies in translating your requirements into a pragmatic, interactive training programme highly relevant to your people and organisation.

To discuss in-house training for your business please email Academy or call +44 (0)20 7920 8813.

Basket
Item(s) £0.00
Grand Total £0.00

Contact us

  • Helplines and support
  • How to make a complaint
  • International offices
  • UK offices

Events

  • All events
  • Continuing professional development (CPD) courses

Information services

  • Library
  • Guide to services
  • Company research
  • Historical resources
  • Library collection
  • Library search

Legal

  • ICAEW policies
  • Cookies
  • Privacy policy
  • Reproducing ICAEW content
  • Copyright notice and disclaimer
  • Data protection policy
  • ICAEW website links policy
  • +44 (0)1908 248 250
  • contactus@icaew.com
  • icaew_uk
© ICAEW 2017

This screen shows you the details for the selected product.

Click the "Add to Cart" button to add this product to your shopping cart. You can enter a quantity larger then 1 to add multiples of this product to your shopping cart.

If the product is full you will see a "Wait List" button. Click this button if you would like to be notified if/when capacity is added. If capacity is increased we will email you.  Upon receipt of the increased capacity notification, registration will be on a first-come, first-served basis.

If the product is not ready for purchase you will see a "Notify Me" button. You can click this button if you would like to be notified when this product is ready for purchase.

Some products can only be purchased through our partner. In this case you will see an "External Register" button. Click this button to purchase through our partner's website.

Powered by Configio Sandbox 1825 N Hutchinson Rd, Suite 300, Spokane Valley, WA 99206