Share
Go down
Admin
Posts : 6
Join date : 2018-08-07
View user profilehttp://msbelds.forumotion.asia

Google Sheets

on Wed Aug 08, 2018 2:16 pm
Google Sheets makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. All for free.

What can you do with Sheets?
Handle task lists, create project plans, analyze data with charts and filters, and more.
With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.

Get a head start with templates
Choose from a wide variety of budgets, schedules, and other pre-made spreadsheets — all designed to make your work that much better, and your life that much easier.

1. Create or import
To start, you need a new or existing spreadsheet.

  • 1.1. Create a new spreadsheet

Choose an option:
   

  • From the Sheets homepage: Click Create new spreadsheet

.
   

  • From Google Drive: Click New > Google Sheets > Blank spreadsheet or From a template.


  • 1.2. Import and convert old spreadsheets to Sheets

If you have an existing spreadsheet you created in another program, you can easily import and convert it to Sheets.
   1.Go to Drive.
   2. Click  + New> File Upload.
   3. Choose the existing spreadsheet from your computer to add it to Drive. Supported files include .xls, .xlsx, .xlt, .ods, .csv, .tsv, .txt, and .tab.
   4. In Drive, right-click the spreadsheet you want to convert.
   5. Select Open with and choose Google Sheets.

When you convert your spreadsheet from another program, a copy of your original file is created in the Sheets format. You can then edit it in your browser as you would with any other Sheet.

2. Add content
Now that you have a spreadsheet open, you can start working in it. Sheets automatically saves every change you make.

  • 2.1. Enter and edit your data

   1. Rename your spreadsheet: Click Untitled spreadsheet and enter a new name.
   2. Enter text or data: Click a cell and enter text.
   3. Insert more items: Click Insert and add charts, images, drawings, functions, notes, and more.
Note: To see which functions are available, see the Google spreadsheets function list.

  • 2.2. Customize formats and fonts

In your spreadsheet, select the cells you want to customize, then use the menus and toolbar to change their formats.

  • 2.3. Work with rows, columns, and cells

   1. Add rows, columns, and cells—Select a cell or block of cells. Then, on the menu bar, click Insert and choose where to add the row, column, or cells.
   2. Delete or hide rows and columns—Right-click the row number or column letter and select Delete or Hide.
   3. Delete a cell or a block of cells—Select the cells you want to delete. Click Edit > Delete cells and shift up, or Edit > Delete cells and shift left.
   4. Move rows and columns—Click the row number or column letter to select it. Then, drag it to a new location.
   5. Freeze header rows and columns—Keep some data in the same place as you scroll through the rest of your spreadsheet. On the menu bar, click View > Freeze and choose an option.

Share and collaborate
Share your spreadsheet with your team, or people outside your company. People can make changes at the same time, and you can see their changes as they happen.
Share spreadsheets
Share a file you own or can edit:

   1. Open the file you want to share.
   2. Click Share.
   3. Enter the email addresses or Google Groups you want to share with.
   4. Choose what kind of access you want to give people:
       Can edit—Collaborators can add and edit content, and add comments.
       Can comment—Collaborators can add comments, but not edit content.
       Can view—Collaborators can view the file, but not edit content or add comments.
   5. Click Send.

   Everyone you shared with will receive an email with a link to the spreadsheet.


Have you tried using Google Sheets?
What do you think of Google Sheets?
Guru
Guru
Posts : 10
Join date : 2018-08-09
View user profile

Re: Google Sheets

on Thu Aug 09, 2018 10:41 am
can someone enlighten me about this topic?
Guru
Guru
Posts : 10
Join date : 2018-08-11
View user profile

Re: Google Sheets

on Sat Aug 11, 2018 9:18 am
Can you show me how to use it in actual? Im not familiar in google sheet
Guru
Guru
Posts : 10
Join date : 2018-08-11
View user profile

Re: Google Sheets

on Sat Aug 11, 2018 9:20 am
Who invented google sheet?
Guru
Guru
Posts : 10
Join date : 2018-08-11
View user profile

Re: Google Sheets

on Sat Aug 11, 2018 9:20 am
Google sheet's invertor is the same inventor of google docs and slide?
avatar
Guru
Guru
Posts : 30
Join date : 2018-08-11
View user profile

Re: Google Sheets

on Sat Aug 11, 2018 8:53 pm
Ano po gagawin dyan
avatar
Guru
Guru
Posts : 30
Join date : 2018-08-11
View user profile

Re: Google Sheets

on Sat Aug 11, 2018 8:54 pm
This is very interesting topic
Guru
Guru
Posts : 10
Join date : 2018-08-09
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 2:45 pm
i really dont know how to use this
Guru
Guru
Posts : 10
Join date : 2018-08-09
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 2:46 pm
what if i dont have a google drive ?
Guru
Guru
Posts : 12
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 3:04 pm
ano pinag kaiba nyan sa excel ?
Guru
Guru
Posts : 12
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 3:05 pm
onine apps po ba sya or offline ?
Guru
Guru
Posts : 12
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 3:09 pm
mga ginagawa sa excel kaya din ba dito ?
Guru
Guru
Posts : 12
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 3:09 pm
Sino po may alam about sa google sheets ?
Guru
Guru
Posts : 12
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 3:09 pm
turuan nyo po ako thankyou
Guru
Guru
Posts : 10
Join date : 2018-08-09
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 6:17 pm
This contain many features that helps every individual to have easier input of data
Guru
Guru
Posts : 10
Join date : 2018-08-09
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 6:26 pm
This is somewhat similar to Excel coz they have similarities in terms of some functions
Guru
Guru
Posts : 10
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 6:47 pm
[quote="Spiky"]Who invented google sheet?[/quote

Sam Schillace and the whole google work for this
Guru
Guru
Posts : 10
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 6:50 pm
quiroz_maryann wrote:This is somewhat similar to Excel coz they have similarities in terms of some functions

Its a battle of microsoft and google thats why it invented with the same function
Guru
Guru
Posts : 10
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 6:50 pm
ano ba mas reliable gamitin EXCEL from Microsoft or GOOGLE : GOOGLE SHEETS
Guru
Guru
Posts : 10
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 6:51 pm
siriban_rudolf wrote:Sino po may alam about sa google sheets ?

make some research or read the lesson to understand it
Guru
Guru
Posts : 10
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 6:52 pm
Spiky wrote:Google sheet's invertor is the same inventor of google docs and slide?

its all invented of GOOGLE when there is a google name
Guru
Guru
Posts : 10
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 6:52 pm
[quote="salazar_princess"]can someone enlighten me about this topic?[/quote

I think the lesson is enough to enlighten you
Guru
Guru
Posts : 10
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 9:50 pm
Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.
Guru
Guru
Posts : 10
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 9:56 pm
Google Sheets makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks.
Guru
Guru
Posts : 10
Join date : 2018-08-12
View user profile

Re: Google Sheets

on Sun Aug 12, 2018 9:57 pm
Share your spreadsheet with your team, or people outside your company.
Sponsored content

Re: Google Sheets

Back to top
Permissions in this forum:
You cannot reply to topics in this forum