Spreadsheet 101 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:
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.