SESCA Enterprises Ltd. - Professional Accountancy and Business Training
NEWS   COURSES   CONFERENCES
AND SEMINARS
  VENUES   SPEAKERS   FLEXITICKET   CPD   OTHER
SERVICES
  LINKS   CONTACT
US
 
EVENT DETAILS  
COURSE TITLE

MORE POWER TO YOUR PIVOT: PRACTICAL USES FOR EXCEL PIVOT TABLES

DATE Tuesday 21 March 2017
VENUE Mercure Maidstone, Great Danes Hotel
SPEAKER Simon Hurst
COURSE CODE MA21C7
COURSE FEE

£99+VAT. (Click here for information on the Flexiticket discount scheme - fees as low as £45.60+VAT per place) The courses ‘Good Spreadsheet Practice', '100 Ways to Make Excel Easier', ‘Practical Excel Techniques‘, 'More Power to your Pivot' and '50 Advanced Techniques for Creating Inspidational Spreadsheets', are available to IT Faculty members  for £60+VAT each.  For details of these other courses click here. Phone 01737 223999 for more details.

TIMING
Registration Course starts Coffee Course ends
09:00 09:30 11:00 12:30
OBJECTIVES

PivotTables are one of Excel's most powerful features but they seem to divide Excel users into fanatical advocates and those who just don't see the point. This course will explain how PivotTables can be useful to almost any Excel user. Starting with the basics of using a simple PivotTable to summarise financial data it will show how PivotTables can simplify a range of practical Excel tasks from identifying best selling products to consolidating branch data and acting as the engine for an automated performance dashboard.

Please note this is not a ‘hands-on’ course, but will provide practical advice, demonstrated through examples and with comprehensive documentation. The Examples will be based on Excel 2016 but where an earlier versions (2007 onwards) differs substantially this will be highlighted on the course.

WHO SHOULD ATTEND?

If your use of Excel includes summarising, analysing, auditing and reporting on any form of financial data you should find this course of value.

This course is suitable for the levels “General User to Developer” under the ICAEW IT Faculty Spreadsheet Competency Framework.

TOPICS
  • Introduction to PivotTables - from raw data to your top ten products in 5 minutes with no formulae
  • Dealing with data - different ways of getting at your data and keeping it updated automatically. Consolidating data from different parts of your organisation
  • Manipulating PivotTables - sorting, filtering, grouping and formatting
  • Advanced techniques - ad hoc grouping, adding formulae and working with values
  • PivotTable as report engine - using a PivotTable to automate the production of management reports
  • Using a PivotTable to create an automated performance dashboard
  • Latest PivotTable developments - conditional formatting, Excel 2010 slicers. PowerPivot, Power View, Power Map and Power Query (now known as ‘Get & Transform’ in Excel 2016) - possibly the most significant Microsoft Office development of the millennium?
   

Click here for booking form (pdf)

© SESCA Enterprises Ltd. 2001-