Select Page
Pivots & Macros
Discover how to Analyse data using all the power and flexibility of Pivot Tables, Pivot Charts and the Slicer. You'll find out how to use Macros in Excel to automate repetitive tasks
g

Intermediate

0.5 Day Classroom Course

Certification Awarded

Online Study Materials

Skills You will have at the end of the Course

    • In depth analysis of Pivot Tables
    • Visualising your data with Pivot Charts
    • Creating interactive reports with the Slicer tool
    • Record new and run existing Macros
    • Understand the difference between relative and absolute Macros
    • Apply macros to the quick access toolbar or New tab on the Ribbon

ONLINE OPTION AVAILABLE

Learn at your own pace

Course overview

Excel Pivot tables provide a powerful way to summarise and report on vast amounts of Data. You’ll learn in detail how Pivot Tables, Pivot Charts and Slicers work and the structure that must be followed to create useful interactive reports and charts. Also learn how to work with and manipulate Macros recorded in Excel. You’ll be able to automate those daily repetitive tasks you have in Excel.

 

Requirements

Prior use of Pivot Tables and a good knowledge of Excel is essential.

 

Certification

At the end of the course, you’ll be an Excel Expert – Certified by the Irish Academy of Computer Training

Who would benefit

Those looking to take their knowledge of data analysis to the next level.

Why take the Course

You will be able to construct and manipulate complex summaries and analyses of data using Pivot Table tools, control visual and data formatting, manage and add to the statistical analysis of your data, deal with varying data sources, automate, troubleshoot and utilise Pivoted data in many different contexts. Also learn to automate, standardise and streamline repetitive actions in Excel.

  • Receive and industry recognized certification
  • Gain the skills necessary to progress in the Data Entry/Management sector
  • Learn to utilize complex Macros to simplify your life
  • Open a wide array of opportunities for yourself at work and at home
  • Be able to understand everything inside the Excel program

Online Option Available

Course curriculum

Module 1 : Pivot Tables, Pivot Charts and Slicers

Pivot Tables, Pivot Charts and Slicers

  • Introduction
  • Why do we use a pivot table?
  • Create a pivot table from a list
  • Formatting the Pivot table
  • Create a pivot chart from a list
  • Formatting the Pivot Chart
  • Refreshing a pivot table and pivot chart
  • Drill down lists
  • Slicer tool
  • Multiple headings in table
  • Copy and paste into other worksheets
  • Copy and paste into Word and PowerPoint
  • Using action settings
  • Using Calculation settings
  • Turning on and off option in Show group
  • Editing Pivot table options
  • Extra options in Excel 2013
Module 2 : Macros

Macros

  • Introduction
  • Opening the Developer Tab
  • Running an existing macro
  • Record a macro to this workbook
  • Saving a workbook that holds a macro
  • Absolute and relative macros
  • Step into an existing macro
  • Copying a Macro from one workbook to another
  • Deleting a macro from this workbook
  • Record a macro to the Personal Macro Workbook
  • Deleting a macro from the personal macro workbook
  • Assigning a macro to a button on the sheet
  • Assigning a macro to an icon on a ribbon
  • Creating your own tab and ribbon

For Dates, Pricing & more info, please enter your details and we'll get back to you quickly.

Or call us on 01 434 7600 

Course Enquiry

  • Agreement for us to contact you

  • We'd love to keep you informed of useful, relevant offers and services. This may be via email or phone.
  • This field is for validation purposes and should be left unchanged.

*Required info. We treat your data with care, please see our Privacy Notice for more details

IACT - Ireland's leading training provider