9 hours
Mpower Learning Manila
Starting at PHP 999
Mon, 08 Sep, 2025 at 08:00 am to 05:00 pm (GMT+08:00)
Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines
VENUE
INCLUSIONS
For onsite:
For via Zoom:
OUTLINE
Module 1. Introduction: MS Excel
Module 2. Designing Your Worksheets (discussed in passing)
-Formatting Cells: Borders, Fill Colors, Merging Cells, etc.
-Sorting and Filtering Data
-Using Freeze Panes to Improve Worksheet Interaction
-Hiding and Inserting Rows, Columns, and Sheets
-Adding, Deleting, and Renaming Worksheets
Module 3. Essential Worksheet Functions
-Basic Arithmetic Formulas: SUM, AVERAGE, etc.
-Text Functions: UPPER, LOWER, CONCATENATE, etc.
-Math Functions: SUM, COUNTIF, SUMIF, etc.
-Absolute vs Relative Reference
-Basic Logical Functions: IF
-Using VLOOKUP to Relate Tables
Module 4. Data and Formatting Tools
-Using Text- to- Columns to Separate Texts
-Applying Basic Conditional Formatting
-Creating Basic Dropdown Lists
Module 5. Introduction to Pivot Tables
-Creating Pivot Tables
-Formatting Fields
-Presenting Information using Pivot Tables
For fuill day classes, all schedules are set at 8AM-5PM. However, if the headcount is low, the training may be set at 9AM-4PM or 9AM-5PM. Your certificate, still, will indicate 8 hours.The start time and end time will be finalized three days before the class. Please look for an email from us or chat with us to confirm.
Also check out other Workshops in Mandaluyong City.
Tickets for Basics of MS Excel can be booked here.
| Ticket type | Ticket price |
|---|---|
| Early Bird (Cubao) | 2,099 PHP |
| Early Bird (via Zoom) | 1,499 PHP |
| Join via Zoom | 1,999 PHP |
| Join in Cubao | 2,499 PHP |
| 2 for 1 Admission (via Zoom) | 999 PHP |
