OVERVIEW:

Join us in our online learning session as part of our initiative to equip educators, students and professionals who want to manage documents using advanced tools and techniques in working with spreadsheets / worksheets.

OBJECTIVE:

This webinar session will show you various tips and techniques guaranteed to save you time and speed up your work.

SUMMARY OF CONTENT:

Keyboard Shortcuts

Getting Started with Worksheets

User Interface Navigation

Basic Commands

Create and Save Workbook

Enter Cell Data

Create Worksheet Formulas and Functions

Modifying a Worksheet

- Insert, Delete, and Adjust Cells, Columns, and Rows

Search for and Replace Data

Formatting Text and Number

Align Cell Contents

Styles and Themes

Basic Conditional Formatting

Printing Workbooks

Set Up the Page Layout

Configure Headers and Footers

Managing Workbooks and Worksheets

INTERMEDIATE

Working With Functions

Work with Ranges

Logical Functions

Date and Time Functions

Text Functions

Lookup Functions

Working With Lists

Sort Data

Filter Data

Creating Charts

Linking Worksheets

Pivot Tables

Includes: Live Sessions, Recordings and 30-Day Email Support for the first 15 REGISTRATIONS

SCHEDULE: (Bassed on GMT +8: Singapore/Philippines/Malaysia Time)

5 April 2021 , Monday @ 2:00 - 5: 00 PM

7 April 2021, Wednesday @ 2:00 - 5: 00 PM

9 April 2021 , Friday @ 2:00 - 5: 00 PM

ABOUT THE TRAINER:

Edwin Cordenete

Edwin teaches Programming, Graphics and Computer Aided Design courses.

He has been a university instructor for two decades while working with various industries, both in the public and in the private sectors as an IT Consultant. He also worked for 6 years as a Senior Software Engineer for Pteris Global Ltd Singapore.

He holds a Bachelor's Degree in Computer Engineering and a Masters Degree in Engineering Management with specialization in Systems Management.

As a Speaker, Edwin has delivered various IT-related Technical Training Programs, Motivational Speaking, Health & Wellness and Financial Management seminars.