Event Details
  • Fort Legend Tower, Taguig, Metro Manila, Philippines
  • Sep 30, 2019

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

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

Latest Articles

Latest Blogs