Spreadsheet Advanced Formulas and Functions Full Workshop
Event Information
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.
