Course Content

Google Spreadsheets

1. Introduction to Google Sheets

Why do you need Google Sheets?Creating Google Sheets Opening Google Sheets Renaming Google Sheets Copying Google Sheets Deleting Google Sheets Moving Google Sheets Downloading Google Sheets

2. Formatting of Cells and Ranges

Basic Editing Operations Formatting Data Working with Fonts Formatting Text and Filling with Color Formatting Borders Merging Cells and Text Alignment Clear Formatting and Paint Format Tools Selecting Cells and Ranges Adjusting Column and Row Size and Position Copying and Deleting Columns and Rows Freezing and Grouping Rows and Columns

3. Advanced Formatting of Cells

Splitting Text to Columns Trimming Whitespaces Inserting Internal and External Hyperlinks Autocompleting Cells Creating Checkboxes Creating Forms Adding Notes Adding Images Creating Drawings Challenge: Mastering Event Planning Challenge Challenge: Your Event, Your Plan

4. Sorting, Filtering and Cleaning Data

Find and Replace Sorting Range Searching Filter and Filter by Condition Custom Filter Views Conditional Formatting and Color Scale Using Slicers Named Range Removing Duplicates Challenge: Library Book List Management

5. Creating Charts

Line Chart Basic Chart Settings Chart Style and Chart and Axis Titles Legend, Gridlines and Ticks Horizontal and Vertical Axis Customization Area Chart Columns and Stacked Columns Pie Chart Challenge: Data Visualization Sprint Sales Insights

6. Basic Functions

Basic Calculations Arithmetic Functions Statistical Functions Rounding Functions Working with Numbers and Integers Working with Roots and Powers Random Number Generation Text Functions Working with Dates and Time Sort Function Challenge: Sales Visualization Trends and Analytics

7. Logical Functions

AND and OR Functions IF and Nested IF Functions IFS Function SUMIFS, COUNTIFS and AVERAGEIFS Challenge: Employee Performance and Payroll Analysis with Excel Functions

8. Collaboration and Security

Access Control and Real-Time Document Collaboration Notification Rules Chatting with Other Users Protecting Sheets and Ranges Comments and Google Meet Integration Version History and Data Recovery

Formatting Data

Formatting as Currency

Formatting data as currency adds a currency symbol and displays the number with two decimal places.

Select the cell or range of cells you want to format;
On the toolbar, click the Format as currency icon (with a dollar symbol).

If a cell contains 1234.56, it will display as $1,234.56 after formatting as currency.

Formatting as Percent

Formatting data as a percentage multiplies the cell value by 100 and adds a percentage sign.

Select the cell or range of cells to format;
On the toolbar, click the Format as percent icon (with a percent symbol).

If the cell contains 0.25, it will display as 25.00% after formatting as a percentage.

Increasing and Decreasing Decimal Places

You can adjust the number of decimal places displayed using the Increase and Decrease Decimal Places options.

To modify decimal places, first select the cell or range of cells. If you want to reduce the decimal places and display numbers with less precision, click Decrease decimal places (icon with a left arrow and zero). For example, if the cell shows 123.456 and you decrease decimal places to 1, it will display as 123.5.

To increase decimal places and display numbers with greater precision, click Increase decimal places (icon with a right arrow and two zeros). For instance, if the cell shows 123.5 (originally 123.456 with decreased decimals) and you increase decimal places, it will return to 123.456.

Accessing More Formats

Explore additional formats to display cell data, providing more options than standard formats.

Select the cell or range to format;
In the top menu, go to Format → Number;
Alternatively, click the 123 icon in the top menu.

Plain Text

Formats data as plain text. If a cell contains a number, it will convert to text format, displaying as written. For example, if a cell contains the number 1234.56, formatting as plain text will keep it as 1234.56 without numeric formatting.

Number

Formats data as a number with two decimal places and thousand separators. For instance, if a cell contains 1234.56789, formatting as a number might display it as 1,234.57 (with two decimal places).

Scientific

Formats data in scientific notation, displaying numbers as a product of a value between 1 and 10 and a power of 10. For example, if a cell contains 1234567890, scientific notation might display it as 1.23E+09.

Date Time

Formats data to display both date and time. For instance, if a cell displays 1:45:30 PM, formatting as date and time might show it as 1/2/2024 13:45:30.

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 2