Fundamentals of MS Excel and Google Sheets

SCHEDULES
July 15; 8AM-12NN

REGISTRATION
Join via Zoom: Php899
Join in Cubao: Php999

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. snacks (AM and PM)
4. lunch (fastfood)
5. candies and coffee
6. WIFI access

For via Zoom:

1. PDF handout
2. PDF certificate

Module 1. Introduction

-Difference of MS Excel and Google Sheets

-Preparing Files in Excel and Google Sheets

-Converting Excel to Google Sheets (and vice versa)

Module 2. Designing Your Worksheets

-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