Office Skills Level 3: Mastering Google Sheets for Data Management

Learndrive

• Module 01: Introduction of Google Sheet 04:08

  • 1: Office Skills: 1.1 Introduction to Google Sheets Preview 03:14
  • 2: Office Skills: 1.2 How to Access Google Sheets 00:54

• Module 02: Creating and Managing a spreadsheet 05:14

  • 3: Office Skills: 2.1 Naming a Spreadsheet (1) 01:34
  • 4: Office Skills: 2.2 How to Copy A Spreadsheet (1) 00:59
  • 5: Office Skills: 2.3 Moving a spreadsheet to Different Locations 00:48
  • 6: Office Skills: 2.4 Deleting a Spreadsheet 00:53
  • 7: Care for a feedback ! 01:00

• Module 03: Editing Spreadsheets 12:57

  • 8: Office Skills: 3.1 Writing or Deleting a Content 01:27
  • 9: Office Skills: 3.2 Inserting Rows & Columns 02:15
  • 10: Office Skills: 3.3 Moving Rows & Columns 01:31
  • 11: Office Skills: 3.4 Adding Multiple Sheet Tabs under One Spreadsheet 01:36
  • 12: Office Skills: 3.5 Replacement 00:48
  • 13: Office Skills: 3.6 Number Series (1) 02:12
  • 14: Office Skills: 3.7 Inserting Images 02:01
  • 15: Office Skills: 3.8 Inserting Hyperlink (1) 01:07

• Module 04: Viewing Spreadsheet 04:57

  • 16: Office Skills: 4.1 Freezing Rows & Columns 01:30
  • 17: Office Skills: 4.2 Hiding Rows & Columns 01:23
  • 18: Office Skills: 4.3 Using The Filter Method 01:18
  • 19: Office Skills: 4.4 Sorting Data in Spreadsheet 00:46

• Module 05: Formatting & Printing a spreadsheet 08:42

  • 20: Office Skills: 5.1 Formatting Cells 00:55
  • 21: Office Skills: 5.2 Formatting Texts 00:39
  • 22: Office Skills: 5.3 Adding Background Color in Cellls 00:55
  • 23: Office Skills: 5.4 Formatting borders 00:58
  • 24: Office Skills: 5.5 Resizing 00:20
  • 25: Office Skills: 5.6 How to Increase or Decrease Decimal Points 00:36
  • 26: Office Skills: 5.7 Conditional Formatting 01:43
  • 27: Office Skills: 5.8 Conditional Formatting based on Other Cells 01:06
  • 28: Office Skills: 5.9 Printing a Spreadsheet 01:30

• Module 06: Working with spreadsheet data 11:55

  • 29: Office Skills: 6.1 Quick Calculations 01:52
  • 30: Office Skills: 6.2 Basic Calculations 02:44
  • 31: Office Skills: 6.3 If_Functions 01:16
  • 32: Office Skills: 6.4 Charts 01:22
  • 33: Office Skills: 6.5 Pivot Tables 02:49
  • 34: Office Skills: 6.6 VLOOKUP 01:52

• Module 07: Collaboration with Google Sheets 05:18

  • 35: Office Skills: 7.1 Sharing a Spreadsheet 01:59
  • 36: Office Skills: 7.2 Commenting On a Spreadsheet 01:37
  • 37: Office Skills: 7.3 Version History 01:42

• Final Exam 01:00

  • 38: Final Exam 01:00

• Order Your CPDQE Certificate and Transcript 01:00

  • 39: LD cpdqe 01:00

Key Lesson Snippets

• Introduction to Google Sheets
  Get introduced to Google Sheets, learn the basic layout, and understand how it fits into your Office Skills for data management.

• Creating and Managing a Spreadsheet
  Develop core Office Skills by learning how to create, save, and manage Google Sheets, including organizing data efficiently.

• Editing Spreadsheets
  Learn how to edit and update your spreadsheets using essential Office Skills such as adding, deleting, and modifying data entries.

• Viewing Spreadsheets
  Master the techniques for viewing and navigating through spreadsheets effectively, an essential Office Skill for data analysis.

• Formatting & Printing a Spreadsheet
  Learn how to format your data for presentation and printing, a key Office Skill to ensure clarity and professionalism in your documents.

• Working with Spreadsheet Data
  Explore how to manage and manipulate large sets of data within Google Sheets, focusing on key Office Skills for data analysis.

• Collaboration with Google Sheets
  Discover the power of real-time collaboration in Google Sheets, and learn how to share and work with others, a vital Office Skill for team-based projects.

This course will pave the way for higher study in the field of Office Skills. You can enrol on higher level Office Skills courses, such as:

• Level 1 Certificate in Office Skills
• Level 2 Certificate in Business Administration (Office Skills)
• Level 3 Certificate in Business Administration (Office Skills)

• Personal Executive Assistant
• Receptionist
• Office Assistant
• Support Secretary
• Office Manager
• Personal Concierge
• Executive Assistant

There are currently no Q&As for this course. Be the first to ask a question.