Selwyn Community Education

  • Home
  • Our Courses
  • About Us
  • News and Blog
  • Selwyn College
  • Contact Us
  •  
  •  

Microsoft Excel Advanced – Pivot Tables

    Home Microsoft Excel Advanced – Pivot Tables

    Learn to utilise Pivot Tables to summarise data and streamline the process of formatting and displaying the results. Who should enrol: the experienced Excel user who wants to go beyond the basics with a special focus on analysing large tables of data or databases using Excel's Pivot Tables. You will already be confidently preparing charts and tables and using a range of formulae and functions. More details below course dates.

    • Sat 26 Jun
      Saturday 9am - 1pm Selwyn College, Auckland. Jose Entrican
      • $70.00 incl. GST
      Session information
      Sessions
      Saturday workshop
      Sat 26 Jun 09:00 - Sat 26 Jun 13:00
      Selwyn College, Auckland.
      Register
    • Sat 11 Sep
      Saturday workshop 9am - 1pm Selwyn College, Auckland. Jose Entrican
      • $70.00 incl. GST
      Session information
      Sessions
      Saturday workshop
      Sat 11 Sep 09:00 - Sat 11 Sep 13:00
      Selwyn College, Auckland.
      Register
    Share

    Let me know about future course dates

    Description

    PivotTable is the single most powerful tool in Excel for financial reporting, budgeting and data analysis. This can save you hours and deliver impressive results. IBM are projecting that demand for Data Visualisation alone is projected to grow by 44% and PivotTable skills specifically by 34% by 2020. So this is an Excel skill that will be very useful to know.

    Course content includes:

    • Create Pivot Tables and understand how they refresh
    • Use functions other than SUM to analyse your data
    • Group numbers, dates and even text labels to streamline the table
    • Use filtering effectively to display only the data you want
    • Add custom calculations to your PivotTable summary and understand the GETPIVOTDATA function
    • Use pivot tables to gather data for your 'Dashboard' likes displays that include slicers and charts
    • Modify the presentation of your pivot tables with conditional formats and varied layouts
    • Become aware of the Pivot Table Data Model for analysing data in more than one table

    Who should attend this course?

    This class is designed for the experienced intermediate level Excel user who wants to go beyond the basics with a special focus on analysing large tables of data or databases using Excel's Pivot Tables. You will already be confidently preparing charts and tables and using a  range of formulae and functions.

    This course is taught in a PC suite using the school's computers.

    Prerequisites

    You should already be an experienced Excel user with skills in preparing charts and tables and using a range of formulae and functions.

    Powered by Arlo training & Event Software
    Share

    new-logo-circle-web

    (09) 521 9623
    info@selwyncomed.school.nz
    203-245 Kohimarama Road, Kohimarama

    Open Hours
    Term Time: Monday - Wednesday 9:00am - 9:00pm
    Thursday - Friday 9:00am - 3:00pm

    School Holidays: When courses are running the office is open 9:00am - 4:00pm




    Powered by Graphic Detail Ltd
    • Home
    • Our Courses
    • About Us
    • News and Blog
    • Selwyn College
    • Contact Us
    •  
    •  

    Selwyn Community Education