Google Sheets for Excel Users

COURSE OUTLINE:

Description Google Spreadsheet is a program used to do math operations and layouts in columns, and rows, with cells running in a web browser. The layout is similar to other spreadsheet programs performing the most common functionality. This class will focus on learning the commands, functions, navigation, and operational features used to be more effective. The topics to be covered are open, save, close, upload, download, export, printing, formula bar, editing, delete cells, rows, columns, format, resizing cells, formulas, multiple sheets, name ranges, sheet protection, data validation, conditional formatting, freezing cells, gadgets, charts, sorting, and functions such as sum, average, min, max, count, if and vlookup.

RELATED COURSES

Desktop Applications
Google

Using Google G Suite – Productivity Tools

Google G Suite support both real-time and asynchronous collaboration. In this course, you will learn the capability of Google productivity applications and work within the Google Apps environment.

Desktop Applications
Google

Google Calendar – Virtual Training

Google Calendar is used keep you organized and can be synchronized with mobile devices. You can view your calendar from your desk, on the road, at home and on your mobile phone, even when you’re offline. It has all the features you would expect from a calendar program. The specific topics to be covered are changing views, add events, private or public security, supports different time zones, search feature, format events displayed, invite others, receive invitations, create new calendars, and share calendars.

Virtual classes are interactive training sessions delivered in real-time via the Web.

Desktop Applications
Google

Google Sharing Docs – Virtual Training

Google Docs includes the office suite of applications including Documents, Spreadsheets, and Presentation. The Google Docs interface allows you to load, save, rename, and share these applications. There are no application compatibility issues because everyone is on the same application version. Each application can be shared with anyone in the world and documents can be simultaneously edited. Google Docs represents an evolution in the way documents are shared which represents the term â€œCloud Computing.â€ The level of versatility is a paradigm shift by storing and sharing files. The specific topics to be discussed are defining the shared rights, private rights, editor rights, viewing, concurrent editing, working with folders/labels, delete a file, rename a file, trash Box, deleting saved file, import/export process, upload, publish, hiding documents, and changing owners.

Virtual classes are interactive training sessions delivered in real-time via the Web.

Desktop Applications
Google

Google Presentation – Virtual Training

Google Presentation is a program used to present information to a group and presentation development is done in a web browser. Furthermore, its capability is very similar to other presentation programs. This class will focus on learning the commands, navigation, and operational features used to create a document. The topics covered are open, save, close, upload, download, export, print, insert/delete, using layouts, adding text, selection, cut/paste, format, bullets, backgrounds, inserting images, shapes, drawing objects, tables, video, and speaker notes.

Virtual classes are interactive training sessions delivered in real-time via the Web.