INTRODUCTION OF GOOGLE SHEETS templates that cater to different needs

such as budgeting, project

Google Sheet- is a spreadsheet application and management, or scheduling
part of the free, web-based Google Docs Editors 2. Accessing Google Sheets: To create a
suite offered by Google. new Google Sheet, visit
Spreadsheet- is a layout of information sheets.google.com or open Google
arranged in row and columns in a table. Drive, click on "New," then select
Spreadsheets are often used to organize "Google Sheets."
information. 3. Naming Your Sheet: At the top left,
click on "Untitled spreadsheet" to
Common Terms use in Google sheet rename your sheet. This helps in easily
identifying your files later.
 Rename sheet
 Menus Navigating Google Sheet Interface
 Column Labels (letters) e.g. Column E-
1. Toolbar: The top toolbar includes
are vertical (run up and down). It is
essential functions like formatting,
identified by unique letter, beginning
inserting charts, creating formulas, and
with A-Z, then comes AA, AB, etc.
sharing the sheet with others. Hovering
 Row Labels (numbers) e.g. Row 10- are
over icons reveals tool tips explaining
horizontal (run across left-right). It is
their function.
identified by a number and could be up
2. Rows and Columns: Sheets are
to millions of rows.
organized into rows(horizontal) and
 Cell at intersection of column- are the
columns(vertical). Cells are the
spot where a row and column meet.
individual boxes where you enter data,
They are named by using the column
and each has a unique reference based
letter and row number (it's important
on its row and column (e.g., A1, B2).
to always follow this order). If it has a
3. Sheet Tabs: At the bottom, you'll find
border around the cell, then we call it
tabs for different sheets within the
an ACTIVE cell. When you start typing,
same file. You can add new sheets,
you will see what you type in this cell.
rename, or duplicate existing ones by
 Range
right-clicking the tab.
 Formula Bar- you can use this to type
4. Formula Bar: Directly beneath the
text or numbers; but mostly used to
toolbar, the formula bar displays the
type in formulas or functions. The fx
content or formula of the selected cell,
stands for function.
making it easy to edit data or apply
 Workbook
functions.
Creating a New Google Sheet
Collaborating in Real Time Using Google Sheets
1. Starting from Scratch: Once in the
-The core of real-time collaboration in Google
Sheets interface, you can start with a
Sheets lies in its cloud-based nature. When you
blank sheet or choose from a variety of
create or open a spreadsheet, it's stored on
Google's servers, allowing multiple users to warning or restrict who can
access and edit it concurrently. edit the content.
iii. Click Done.
Key Features for Real-Time Collaboration
6. Limit sharing options
1. Share spreadsheet
i. At the top of the spreadsheet,
Viewer: Can only view the spreadsheet. click Share.
Commenter: Can view and add ii. At the bottom, click Advanced.
comments. iii. Check the Disable options to
download, print, & copy for
Editor: Can view, edit, and make commenters and viewers box.
changes to the spreadsheet. iv. Click Done.

Owner: Has full control over the 7. Visibility and Tracking- To see the
spreadsheet, including sharing Activity dashboard, at the top right, click
permissions and ownership transfer. Activity dashboard. If you don’t want your view
history to appear in the Activity dashboard, you
2. Add comments and assign tasks-
can change the privacy settings.
Leave comments on specific cells or
sections to provide feedback, ask HOW TO IMPORT DATA
questions, or highlight areas for
discussion. Collaborators can reply to Step 1: Click file and import data
comments, creating a thread for Step 2: Choose my drive
focused communication.
3. Revision History- Track all changes Step 3: Click the create new spreadsheet and
made to the spreadsheet, including select import file.
who made them and when. This allows
you to revert to previous versions if 4 WAYS TO EXPORT DATA
needed and provides a comprehensive 1. PRINT SPREADSHEET
audit trail of the document's evolution.
4. Email collaborators- Initiate a real-  To print your spreadsheet, click
time chat directly within the File>Print or click Print
spreadsheet to discuss specific issues  You can choose which sheets to print,
or collaborate on tasks. This allows for what features to include, and which
quick and efficient communication layout you want.
without leaving the document.
5. Protect content 2. DOWNLOAD- You can download your
i. Click Range to protect a range spreadsheet and open it in other programs.
of content or Sheet to protect 3. MAKE A COPY
a whole sheet.
ii. Click Set permissions and  Click File>Make a copy.
choose whether to show a
  (Optional) You can rename the copy, Most Common Basic Google Sheets Functions.
change where you save it in Drive, and
SUM: adds all the values in a cell range. For
share it with the same collaborators.
example, =SUM(D2:D11) in our spreadsheet
4. EMAIL AS ATTACHMENT would add up all the salary spent across cells D2
to D11.
 Open the spreadsheet and click
File>Email as attachment. AVERAGE: returns the average of a range of
 Select a format. cells. For example, =AVERAGE(D2:D11), the
 Enter the email addresses or groups you average salary would be 88,000.
want to send copies to.
COUNT: counts the number of cells in a given
 Add a message.
range that contain numbers. For example,
 Click Send.
=COUNT(D2:D11), the total number of
Tips and Best Practices for Using Google Sheets employees would be 10

 Keep It Organized- Use logical sheet MAX: returns the highest value in a cell range.
names, color coding, and formatting to For example =MAX(D2:D10), the highest salary
make your spreadsheet easy to would be 150,000.
navigate and understand at a glance.
MIN: returns the lowest value in a cell range.
 Automate Repetitive Tasks- Explore
For example, =MIN(D2:D10) the lowest salary
add-ons and custom scripts to
would be 70,000
automate workflows, generate reports,
and extend the capabilities of your Two Main Ways to use a Google Sheets
spreadsheet. Function.
 Leverage Keyboard Shortcuts- Master
common shortcuts like Ctrl+C to copy, 1. Enter the function name in the cell- The
Ctrl+V to paste, and Ctrl+S to save, easiest way to insert a function in a cell is to
saving you time and boosting enter the equal sign (=) immediately followed
productivity. by the function name. Google Sheets will
 Utilize Data Validation- Set up data autocomplete the function name and suggest
validation rules to ensure users input what data you should include in the function.
accurate, consistent data, reducing For example, when I enter =SUM in cell E12,
errors and improving data integrity. Google Sheets finishes the formula by
suggesting =SUM(E2:10). Google Sheets will
Basic Functions of Google Sheet also suggest a list of other related functions. To
accept the suggested formula, press Tab.
function is a predesigned formula that's built
into the app, whereas a Google Sheets formula 2. Choose from the Function menu
is any equation you come up with. Before you
spend time creating new formulas, it's helpful  Click the cell you want to enter the
to understand which functions are already function into.
available.  Click Insert, and then select Function.
 Click the function you want to use.
  Google Sheets will populate the Some of this data come from:
function in your cell, along with the
parentheses where you'll need to enter  Real Life Measurements
your argument—the information you  Google Form Surveys
want the formula to calculate. For  Public Datasets
example, in the formula =SUM(E2:E10),  Probes and Sensors
the argument E2:E10 tells Google
ART ACTIVITIES- Google Sheets can also be used
Sheets to add the values of cells E2 to
to create Pixel Art, where you make images out
E10.
of a small grid with limited number of colors.
ACTIVITIES IN GOOGLE SHEETS
DATA SORTING- in spreadsheets allows you to
CHARTS AND GRAPHS- Creating a graph or effortlessly organize your information, making it
chart in Google Sheets is a great way to more accessible and easier to understand. It
visualize and analyze data. It is an activity that helps you keep everything in order.
involves gathering the data you want to display,
PROJECT MANAGEMENT- Spreadsheet allows
inputting it into the appropriate columns and
you to make project management charts to
rows, and then using the built-in chart functions
keep track of a project progress and be
to visualize your data.
organized.
COLLABORATION- Allows multiple users to
TIMELINE- provides a visual representation of
work on the same spreadsheet in real-time,
the entire project, from start to finish, allowing
making edits, comments, and updates, while
everyone involved to understand the scope and
tracking changes and communicating within the
duration of each task or milestone.
document.
BUDGET AND EXPENSE TRACKER- provides a
QR CODES- Barcodes are a useful way to keep
clear picture of where your money is going,
track of things, like checking people in at an
allowing you to identify areas where you're
information session, conference or event. And
overspending or underutilizing resources.
you can quickly create QR codes in Google
Sheets. FORMULAS AND FUNCTIONS

DATA SUMMARIZATION- SUMIFS and Google Sheets supports a range of built-in

COUNTIFS can be a good option, as they allow functions for calculations and data
you to define multiple criteria. For example, you manipulation. These formulas can be basic or
could sum all numbers over a certain value or complex; however, the main aim of both is to
count the number of rows that contain a perform mathematical operations, simplify,
particular string or value. summarize, or categorize the data you select.

ANALYZING DATA- Users can use sheets for Mathematical Google Sheet Functions
what we usually call "crunching numbers. " It
means analyzing data relevant to their content =ADD( ~ Addition
area. =MINUS( ~ Subtraction
=MULTIPLY( ~ Multiplication 6. Click the green “Done” button to save
the changes.
=DIVIDE( ~ Division
FORMATTING OF SINGLE COLOR’S EXAMPLE
=SUM( ~ Summing
1. SPREADSHEET DETAILS- We can take a
=POWER( ~ Exponent / Power spreadsheet containing 20 students and
=SQRT( ~ Square Root the marks they achieved on the
Qualifying Exam.
Mathematical Google Sheet Operators 2. OBJECTIVE- Let’s say we wanted to
highlight students who got 85 or higher
Plus sign (+) ~ Addition
marks in the qualifying exam.
Minus sign (-) ~ Subtraction 3. ACTION TAKEN- We formatted the cells
so that the marks of the students who
Asterisk (*) ~ Multiplication scored 85 or higher were highlighted in
green.
Forward Slash (/) ~ Division
Color Scale Conditional Formatting
Caret (^) ~ Exponent
1. Click and drag to select the cells
READING LOG- Users can maintain detailed
containing the marks.
reading logs. Tracking their thoughts,
2. With the cells selected, click the
predictions, and connections to books, which
“Format” button in the main toolbar.
promotes deeper engagement with reading
3. There, click on “Conditional formatting”
materials.
in the dropdown menu.
FORMATTING OF GOOGLE SHEETS- is not just 4. Make sure the “Color scale” tab is
about aesthetics; it’s about transforming data selected.
into clarity and insight. 5. Now select the “Minpoint, Midpoint,
Conditional Formatting- Single Color & Color and Maxpoint” parameters.
Scale 6. Click the green “Done” button to save
the changes.

Conditional Formatting of Single Color TEXT FORMATING- Text formatting in a

worksheet is essential for ensuring readability
1. Click and drag to select the cells and organization. Clear headings, consistent
containing the marks. fonts, and appropriate text sizes help users
2. With the cells selected, click the quickly navigate and understand the
“Format” button in the main toolbar. information presented. Proper formatting also
3. There, click on “Conditional formatting” aids in visually organizing data, making it easier
in the dropdown menu. to differentiate between sections and identify
4. Choose in the “Format cells if” menu. key details.
5. Under the “Formatting style” options,
you can change the fill and text color
and text emphasis.
STEPS IN TEXT FORMATTING TYPES OF DATA VALIDATION

1. Select a cell or range of cells that you  List of items: Users must select from a
want to format. predefined list.
2. Go to the top menu bar and click on  List from a range: Users select from a
Format. range on the spreadsheet.
3. This will open a sub-menu with various  Number: Restrictions based on
text formatting options. numerical value, such as greater than,
4. Select a Format Option, then apply. less than, between, etc.
 Date: Limit input to date values, with
NUMBER FORMATTING- Number formatting in
options to restrict to a certain range.
Google Sheets is a feature that allows you to
 Text length: Ensures the input text
change the way numbers, dates, times, and text
meets a certain length requirement.
are displayed in your spreadsheet. It doesn't
 Custom formula: Creates complex
change the actual data in the cells, but it
conditions based on a custom Google
changes how the data appears. This can be
Sheets formula.
useful for financial reports, data analysis, and
presentation purposes
STEPS IN DATA VALIDATION
STEPS IN NUMBER FORMATTING
1. Select the cell or range of cells where
1. Click on the cell or range of cells that
you want to apply validation.
you want to format. You can also select
2. Go to the Data menu and choose ‘Data
entire rows or columns
validation
2. Go to the top menu bar and click on
3. The ‘Data Validation’ dialog box
Format.
appears
3. In the dropdown menu, hover over
4. Specify the criteria for validation:
Number. This will open a sub-menu
5. Provide instructions for input with an
with various formatting options.
optional custom input message
4. Select a Format Option.
6. Decide whether to show a warning or
5. Click on the format you want to apply.
restrict data entry entirely upon
The selected cells will now display the
violation of these rules. Then save
numbers in the chosen format.
STEPS IN TEXT WRAPPING
DATA VALIDATION- is a crucial feature in
Google Sheets that ensures the data entered 1. Select the cell or range of cells where
into cells meets specific criteria. This you want to wrap.
functionality is essential for maintaining 2. Go to the MENU and click FORMAT.
accurate and consistent data within a 3. Find “WRAPPING” and click “WRAP”
spreadsheet.
STEPS IN MERGING

1. Select the cells that you want to merge.

2. Go to the MENU and click FORMAT.
 3. Select the “MERGE CELLS” BUSINESS:
4. Choose the type of merge you want to
perform. 1. Financial Management: Spreadsheets are
widely used for budgeting, financial analysis,
forecasting, and tracking expenses, helping
SPREADSHEET businesses manage their finances effectively.

 It is a digital document or tool used to 2. Data Analysis and Reporting: Businesses use
organize, analyze, and store data in spreadsheets to analyze large amounts of data,
tabular form. generate reports, and make informed decisions
 Consist of a grid of c ells arranged in based on data-driven insights.
rows and columns, where each cell can
3. Inventory Management: Spreadsheets can
contain text, numbers, or formulas.
track inventory levels, manage orders, and
They are commonly used for tasks like
predict stock needs, which is crucial for supply
financial
chain management.
 calculations, data analysis, record-
keeping, and project management. 4. Project Management: They are useful for
planning and tracking project timelines, tasks,
Advantages of Spreadsheets
and resource allocation, ensuring projects are
EDUCATION: completed on time and within budget.

1. Data Organization and Analysis:

Spreadsheets help educators organize grades,
Disadvantages of Spreadsheets
attendance, and other student data efficiently.
This allows for easy analysis and monitoring of EDUCATION
student progress.
1. Complexity for Beginners: Spreadsheets can
2. Interactive Learning Tools: They can be used be overwhelming for students and educators
to create interactive lessons, quizzes, and unfamiliar with their functionalities, leading to
assignments, making learning more engaging errors in data entry and analysis.
for students.
2. Limited Scalability: For managing large
3. Resource Management: Spreadsheets assist amounts of data, spreadsheets may become
in managing educational resources, such as slow and unwieldy, making them less suitable
budgets for classroom materials, library for larger educational institutions.
inventories, and scheduling.
3. Risk of Data Loss: Without proper backups,
4. Collaboration: Multiple users can work on data stored in spreadsheets can be easily lost
the same spreadsheet simultaneously, due to file corruption or accidental deletion.
facilitating group projects and collaborative
learning activities. 4. Time-Consuming: Creating and maintaining
spreadsheets can be time-consuming, especially
when dealing with complex data sets.
 3. Data Storage and Organization
 DATA STORAGE
BUSINESS
•Simple data bases
1. Error-Prone: Human errors in data entry or •Storing and managing large amount of
formula creation can lead to significant informations
mistakes in financial analysis or reporting,  Organization
potentially impacting business decisions. •structured format

2. Limited Collaboration: While spreadsheets 4. Project Management

allow for collaboration, multiple users editing a
 Task List
file simultaneously can lead to version control
 Resource Allocation
issues and data conflicts.
 Progress Tracking
3. Security Concerns: Sensitive business data  Communication
stored in spreadsheets may be vulnerable to
5. Payroll Management
unauthorized access or breaches, especially if
not properly secured. WHY USE SPREADSHEET FOR YOUR PAYROLL
PROCESS?
4. Scalability Issues: As a business grows,
spreadsheets may become insufficient for  COLLECTING AND TRACKING OF
managing large-scale data, requiring more EMPLOYEE DATA
robust software solutions like databases or ERP  VISUAL PRESENTATION
systems.  ACCURACY
 BASIC SALARY PER CUT OFF
 OVERTIME PAY
6 USES OF SPREADSHEET IN BUSINESS  INCOME TAX (10%)
 SSS PREMIUM (7%)
1. Inventory Management
 PHILHEALTH (3%)
 Cost effective
 TOTAL LOANS AND DEDUCTION
 Forecasting and Planning
 NET PAY
 Collaboration
 Flexibility and Ease of Use 6. Academic Help- Students schedule,
2. Financing and Accounting- present budget, grade book
financial report in a clear and organize
manner, it save us time, accuracy