Free ebookCreation of Electronic Spreadsheets with complete Google Sheets

Introduction to Google Sheets

Basic Concepts and User Interface

Google account setup

Creating a new spreadsheet

Understanding cells, rows and columns

Inserting and formatting text

Entering and manipulating numbers

Using and customizing cell styles

Creating and using basic formulas

Creating and Using Basic Formulas: Getting Started with Google Sheets

Creating and using basic formulas: Entering and formatting data

Creation and use of basic formulas: Use of basic arithmetic formulas (addition, subtraction, multiplication, division)

Creating and using basic formulas: Cell references (relative, absolute and mixed)

Creation and use of basic formulas: Basic functions (SUM, AVERAGE, MINIMUM, MAXIMUM, COUNT.NUM)

Creating and using basic formulas: Using conditional formulas (IF)

Creating and using basic formulas: Working with dates and times

Creation and use of basic formulas: Use of text functions (CONCATENATE, LEFT, RIGHT, SEARCH)

Creation and use of basic formulas: Handling errors in formulas (IFERROR, ERRORS)

Creating and Using Basic Formulas: Naming Ranges to Simplify Formulas

Creating and using basic formulas: Creating custom formulas with Google Scripts

Use of common functions (SUM, AVERAGE, etc.)

Using common functions (SUM, AVERAGE, etc.): Introduction to basic functions

Using common functions (SUM, AVERAGE, etc.): Using the SUM function

Using common functions (SUM, AVERAGE, etc.): Calculating averages with the AVERAGE function

Using common functions (SUM, AVERAGE, etc.): Counting cells with the COUNT function

Using common functions (SUM, AVERAGE, etc.): Applying the MAX function to find the largest value

Using common functions (SUM, AVERAGE, etc.): Finding the smallest value with the MINIMUM function

Using common functions (SUM, AVERAGE, etc.): Using the IF function for conditional logic

Use of common functions (SUM, AVERAGE, etc.): Concatenation of strings with the CONCATENATE function

Using common functions (SUM, AVERAGE, etc.): Conditional formatting using functions

Using common functions (SUM, AVERAGE, etc.): Working with dates and times using functions

Using common functions (SUM, AVERAGE, etc.): Using rounding functions: ROUND, ROUND.UP, ROUND.DOWN

Use of common functions (SUM, AVERAGE, etc.): Manipulation of texts with functions such as LEFT, RIGHT and EXT.TEXT

Use of common functions (SUM, AVERAGE, etc.): Use of search and reference functions: VLOOKUP, HLOOKUP and INDEX

Use of common functions (SUM, AVERAGE, etc.): Use of logical functions: AND, OR and NOT

Using common functions (SUM, AVERAGE, etc.): Creating nested and combined formulas

Using common functions (SUM, AVERAGE, etc.): Common errors in functions and how to solve them

Relative and absolute references in formulas

Conditional formatting

Conditional Formatting: Introduction to Conditional Formatting

Conditional Formatting: Apply Formatting Rules Based on Numeric Values

Conditional Formatting: Use Conditional Formatting with Formulas

Conditional Formatting: Format Cells Based on Comparison to Other Cells

Conditional Formatting: Using Colors and Styles in Conditional Formatting

Conditional Formatting: Conditional Formatting Based on Dates

Conditional Formatting: Applying Conditional Formatting to Texts and Strings

Conditional Formatting: Use Conditional Formatting to Highlight Duplicates

Conditional Formatting: Creating Data Bars and Thumbnail Charts

Conditional Formatting: Manage and Remove Conditional Formatting Rules

Conditional Formatting: Best Practice Tips for Conditional Formatting

Conditional Formatting: Sharing and Collaboration in Spreadsheets with Conditional Formatting

Data organization and filtering

Advanced data classification

Importing data from other sources

Text and date functions

Financial and commercial functions

Using range names to make formulas easier to understand

Creating pivot tables

Data visualization with graphs and tables

Visualizing data with graphs and tables: Types of graphs available in Google Sheets

Visualizing data with graphs and tables: Inserting graphs into a spreadsheet

Data visualization with graphs and tables: Customizing graphs (colors, legends, axes)

Data visualization with graphs and tables: Using pivot tables for data analysis

Visualizing data with charts and tables: Conditional formatting to highlight data

Data visualization with graphs and tables: Creating interactive dashboards

Data Visualization with Charts and Tables: Trend Analysis with Line Charts

Visualizing Data with Charts and Tables: Comparing Datasets with Bar and Column Charts

Visualizing data with graphs and tables: Representing proportions with pie charts

Visualizing data with graphs and tables: Using histograms for frequency distribution

Visualizing Data with Charts and Tables: Creating Scatter Plots for Data Correlation

Data visualization with graphs and tables: Adjusting scales and intervals of graph axes

Data visualization with graphs and tables: Inclusion of mini graphs or sparklines

Visualizing data with graphs and tables: Export graphs for use in presentations or reports

Data Visualization with Charts and Tables: Sharing and Collaborating on Charts and Tables

Fine-tuning graphics

Logical and search functions (IF, VLOOKUP, etc.)

Connection to Google Forms

Spreadsheet security and sharing

Version management and revision history

Creation of interactive dashboards

Use of scripts and Google Apps Script

Keyboard shortcut tips

Troubleshooting and debugging errors

Google Sheets Integration with Other Apps

Automating repetitive tasks with macros

Advanced use of filters and data validation

Customizing menus and interfaces with UI Builder

Creating custom forms within Google Sheets

Best practices for structuring data

Use of extensions and add-ons

Practical applications for business and personal finance

Tips to increase productivity

Creation of an integrative final project

Conclusion and next steps for further development