Sales Ended

Basic MS Excel Training

Event Information

Share this event

Date and Time

Location

Location

111 Paseo de Roxas Building

111 Paseo de Roxas

Makati, NCR 1229

Philippines

View Map

Friends Who Are Going
Event description

Description

This course is for beginners or general users of MS Excel. It includes all the essential skills in MS Excel like basic and advanced use of elementary functions, conditional formatting, creating charts, database management, and creating pivot reports. Filled with exercises, participants are ensured learning of a good working knowledge of MS Excel.

Inclusions

  • Certificates will be provided.

  • Handouts and workfiles included.

  • Bring your own laptop. Practice files will be emailed before the training.

  • Coffee and candies will be provided,

  • Light snacks (AM and PM) will be provided.

  • Lunch not included. The venue is right across Greenbelt. One hour lunch time 12NN-1PM.

  • Tax included.

  • Official Receipt will be issued during the training.

  • Training can be given as a gift.

Outline

Basic Excel Functions

  • Text Functions: LEFT, RIGHT, UPPER, LOWER, CONCATENATE etc

  • Math Functions: COUNTIF, SUMIF, etc

  • Basic Logical Functions: IF, IFERROR

  • Basic Lookup Functions: VLOOKUP

Data Management

  • Conditional Formatting

  • Text- to- Columns

  • Data ValidationConsolidation Tools

    • Creating Basic Dropdown Lists

    • Other Data Validation Options

  • Subtotals

Charts

  • Creating Charts

  • Adding and Modifying Chart Elements

    • Gridlines

    • Axes

    • Data Tables

    • Data Labels

    • Legends

Basic PivotTables

  • Creating Basic PivotTables

  • Modifying Value Field Settings

Share with friends

Date and Time

Location

111 Paseo de Roxas Building

111 Paseo de Roxas

Makati, NCR 1229

Philippines

View Map

Save This Event

Event Saved