Basics of MS Excel
Schedule
Tue Jun 25 2024 at 08:00 am to 12:00 pm
UTC+08:00Location
222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH | Quezon City, MM
VENUE
-Mpower Training Center
-222 Vivaldi Residences, EDSA cor Aurora Blvd.., Cubao, Quezon City
-B ring own laptop
INCLUSIONS
F or onsite:
-p rinted handout
-p rinted certificate
-AM s nacks
-c andies and coffee
-W IFI access
F or via Zoom:
-P DF handout
-P DF certificate
OUTLINE
Module 1. Introduction: MS Excel
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
Where is it happening?
222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH, PhilippinesEvent Location & Nearby Stays: