Google Sheets


  • Google Sheets, Singapore elarning online course
  • Google Sheets, Singapore elarning online course
  • Google Sheets, Singapore elarning online course
  • Google Sheets, Singapore elarning online course
  • Google Sheets, Singapore elarning online course
  • Google Sheets, Singapore elarning online course

Course Description

Google Spreadsheets is rapidly overtaking Microsoft Excel in the workplace. Engage with this exciting new product and become a Google Sheets Master with this course. Google Sheets replicates many of Excel’s functions but has gone one step further. Expect to find charts, graphs, pivot tables, functions and formulas, but you’ll also discover what makes Google Sheets unique, like file sharing, revision history, web based scripts, macros, and much more. It’s not your typical spreadsheet.

Keep up with the latest trend on how documents are made.

- Know about all of the functions in Google Sheets
- Learn how you can apply Google Sheets into your work
- Learn about the different functions of Google Sheets
- Know how Google Sheets can used in your projects


Course Objectives

1. Understand the different features offered in Google Sheets
2. Know what is the purpose of each feature in Google Sheets
3. Be able to use the features of Google Sheets into own projects
4. Know how to navigate the functionalities in Google Sheets


Related Courses

  • FileMaker Pro 12: Beginner

    FileMaker Pro 12: Beginner

    SGD $80.00

    Course Description

    FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from beginner level and uses a single invoicing example to demonstrate all the features in FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 including: field creation, finding, sorting, layout mode, container fields, auto-entry, validation, printing, scripts, calculations, importing, exporting, interface design and new FileMaker Pro 12 features including charting, snapshot links and the inspector. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning.Discover how data can be managed efficiently. - Find out how you can manage your database- Learn ways to fully utilize your data's potential - Know how queries can be implemented to run the data better - Understand an effective solution to optimize your database's productivity This course is SkillsFuture Credit Eligible.

    Read more...

  • FileMaker Server 12

    FileMaker Server 12

    SGD $40.00

    Course Description

    FileMaker Server is the cornerstone of a trouble-free and performant FileMaker solution deployment. This course describes the new FileMaker Server 12. The videos outline what is new, explains in detail how to install and configure FileMaker Server and what to look out for. The section on troubleshooting and best practices will make sure you are well equipped to keep your deployment running. And since FileMaker Server lets you easily integrate your data with other applications and the web, that topic is also covered extensively. Work Files are included. Discover how data can be managed efficiently. - Find out how you can manage your database- Learn ways to fully utilize your data's potential - Understand the best practises of maintaining a database- Learn of the different ways to efficiently handle your data 

    Read more...

  • Maximize your Database with Microsoft Access 2013

    Maximize your Database with Microsoft Access 2013

    SGD $40.00

    Course Description

    Microsoft Access 2013 is the latest version of the number one database application in the world, and this is a big release. Access 2013 brings quite a few changes, all designed to make database applications easier to design and implement. The ability to quickly create Web Applications that run in the user's browser, regardless of which device they use, is one of the major changes in the latest release. In this VTC course, author Mark Long takes you step by step through Access 2013 to quickly get you up to speed on these changes. Access is everywhere, from small one-person businesses up to the largest corporations in the world. It's where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services. Understanding Access is vital to real world database creation/maintenance/design and this course will show you what you need to get there. Realise the full potential of your data with Microsoft Access. - Learn about the functions in Microsoft Access that can help your understand data better - Know the different ways of vizualising your data with Microsoft Access- Pick up the knowledge of utilizing Access for better understanding your data- Learn how you can stretch your data for optimum analysis 

    Read more...


Content

Google Sheets

+
Learn everything there is to Google Sheets
  • Section 1: The Basics
    • Unit 1.1 - Introduction
    • Unit 1.2 - Spreadsheet Basics
  • Section 2: Manipulating Data, Functions, and Formulas
    • Unit 2.1 - Manipulating Data
    • Unit 2.2 - Functions and Formulas
  • Section 3: Charts and Graphs
    • Unit 3.1 - Charts and Graphs
  • Section 4: Lookups
    • Unit 4.1 - Lookups
  • Section 5: Pulling Data from a Spreadsheet
    • Unit 5.1 - Using ImportXML
    • Unit 5.2 - Using ImportHTML
  • Section 6: Using Macros and Other Tools
    • Unit 6.1 - Macros
    • Unit 6.2 - Tools to Use with Google Docs
  • Section 7: Course Ending
    • Unit 7.1 - Templates and Resources
  • Unit 7.2 - Conclusion
SGD $49.60
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.