₱1,228.98 – ₱1,843.98

Advanced Excel Training - 1 Day

Event Information

Share this event

Date and Time

Location

Location

111 Paseo de Roxas

111 Paseo de Roxas

Makati, NCR

Philippines

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Friends Who Are Going
Event description

Description

The Advanced MS Excel Training 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 tabls.


Topics:

1. Advanced Functions

Text Functions (LEN, TRIM, SUBSTITUTE)
Logical Functions (IF, AND, OR)
Conditional Math Functions (SUMIFS, COUNTIFS)
Advanced Lookup Functions (INDEX, MATCH)


2. Data Management

Formula-Based Conditional Formatting
Formula-Based Data Validation
Subtotal


3. Pivot Tables

Basic Pivot Table Features
Advanced Pivot Table Features (Grouping, Calculated Fields, etc.)


4. Introduction to Macros

Macro Recording
Assigning Macros to Buttons


Email us inquire@insightsmanila.com

Or send a text message: 0977.103.1800

Share with friends

Date and Time

Location

111 Paseo de Roxas

111 Paseo de Roxas

Makati, NCR

Philippines

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved