Excel - Excel Functions Including Pivot Tables and Lookups

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

Excel - Excel Functions Including Pivot Tables and Lookups

Skip to Available Dates

Learning Objectives

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

 

Course Details

Course Outline

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
  • 2 - Working with Lists and Tables
  • Sort and Filter Data
  • Remove Duplicate Values
  • Group and Outline Data
  • Subtotal Data
  • 3 - Visualizing Data with Charts
  • Create and Modify Charts
  • Use Advanced Chart Features
  • Save a Custom Chart Template
  • 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
  • Actual course outline may vary depending on offering center. Contact your sales representative for more information.

    Who is it For?

    Target Audience

    To ensure success, students should have completed Excel Essentials or have the equivalent knowledge and experience.

    Excel - Excel Functions Including Pivot Tables and Lookups

    €275
    Course Length : 1 Day (8 Hours)
     

    1. Choose a Date | 2. Click Enroll Now

    Need Help Picking the Right Course? Give us a call! 01 8898700