Details
Learn the basics of Google Sheets-- skills that are important to use this tool and start your journey in learning this program. You will learn how to create and format worksheets, use simple formulas, and create simple analyses using Pivot Tables.
April 14, Friday, 8:30AM-12NN
YOU CAN JOIN ONSITE IN CUBAO or AT THE COMFORTS OF YOUR HOME VIA ZOOM
Click the "GET TICKETS" to find Payment Methods (GCash, credit card, bank deposit, etc.)
Onsite:
Registration: Php1,499 per person
EARLY BIRD: Php1,399 per person
INCLUSIONS:
- 1 snack per day
- Handouts
- Certificate
- overflowing coffee
- WIFI access
BRING OWN LAPTOP
Where: Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, QC
via Zoom:
Registration: Php1,399 per person
EARLY BIRD: Php1,199 per person
INCLUSIONS:
- PDF handouts
- PDF certificate
OUTLINE
Module 1. Designing Your Worksheets
-Formatting Cells: Borders, Fill Colors, etc.
-Sorting and Filter
-Freeze Panes
-Hiding and Inserting Rows, Columns, and Sheets
Module 2. Essential Google Sheets Functions
-Sorting and Filter
-Freeze Panes
-Hiding and Inserting Rows, Columns, and Sheets
Module 2. Essential Google Sheets 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
Module 3. Data and Formatting Tools
-Text Functions: UPPER, LOWER, CONCATENATE, etc.
-Math Functions: SUM, COUNTIF, SUMIF, etc.
-Absolute vs Relative Reference
-Basic Logical Functions: IF
Module 3. Data and Formatting Tools
-Using Text- to- Columns to Separate Texts
-Applying Basic Conditional Formatting
-Creating Basic Dropdown Lists
Module 4. Introduction to PivotTables
-Applying Basic Conditional Formatting
-Creating Basic Dropdown Lists
Module 4. Introduction to PivotTables
-Creating PivotTables
-Formatting Fields
-Formatting Fields
Outline
OUTLINE
Module 1. Designing Your Worksheets
-Formatting Cells: Borders, Fill Colors, etc.
-Sorting and Filter
-Freeze Panes
-Hiding and Inserting Rows, Columns, and Sheets
Module 2. Essential Google Sheets Functions
-Sorting and Filter
-Freeze Panes
-Hiding and Inserting Rows, Columns, and Sheets
Module 2. Essential Google Sheets 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
Module 3. Data and Formatting Tools
-Text Functions: UPPER, LOWER, CONCATENATE, etc.
-Math Functions: SUM, COUNTIF, SUMIF, etc.
-Absolute vs Relative Reference
-Basic Logical Functions: IF
Module 3. Data and Formatting Tools
-Using Text- to- Columns to Separate Texts
-Applying Basic Conditional Formatting
-Creating Basic Dropdown Lists
Module 4. Introduction to PivotTables
-Applying Basic Conditional Formatting
-Creating Basic Dropdown Lists
Module 4. Introduction to PivotTables
-Creating PivotTables
-Formatting Fields
-Formatting Fields
Schedules
No. of Days: | 1 |
Total Hours: | 4 |
Reviews
Be the first to write a review about this course.
Write a Review
Mpower Learning focuses on improving the leadership and productivity skills of Filipinos through its value-driven training.