To create a new spreadsheet in Google Sheets, go to Google Sheets and click on the “+ Blank” button or choose a template from the gallery. Once your spreadsheet is open, you can enter data into cells and use various formatting options to organize and present your information. To format cells, select the range of cells you want to format, then use the toolbar options to adjust font size, style, color, and alignment. You can also apply conditional formatting by going to “Format” > “Conditional formatting,” allowing you to highlight cells based on specific criteria. Additionally, you can use the “Data” menu to sort and filter your data for better organization.

Google Sheets provides a wide range of formulas and functions to perform calculations and manipulate data. To use a formula, click on the cell where you want the result to appear and type “=” followed by the function name (e.g., =SUM, =AVERAGE, =IF) and the necessary arguments within parentheses. For example, =SUM(A1:A10) calculates the total of the values in cells A1 through A10. Google Sheets supports functions for arithmetic operations, statistical analysis, text processing, and more advanced data manipulation tasks. Use the “Function” button or explore the “Help” menu for a list of available functions and their descriptions.

To collaborate and share a Google Sheets document, click the “Share” button in the top-right corner of the sheet. Enter the email addresses of the people you want to share with and choose their access level: “Viewer,” “Commenter,” or “Editor.” You can also generate a shareable link with specific permissions to control who can access the document. Once shared, collaborators can view, comment on, or edit the sheet in real-time, depending on their permissions. Google Sheets also features a built-in chat function for discussing changes and a comment feature for providing feedback directly within the sheet. Use the “Version history” (found under “File” > “Version history”) to review past versions and track changes made by collaborators.