• Post category:StudyBullet-7
  • Reading time:7 mins read


Google Sheets Basics for Beginners

What you will learn

Knowledify with the fundamentals of Google sheets i.e Explore the Google Sheets interface.

Learn how to identify text and numeric data.

Learn about using formulas in Google Sheets, including syntax, operators, entering formulas, and copying and pasting formulas.

Explore various ways to enter functions.

Utilizing the named ranges

Working with absolute cell references, calculating percentages

Learn about charts in Google Sheets

Description

Hello everyone, Welcome to the course! I am thrilled to have you on board. You’re going to be a valuable asset, and I can’t wait to see all that you accomplish. If you are a novice looking to learn the fundamentals of Google Sheets at a manageable pace, this beginner-level Google Sheets MasterClass is a great starting point. Not only will you learn the basic features, but also other tips and tricks to improve your workflow.

Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your deskโ€”or from your smartphone or tablet on the goโ€”Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, youโ€™ll learn how to make your own supercharged spreadsheets, incorporating powerful functions and visualizations to accelerate your data analysis and share meaningful insights with your team. Follow along with exercises and a companion spreadsheet to practice new skills as you encounter them.

This course is designed to teach the student the fundamentals of Google Sheets. Students will learn how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Sheets. Additionally, students will learn how to format spreadsheets, manipulate columns and rows. Students will also learn how to create and format charts, and insert graphics and images.


Get Instant Notification of New Courses on our Telegram channel.


In this course, you will learn how both the basics of using spreadsheets with Google Sheets and more advanced features such as using functions to create dynamic spreadsheets that reference data from across multiple sources and generate visual representations of what you have with pie charts and trend lines.

By the time you’re done with this course, you’ll have full confidence in most things that require you to use Google Sheets. In situations that require something beyond your current skill level, you will have the tools needed to acquire the knowledge necessary without feeling overwhelmed.

Alright !ย so Let’s dive in !! Happy Learning

English
language

Content

Getting Started with Google Sheets

Introduction
Setup of Google Sheets
Toolbar and Application Menu
Basic Vocabulary

Entering Data

Entering Data into Cells
Selecting Multiple Cells
Selecting Rows & Columns
Adding Rows & Columns
Resizing Rows & Columns
Moving and Manipulating
Deleting and Clearing
Freezing Rows & Columns

Formula Basics

Grouping
Grouping the other way
Hiding
Merging Cells
Setup way 2
Protecting Ranges
Range Select Syntax
Selecting Rows and Columns

Formatting a Spreadsheet

Permissions and Protections
Special Paste & 2 sheets
Filling the second sheet
Renaming Sheets
Copying Duplicate Sheets
Formatting Numbers
Custom Date & Time Formats
Custom Currencies
Right to Left Readings
Spreadsheet Settings

Working with Graphics

Inserting Images
ALT Text
Images over Cell

Basic Functions

Math Functions
Refining Cells in Functions
Nesting Functions
Functions Bar Sizing
Calculating Averages
Using Means or Medians
IF Statements
Adding IFS to profiles
Comparing
Using the FUNCTION Button
Copy & Paste
Intro to Comparing Strings
The inverter NOT
Sorting
Filtering by Values
Saving Filter Views
Resorting things Out
Dropdown List
Conditional Format
Conditional Format part 2
Deleting Conditional Format
Split Columns
Removing Duplicates
Trimming Whitespace
Checkboxes