Google Workspace Series: Google Sheets

Google Workspace, offered by Google, provides a full suite of tools that allows individual and businesses to use tools similar to Microsoft Word, Excel, Powerpoint, etc. Google Workspace lives in the cloud and is accessible from most devices that are internet connected. You can be on your computer, tablet, and phone all at once. This also makes Google Workspace highly collaborative. Multiple users can work on the same document simultaneously in real time communication. Because all your work lives in the cloud, you never have to back it up or worry about finding previous versions.

The Google Workspace Series offers an overview of the tools associated with GSuite with an option to become GSuite Certified.

Items to be covered;

Working in Sheets

Managing values, rows, cells, or columns

• Adding
• Deleting
• Freezing
• Inserting

Formatting sheets and cells. Considerations include:

• Bolding and italicizing
• Merging cells
• Text wrapping
• Fill color
• Borders
• Data validation
• Alignment
• Fonts
• Font size
• Date formats
• Currency
• Adding, deleting, copying, copy to…, and renaming sheets

Inserting non-text elements. Elements include:

• Charts
• Images
• Links
• Forms
• Drawings

Using functions. Basic tools and functions include:

• SUM
• AVERAGE
• MIN
• MAX
• COUNT

Managing and transforming data. Considerations include:

• Conditional formatting
• Naming, sorting, and protecting sheets and ranges
• Creating filters and filter views
• Protecting sheets
• Creating and modifying charts

Collaborating and sharing in Sheets. Considerations include:

• Comments
• Revision history
• Download as

Importing and converting from other file types. File types include:

• .csv
• .xls

Additional Information

Online with at Google Meet

Platforms Covered: PC, Mac, Linux, Chrome OS

Course Requirements: A computer & Google Account. If you do not have a Google account, you may register for a FREE Google account at THIS LINK to register.

About the DigitalBridge

DigitalBridge is a social venture to accelerate America’s diverse digital talent and create economic opportunity.

Rooted in digital equity, DigitalBridge offers career coaching, digital training, access to affordable devices, and job matching. Open to all skill levels, we train people looking to start a digital career, advance in a current career, or want to learn digital skills for everyday life.

About the DigitalBridge & Connected Communities

From basic to advanced, DigitalBridge offers free training tailored to your personal goals while connecting you with remote and in-person careers.

The DigitalBridge provides free Digital Skills Training for individuals looking for new/better jobs and businesses who need to upskill their new and existing employees to meet their workforce needs.

CREATING AN EQUITABLE DIGITAL ECONOMY

Connected Communities is creating a new and equitable digital economy through high-speed, open-access broadband networks, digital skills training, and job pairing in underserved communities through local, regional, and national cross-sector partnerships.

Contact Us

General: info@mydigitalbridge.org

Dubois Campus, Wake Forest, North Carolina

e. Dubois@MyDigitalBridge.org

p. (919) 246-5700 ext 2

Grand County Campus, Grand County, Colorado

e. GrandCounty@MyDigitalBridge.org

p. (970) 281-4411

Visit Us Online and Register to learn for FREE

Webstie: https://mydigitalbridge.org