Description
The focus of this module is on enhancing the skills of the office staff in organizing data for the purposes of report and data management. This program is best for those who want to organize data and generate reports.
Course Outline:
· Excel Interface
· Basics
· Basic Excel Functions (SUM, MAX, MIN, AVERAGE, COUNT)
· Keyboard Shortcuts
· What is a Spreadsheet?
· Working with Multiple Worksheets (Linking)
· Understanding Fill Series and AutoFill
· Entering Formula
· Formulas beyond Addition & Subtractions
· Understanding Formula standards (Relative, Absolute & Mixed References)
· Using AutoSUM
· Creating and Formatting Charts
· Using Auto Filter with logical parameters (>, <, <=, >=, etc.)
· Printing and Using Print Preview & Page Setup
· Using Page Break
· Freezing Panes and Split
· Hiding Formula
· Protecting Worksheet and Workbook
Resource Speaker:
Ms. Maria Anna Masindo
Wholebrain Training & Consultancy
Schedule:
23-24 February 2022
Thursday-Friday
9:00 AM – 5:00 PM
Training Fee per Participant:
From Member Institution – P 5,600.00
From Non-Member Institution – P 7,840.00
**VAT inclusive