Event Details
  • Fort Legend Tower, Taguig, Metro Manila, Philippines
  • Jun 04, 2019

Photo above and information below are provided by event organizer verbatim.

NO PAYPAL? No problem.  Send us an SMS to 09771031800 for us to send instructions to complete payment via 711, BPI, Eastwest Bank, BDO, Cebuana, LBC, or GCash.

This training is for novice users of MS Excel who wishes to learn the fundamentals of the tool.  It aims to prepare participants for advanced discussion in MS Excel.

For inquiries, contact us at inquire@insightsmanila.com or send an SMS to 09771031800.  You can also chat with us via www.facebook.com/InsightsManila

Module 1.  Essential Excel Functions

Basic Arithmetic Formulas: SUM, AVERAGE, etc.

Text Functions: LEFT, RIGHT, CONCATENATE, etc.

Math Functions: SUM, COUNTIF, SUMIF, RANK, etc.

Absolute vs Relative Reference

Basic Logical Functions: IF

Basic Lookup Functions: VLOOKUP

Combining Functions (Basic)

Essential Excel Shortcut Keys

Module 2.  Data Management

Text- to- Columns

Conditional Formatting

Applying Conditional  Formatting

Data Bars, Color Scales, and Icon Sets

Data Validation

Creating Basic Dropdown Lists

Other Data Validation Options

Module 3.  Introduction to PivotTables

Creating  PivotTables

Modifying Value Field Settings

Grouping Data

View Event Organizer’s Page

Related Events

Upcoming Events

Other Events

Sales and Promos
Sales and Promos
Sales and Promos

Latest Articles

Latest Blogs