Schedule of Trainings and Seminars


Time:

8:00AM-5:00PM

Start Date:

July 18, 2019

End Date:

July 18, 2019

Status

closed

Course Details


Course Name

Basic MS Excel 2016

Type of Course Module

basic Course Module

Course Description

Improve your office productivity by maximizing the use of MS Excel. At the end of the session, the participants should be able to:

* Perform basic calculations

* Combine And Split Data Using Flashfill, Concatenate And Text To Columns

* Create Tables, Simple And Combo Charts To Visualize Data

* Prepare And Protect Forms In Spreadsheets

* Handle And Manipulate Data For Better Appreciation

* Calculate duration between times and dates

Course Outline

* Getting around MS Excel

* Common Formats

* Simple Calculation

* Relative and Absolute cell reference

* Tables and design

* Templates

* Paste Special and transpose

* Quick Analysis / Running total

* Sort and simple filters

* Flashfill ,concatenate & Split using “Text to columns”

* Simple charts, combo charts

* Vlook up

* Printing

* Workshop 1

* sheet protection

* Common functions a(average, sumif, counta, countif)

* Dates & time

* Final workshop

Duration

1 day

Registration Fee

3000.00

Contact Person

Joseph Argente

Email

josephargente@pttc.gov.ph

Contact Number

831-9988

Duration

1 day

Registration Fee

3,000.00

Contact Person

Joseph Argente

Email

josephargente@pttc.gov.ph

Contact Number

831-9988

This entry was posted in . Bookmark the permalink.

Trainings & Seminars