Basics of MS Excel

Basics of MS Excel

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

By Insights Training

Date and time

Tuesday, June 17 · 8am - 5pm PST

Location

Mpower Learning Manila

222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd Quezon City, 1109 Philippines

Refund Policy

Refunds up to 7 days before event

About this event

  • Event lasts 9 hours

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.

Organized by

Insights Training is a pool of traning consultants offering their courses at an affordable investment.  We believe that training must be affordable but effective (and fun!) at the same time.

Visit our website at www.insightsmanila.com for more details.

Our office is located at 7F Finman Bldg., 131 Tordesillas St., Salcedo Village, Makati.  You may reach us at info@insightsmanila.com, 0977.103.1800.

Early bird discount
2 for 1 deal
₱950 – ₱2,399