Basics of MS Excel

Learn the basics of worksheet preparation, formulas, and tools using MS Excel and Google Sheets

About this Event

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.

Get Tickets