CONNECT WITH US!

(02) 8616 8079

0917 113 1154

Head Office: 6F Salustiana D. Ty Tower Paseo de Roxas cor. Perea St. Legaspi Village, Makati City

Philippines

Training Center: 5F National Life Insurance Company Building, 6762 Ayala Avenue, Makati City Philippines

© 2016-2017 Phoenix One Knowledge Solutions, Inc.

MS Excel Basic

DURATION:

8 hours (1 day)

Prerequisites

Participants who wish to attend this training must at least have basic PC skills or working knowledge of Windows

Course Description

Most jobs require a basic knowledge in using Microsoft Excel.  Any employee should at least know its user interface, have the ability to enter and format data, calculate totals and summaries through basic formulas or create simple reports and charts.  This 2-day instructor-led training will teach beginning Excel users the basic functionalities to use and navigate Microsoft Excel 2010, 2013 or 2016. 

Course Objectives

Upon completion of this course, participants will be able to:

  • Explore the Excel window

  • Use help and the Office Assistant

  • Open, close, and navigate workbooks

  • Create workbooks

  • Enter and edit data

  • Enter and edit formulas

  • Use functions like SUM, AVERAGE, MIN, MAX, & COUNT

  • Format worksheets

  • Print a worksheet

  • Specify page setup options

  • Create, modify, and print charts

  • Save worksheets as Web pages

  • Insert and edit hyperlinks in worksheets

  • Send workbooks via email

  • Hide and display data

  • Print large worksheets

  • Work with multiple worksheets and workbooks

  • Customize toolbars and menus

  • Use chart formatting options

  • Create combination charts

  • Add borders and shading to a cell or range of cells

  • Work with dates

  • Work with styles

  • Merge and split cells

  • Sort and filter lists

  • Trace errors

  • Protect a worksheet by using passwords

  • Merge and share workbooks

  • Create and manage templates

Who Should Attend

Working professionals from any job level or function or students using Windows-based PCs and wishing to use Microsoft Excel 2010, 2013 or 2016.