Loading Events

« All Events

  • This event has passed.

Microsoft Excel Training with Hands-on

October 19, 2016 @ 8:30 am - 5:30 pm

| Php3999

Course Description:

In today’s fast-paced, technical business environment, numbers are everything. Much of our success hinges on how well we can manage the data – statistics, planning, reporting – that we encounter on a daily basis. We learn how we are doing and discover our next course of action by studying numbers. An incredibly powerful tool for doing this is Microsoft Excel.

Microsoft Excel is the standard spreadsheet application for both the business world and personal use.

Course outline:

I – Navigating the Excel Program

  1. Parts of the excel program/the screen and basic terminologies
  2. Using Your Mouse and Keyboard
  3. Using the Menu
  4. Entering Values in Your Worksheet
  5. Saving and Reopening Your File
  6. Different Views
  7. Print Preview

II – Formatting

  1. Headers, Footers, and Page Numbers
  2. Adjusting the Printing Setup
  3. Adjusting Rows and Columns
  4. Merging Cells
  5. Boarders
  6. Colors and Patterns / Fill / Fonts
  7. Using the Format Painter
  8. Formatting Cell Values

III – Managing Your Worksheet

  1. Switching Between WorkSheets
  2. Inserting and deleting A Worksheet
  3. Renaming A WorkSheet
  4. Protecting a WorkSheet
  5. Hiding and Unhiding Worksheets
  6. Splitting and Freezing A Window
  7. Managing g Your Page Breaks

IV – Editing a Workbook

  1. Entering Date Values
  2. Replacing Cell contents
  3. How to Cut, Copy, Paste Cells
  4. Paste Special Option
  5. Inserting Cells
  6. Deleting Cells (rows and Columns)

V – Formulas

  1. Understanding Basic Formula
  2. Most Used Formulas
  3. Troubleshooting Formulas

VI – Charts and Graphs

Please fill the information below should you wish to register to any of our public training schedules.
Public Training Application Form
* indicates required field

Details

Date:
October 19, 2016
Time:
8:30 am - 5:30 pm
Cost:
Php3999
Event Tags:
, , , , ,

Organizer

COMPETAD Training and Professional Development Services
Phone:
(02) 3433 33 42
Email:
Website:
www.competad.com

Venue

Marsk Training Room
Marsk Building, Aurora Boulevard corner Balete Drive
Quezon City, NCR 1111 Philippines
+ Google Map