How To Get Started With Google Sheets

#GSuite #HowTo #GetStarted #GoogleSheets #GSuiteForBusiness #AaronPteLtd #GoogleForEducation Aaron Private Limited is Google Cloud Partner https://cloud.withgoogle.com/partners/detail/?id=aaron-private-limited Website http://aaron.sg/ Facebook https://www.facebook.com/AaronPteLtd Instagram https://www.instagram.com/aaronpteltd/

0:00 Introduction 0:08 What is Google Sheets? 0:44 Accessing Google Sheets 1:05 Creating a Google Sheet 1:34 Sorting and Organizing Data 2:20 Filtering Data 3:09 Editing a Google Sheet 3:45 Creating Charts and Graphs 4:28 Sharing a Google Sheet

✅ What is Google Sheets? Google Sheets allows you to collect, sort, analyze and manipulate data in meaningful ways. With built-in formulas, formatting tools, and easy to create charts and graphs, Google Sheets is a powerful data analysis tool. Sheets allows multiple people to collaborate in real time. Changes and edits are instantaneous and everything is saved automatically.

✅ Accessing Google Sheets To get started, sign in to your Google account. Then go to sheets.google.com

✅ Creating a Google Sheet To create a new Google Sheet, click the colourful plus square. In this example, we’ll go through how simple it is to create a student grade Sheet. First, in Cell A1 through A4, enter the name of your students. Next, in Cell B1 through B4, enter grades into the empty cells next to each student.

✅ Sorting and Organizing Data To organise this data, hover your mouse over the head of column A and a drop down arrow will appear. Click the arrow and find the arrow for “Sort Sheet A through Z” or “Z through A”. This will only affect the data you’ve selected. The table now shows grades for each student, sorted alphabetically. To get a grade average for a Group of Students, highlights cells B1 through B4 and click the sigma icon on the far right of the toolbar. Choose average and hit enter, the grade average will appear below the last cell you highlighted.

✅ Filtering Data Want to filter out certain data? For example, you might want to only show students who received a certain grade, and you can use the filter to do just that. First highlight the cells containing student grades and click the filter button in the toolbar. Then click the new Filter icon at the top of the first cell to see the option to filter data. In this example, we are filtering out any grade below 90 using the “Greater than or equal to” option. To stop filtering data, just click the Filter button again and clear the settings.

✅ Editing a Google Sheet Just like a Google Docs and Slides, you can change fonts, text size and text colour in Google Sheets. On the left side of the toolbars, you’ll see options for editing numbers. You can format number as currency, percentage, d ... https://www.youtube.com/watch?v=LYiJcW9WyXk