Course Details
Course Code: GSSF-1; Instructor-led
Audience
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
Prerequisites
Basic knowledge of Windows is essential with the following pre-requisites:
- Able to maneuver with the mouse – Point, Click, Drag and Double Click
- Able to configure the desktop
- Able to use the Control Panel
- Able to move and re-size Application Windows
- Able to switch between task applications
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Course Objectives
- Give participant a systematic understanding of a spreadsheet ad its benefits
- Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment
Upon completion of this program, participants should be able to:
- Getting Started with Google Sheets, Identify the Elements and Interface
- Performing Calculation, Basic Formula and Functions
- Modify worksheet & Formatting Worksheet
- Printing and managing large workbook
Outlines
Module 1: Getting Started with Google Sheets
- Topic A – Identify the Elements of Google Sheet
- What is Google Sheet
- What is Google Sheet
- Accessing Google Sheets with Your Account
- The Google Sheet Interface
- Navigation Options
- Topic B Creating a New Blank Workbook
- Create a file
- Save a file
- View a file
- Rename a file
- Make a copy of a file
- Download a copy of a file
Module 2: Creating & Managing Spreadsheet
- Topic A: Manage Sheet
- Add & Rename sheet
- Copy & Rename sheet
- Move sheets order
- Delete a sheet
- Topic B: Getting Data into Cell
- Enter and edit data
- Fonts Format o Font type
- Font size
- Font color
- Bold & Italic
- Strikethrough
- Cell Format
- Border Options
- Fill Options
- Horizontal alignment
- Vertical alignment
- Data type
- Number Formats
- Date Format
- Currency Format
- Create series
- Create series if number
- Create series of dates
- Create series of text
- Copy, paste and move cell
- Text Wrapping
- Text Rotation
- Merge cells
- Topic C: Manage Rows & Column
- Insert row or column
- Delete row or column
- Resize row or column
- Copy and paste row & column
Module 3: Viewing Spreadsheet
- Topic A: Manipulate Sheet
- Undo & Redo
- Hide row and column
- Hide sheet
- Freeze row and column
- Topic B – Search and Replace Data
- The Find Command
- The Replace Command
- Search Range
- Search options
- Topic C – Spell Check a Worksheet
- Spell check
- Personal Dictionary
Module 4: Performing Simple Calculation
- Topic A: Create Formulas in a Worksheet
- The Formula Bar
- Common Mathematical Operators to create formula
- Topic B: Insert Functions in a Worksheet
- Summary Function
- SUM
- AVERAGE
- COUNT
- MIN
- MAX
- Summary Function
Module 5: Printing Spreadsheet
- Topic A: Define Page Setup
- Print Range
- Paper Size
- Page orientation
- Scale
- Margin
- Header & Footer
- Page order
- Page alignment
