Basics of MS Excel

Sat Jan 25 2025 at 09:00 am to 04:00 pm UTC+08:00

Mpower Learning Manila | Mandaluyong City

Insights Training
Publisher/HostInsights Training
Basics of MS Excel
Advertisement
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

-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

Advertisement

Event Venue & Nearby Stays

Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines

Tickets

PHP 949.50 to PHP 2399.00

Sharing is Caring:

More Events in Mandaluyong City

lullaboy @ Teatrino Promenade in San Juan
Sat, 25 Jan, 2025 at 08:00 pm lullaboy @ Teatrino Promenade in San Juan

Teatrino Promenade

Advanced MS Excel Training
Thu, 30 Jan, 2025 at 09:00 am Advanced MS Excel Training

Mpower Learning Manila

AVIATION COUNTER TERRORISM AWARENESS "TERRORIST PROFILING"
Fri, 31 Jan, 2025 at 08:00 am AVIATION COUNTER TERRORISM AWARENESS "TERRORIST PROFILING"

Sputnik Aviation

AURORA in Quezon City
Fri, 31 Jan, 2025 at 07:00 pm AURORA in Quezon City

New Frontier Theater

SOLLSM Grand Alumni Homecoming
Sat, 08 Feb, 2025 at 04:00 pm SOLLSM Grand Alumni Homecoming

Lourdes School of Mandaluyong

CyberSecPhil Conference
Tue, 11 Feb, 2025 at 08:30 am CyberSecPhil Conference

The Fifth at Rockwell, Events Hall

Mandaluyong City is Happening!

Never miss your favorite happenings again!

Explore Mandaluyong City Events