Loading Events

« All Events

  • This event has passed.

Excel part 2: Excel Functions Including Pivot Tables and Lookups

May 16 @ 9:00 am - 5:00 pm

Course Content

Module 1: Working with Functions and Complex Calculations

  • Summarising Data using Functions (Sum/SumIf, Count/CountIf etc.)
  • Work with Logical Functions
  • Work with Lookup Functions
  • Work with Date and Time Functions
  • Work with Text Functions

Module 2: Working with Lists and Tables

  • Sort and Filter Data
  • Remove Duplicate Values
  • Group and Outline Data
  • Subtotal Data

Module 3: Visualizing Data with Charts

  • Create and Modify Charts
  • Use Advanced Chart Features
  • Save a Custom Chart Template

Module 4: Using Tables, Pivot Table Reports and Pivot Charts

  • Create and Modify Tables
  • Use Functions to Calculate in Tables
  • Create a Pivot Table Report
  • Manipulate Pivot Tables
  • Present Data with Pivot Charts
  • Filter Data by Using Slicers and Timelines

IA Members €140

Book your place by emailing maureen@dppskillnet.ie

Details

Date:
May 16
Time:
9:00 am - 5:00 pm
Event Categories:
, , , ,

Organiser

Design, Print & Packing Skillnets
Email:
maureen@dppskillnet.ie
Website:
http://dppskillnet.ie/index.php/events/adobe-photoshop-cs6/

Venue

New Horizons
22 – 24 Great Strand Street
Dublin 1, Ireland
+ Google Map

Skip to toolbar