$168 – $195

Spreadsheet Advanced Formulas and Functions Full Workshop

Actions and Detail Panel

$168 – $195

Event Information

Share this event

Date and Time

Location

Location

Online Event

Refund Policy

Refund Policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

Event description
Tips and techniques guaranteed to save you time and speed up your work

About this Event

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:

  • Review of Keyboard Shortcuts
  • Formulas and Functions 101
  • Cell Reference
  • Conditional Statements & Logical Operators
  • Mathematical Functions
  • Trigonometric Functions
  • Matrix Functions
  • Statistical Functions
  • Lookup & Reference Functions
  • Text Functions
  • Date & Time Functions
  • Query Data with Database Functions
  • Outline and Subtotal Data
  • Analyzing Data
  • Visualizing Data With Charts
  • Use Advanced Chart Features
  • Analyzing Data With PivotTables and PivotCharts
  • Protect Worksheets and Workbooks
  • Lookup Formulas and Formula Auditing
  • Trace Cells
  • Watch and Evaluate Formulas
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Working with Macros
  • Forecasting Data
  • Use the Goal Seek Feature

Includes: Live Sessions, Recordings and 30-Day Email Support for the FIRST 15 Registrations!

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

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

4 August 2021 , Wednesday @ 2:00 - 5: 00 PM

6 August 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.


		Spreadsheet Advanced Formulas and Functions Full Workshop image
Share with friends

Date and Time

Location

Online Event

Refund Policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved