MANAGING DATA WITH SPREADSHEETS

Participant Capacity

0
PERSON

PROGRAM TYPE

CLASSROOM TRAINING

0
DAYS
0
HOURS / DAY

19 SEPT 2020

TO

20 Sept 2020

LEARN TO USE GOOGLE SHEETS

Sheets was designed with the needs of agile organisations in mind. With an AI features mean that you can tap into the right insights to make meaningful business decisions.

Google sheets is a cloud-based system which enables you to share and collaborate easily with others.

Access to the application is not limited to a single office or PC. It is compatible with others systems such as Microsoft Excel, this removes any friction when working with data from multiple sources.

OBJECTIVES

Upon completing this program participants should be able to:

  • Apply spreadsheets for their data works
  • Identify the data formulas needed
  • Analyse data using spreadsheets
  • Change the way data is handle in the office

DAY 1

  • Understanding the spreadsheet concept
  • Using Google Sheets for spreadsheet work
  • Format Worksheets and work with formulas
  • IF and VLOOKUP Functions
  • Create Charts, Tables and Sparklines

DAY 2

  • Formatting Cells
  • Using What If Data Scenarios
  • Filter and Sort Data
  • Pivot Tables and Data Analysis
  • Consolidate data across multi-sheets

Connect

David

Ms. Wong

No email / whatsapp?

PROGRAM DETAILS

FEES

RM 700 per person (Inclusive refreshments)

Participant Capacity

10 persons

Program Type

Classroom Training

Duration

2 days / 7 hours a day (9am to 5pm)

location

ECi Training Centre

No. 3a-1, Jalan PJS 5/28a,
PJCC City Centre,
46150, Petaling Jaya,
Sel.

WHO SHOULD ATTEND

Managers, Executives,  Management Trainees, & Office Admins