VENUE
- Mpower Training Center
- 222 Vivaldi Residences, EDSA cor Aurora Blvd.., Cubao, Quezon City
- Bring own laptop
INCLUSIONS
For onsite:
- printed handout
- printed certificate
- AM snacks
- candies and coffee
- WIFI access
For via Zoom:
- PDF handout
- PDF certificate
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.
