Google Sheets Training: Unlocking Your Spreadsheet Potential
Are you ready to supercharge your spreadsheet skills? Look no further than our ‘Google Sheets Foundation’ course. This comprehensive training program is designed for Clerks, Officers, Executives, Supervisors, Administrators, and Managers at all levels who want to harness the full power of Google Sheets.
Mastering the Essentials
In this engaging course, you’ll gain a systematic understanding of Google Sheets and its myriad benefits. Starting with the basics, you’ll dive into the Google Sheets interface, learning to navigate with ease. You’ll discover how to create, manage, and format spreadsheets, enabling you to handle data efficiently. We’ll unravel the magic of formulas and functions, empowering you to perform complex calculations effortlessly.
A Career Boost
By the end of the ‘Google Sheets Foundation’ course, you’ll be well-equipped to tackle the real-world demands of modern businesses. From organizing data to making informed decisions, you’ll have the skills to excel in your career. So, if you’re looking to enhance your spreadsheet proficiency and stay ahead in the corporate world, this training is your gateway to success. Enroll today and embark on your journey to become a Google Sheets pro.
With ‘Google Sheets Training,’ the possibilities are limitless. Don’t just work with data—master it.
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
