Event Details

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® Level 1 course. You will learn to create advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence. The ability to analyse massive amounts of data, extract actionable information, and present that information to decision makers is the foundation of a successful organisation that is able to compete at a high level.


Lesson 1: Working with Functions

  • Work with Ranges
  • Use Specialised Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions


Lesson 2: Working with Lists

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data


Lesson 3: Analysing Data

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting


Lesson 4: Visualising Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features


Lesson 5: Using PivotTables and PivotCharts

  • Create a PivotTable
  • Analyse PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicer




Speakers

  • CA

    Collin America

    Think360

Community

Discover and connect with other attendees.

View community profiles and add attendees into your favorites list.

Tickets

Members

Your tax invoice will be sent to you within 24 hours

Member Price R 1,495
Non-Members

Your tax invoice will be sent to you within 24 hours

Standard Price R 1,725

Venue

Think360

4th Floor
Zutari West Building
1 Century City Drive
Century City

Cape Town, Western Cape, South Africa

If you have any questions please contact Chanel Lee Glass

Contact Organizer

Show on map