₱1,899

Advanced MS Excel - Davao

Event Information

Share this event

Date and Time

Location

Location

Spacelab Co-working Space

Emilio Jacinto Extension

Davao City, Davao Region 8000

Philippines

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

This training is for those who already has an existing knowledge of Basic MS Excel. (You may also join the Basic Excel Training of the previous day to prepare yourself for the Advanced Excel Training-- link here:

Basic Excel: https://www.eventbrite.com/e/basic-ms-excel-davao-tickets-53777926225

_____________________

The Advanced MS Excel course will level up your skill in order to efficiently process data in the spreadsheet. This course goes beyond VLOOKUP-- you will learn to look up data regardless of data orientation. You will also learn how to make advanced pivot table features such as Calculated Fields, Slicers, etc.

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Notes:

1. Bring own laptop

2. Lunch included

3. Handouts and certificate will be given

Outline:

Module 1: Quick Review of Basic Functions

  • Text Functions UPPER LOWER PROPER LEFT RIGHT MID CONCATENATE
  • Basic Logical Statements IF
  • Basic Math Functions SUM AVERAGE
  • Basic Lookup Functions VLOOKUP
  • Combining Functions

Module 2: Advanced Excel Functions

  • Text Functions TRIM, SUBSTITUTE
  • Combing Logical Tests using AND and OR
  • Advanced Math Functions SUMIFS, COUNTIFS, AVERAGEIFS
  • Advanced Lookup Functions: INDEX and MATCH

Module 3: Advanced Data Tools

  • Creating Own Conditional Formatting
  • Data Validation with Formulas
  • Subtotal Tool

Module 4: Advanced PivotTables

  • Review of Basic PivotTables
  • Grouping
  • Slicers
  • Calculated Fields
  • PivotCharts
Share with friends

Date and Time

Location

Spacelab Co-working Space

Emilio Jacinto Extension

Davao City, Davao Region 8000

Philippines

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved