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