Basics of MS Excel

VENUE

• Mpower Training Center
• 222 Vivaldi Residences, EDSA cor Aurora Blvd.., Cubao, Quezon City
• Bring own laptop

INCLUSIONS

For onsite:

1. printed handout
2. printed certificate
3. AM snacks
4. candies and coffee
5. WIFI access

For via Zoom:

1. PDF handout
2. 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.

Host or Publisher Insights Training