Free ebook on Google Sheets: create spreadsheets, formulas, charts, dashboards, automation, sharing, and data analysis.
Free ebook + audiobook content
-
1. Introduction to Google Sheets
+ Exercise: Which of the following statements is true about Google Sheets, according to the text provided?
-
2. Basic Concepts and User Interface
+ Exercise: Which of the following is NOT an element of the Google Sheets interface as described in the text?
-
3. Google account setup
+ Exercise: What is the initial step to start using Google Sheets?
-
4. Creating a new spreadsheet
+ Exercise: What is the first step to create a new spreadsheet in Google Sheets, as described in the text?
-
5. Understanding cells, rows and columns
+ Exercise: What is the function of a cell in Google Sheets?
-
6. Inserting and formatting text
+ Exercise: Which of the following statements about entering and formatting text in Google Sheets is true?
-
7. Entering and manipulating numbers
+ Exercise: Which of the following is a correct example of how to apply an absolute reference to a formula in Google Sheets, as described in the text?
-
8. Using and customizing cell styles
+ Exercise: In the chapter on using and customizing cell styles in Google Sheets, which of the following statements is true regarding the formatting capabilities this tool offers?
-
9. Creating and using basic formulas
+ Exercise: In Google Sheets, which of the following operators is used to perform the exponentiation operation in a formula?
-
9.1. Creating and Using Basic Formulas: Getting Started with Google Sheets
+ Exercise: Which of the following statements about using formulas in Google Sheets is true?
-
9.2. Creating and using basic formulas: Entering and formatting data
+ Exercise: Which of the following statements about creating and using basic formulas in Google Sheets is true?
-
9.3. Creation and use of basic formulas: Use of basic arithmetic formulas
+ Exercise: Which of the following statements about using formulas in Google Sheets is correct?
-
9.4. Creating and using basic formulas: Cell references
+ Exercise: Which of the following statements about cell references in Google Sheets is correct?
-
9.5. Creation and use of basic formulas: Basic functions
+ Exercise: Which of the following statements about using formulas in Google Sheets is true?
-
9.6. Creating and using basic formulas: Using conditional formulas
+ Exercise: What is the correct syntax for the IF function in Google Sheets?
-
9.7. Creating and using basic formulas: Working with dates and times
+ Exercise: Which of the following statements about working with dates and times in Google Sheets is true?
-
9.8. Creation and use of basic formulas: Use of text functions
+ Exercise: Which of the following statements about text functions in Google Sheets is correct?
-
9.9. Creation and use of basic formulas: Handling errors in formulas
+ Exercise: Which of the following statements about formula error handling in Google Sheets is true?
-
9.10. Creating and Using Basic Formulas: Naming Ranges to Simplify Formulas
+ Exercise: Which of the following statements about naming ranges in Google Sheets is true?
-
9.11. Creating and using basic formulas: Creating custom formulas with Google Scripts
+ Exercise: Which of the following statements about using Google Scripts in Google Sheets is true?
-
10. Use of common functions
+ Exercise: Which of the following statements about using functions in Google Sheets is correct?
-
10.1. Using common functions: Introduction to basic functions
+ Exercise: Which of the following correctly describes the "IF" function in Google Sheets?
-
10.2. Using common functions: Using the SUM function
+ Exercise: What is the correct syntax to use the SUM function in Google Sheets to sum the values in cells A1, B1, and C1?
-
10.3. Using common functions: Calculating averages with the AVERAGE function
+ Exercise: Which of the following statements about the AVERAGE function in Google Sheets is correct?
-
10.4. Using common functions: Counting cells with the COUNT function
+ Exercise: What is the purpose of the `COUNT` function in Google Sheets?
-
10.5. Using common functions: Applying the MAX function
+ Exercise: Which of the following statements about the MAX function in Google Sheets is true?
-
10.6. Using common functions: Finding the smallest value with the MINIMUM function
+ Exercise: What is the Google Sheets function described in the text that allows you to find the smallest value in a set of numbers?
-
10.7. Using common functions: Using the IF function
+ Exercise: What is the correct syntax for the IF function in Google Sheets, as explained in the text?
-
10.8. Use of common functions: Concatenation of strings with the CONCATENATE function
+ Exercise: Which of the following statements about functions in Google Sheets is correct?
-
10.9. Using common functions: Conditional formatting using functions
+ Exercise: Which of the following statements about using functions and conditional formatting in Google Sheets is correct?
-
10.10. Using common functions: Working with dates and times using functions
+ Exercise: Which of the following Google Sheets functions is used to calculate the difference in days between two dates?
-
10.11. Using common functions: Using rounding functions
+ Exercise: Which of the following statements about rounding functions in Google Sheets is correct?
-
10.12. Use of common functions: Manipulation of texts with functions
+ Exercise: Which of the following statements about using text manipulation functions in Google Sheets is correct?
-
10.13. Use of common functions: Use of search and reference functions
+ Exercise: Which of the following statements about the functions of Google Sheets is correct?
-
10.14. Use of common functions: Use of logical functions
+ Exercise: Which of the following statements about using functions in Google Sheets is true?
-
10.15. Using common functions: Creating nested and combined formulas
+ Exercise: Which of the following statements is correct about the use of functions in spreadsheets such as Google Sheets, as described in the text?
-
10.16. Using common functions: Common errors in functions and how to solve them
+ Exercise: Which of the following is a recommended solution to avoid Mistake #1: "Incorrect Cell References" in Google Sheets?
-
11. Relative and absolute references in formulas
+ Exercise: Which of the following statements about references in Google Sheets formulas is correct?
-
12. Conditional formatting
+ Exercise: Which of the following is a correct example of how conditional formatting can be used in Google Sheets?
-
12.1. Conditional Formatting: Introduction to Conditional Formatting
+ Exercise: Which of the following statements about conditional formatting in Google Sheets is true?
-
12.2. Conditional Formatting: Apply Formatting Rules Based on Numeric Values
+ Exercise: Which of the following statements about conditional formatting in Google Sheets is true?
-
12.3. Conditional Formatting: Use Conditional Formatting with Formulas
+ Exercise: Which of the following statements about using formulas in conditional formatting in Google Sheets is true?
-
12.4. Conditional Formatting: Format Cells Based on Comparison to Other Cells
-
12.5. Conditional Formatting: Using Colors and Styles
+ Exercise: Which of the following statements about conditional formatting in Google Sheets is true?
-
12.6. Conditional Formatting: Conditional Formatting Based on Dates
+ Exercise: Which of the following is NOT a correct step for setting up a date-based conditional formatting rule in Google Sheets?
-
12.7. Conditional Formatting: Applying Conditional Formatting to Texts and Strings
+ Exercise: Which of the following is NOT a way to apply conditional formatting to text and strings in Google Sheets?
-
12.8. Conditional Formatting: Use Conditional Formatting to Highlight Duplicates
+ Exercise: What is the purpose of using conditional formatting in Google Sheets, as described in the text?
-
12.9. Conditional Formatting: Creating Data Bars and Thumbnail Charts
+ Exercise: Which of the following steps is NOT correct to add data bars using conditional formatting in Google Sheets?
-
12.10. Conditional Formatting: Manage and Remove Conditional Formatting Rules
+ Exercise: What is the correct procedure for managing conditional formatting rules in Google Sheets?
-
12.11. Conditional Formatting: Best Practice Tips
+ Exercise: Which of the following is a recommendation for effectively using conditional formatting in Google Sheets, in accordance with the best practices mentioned in the text?
-
12.12. Conditional Formatting: Sharing and Collaboration
+ Exercise: Which of the following statements about conditional formatting in Google Sheets is true?
-
13. Data organization and filtering
+ Exercise: Which of the following correctly describes a step in the process of filtering data in Google Sheets?
-
14. Advanced data classification
+ Exercise: Which of the following is NOT a way to sort data in Google Sheets, as described in the text?
-
15. Importing data from other sources
+ Exercise: What is the correct function to import data from a table or list within an HTML page into Google Sheets?
-
16. Text and date functions
+ Exercise: Which of the following statements about text functions in Google Sheets is correct?
-
17. Financial and commercial functions
+ Exercise: Which of the following Google Sheets functions is used to calculate the interest amount on a given loan or mortgage payment?
-
18. Using range names to make formulas easier to understand
+ Exercise: Which of the following steps is NOT part of the process of naming ranges in Google Sheets as described in the text?
-
19. Creating pivot tables
+ Exercise: What is the first step to creating an effective pivot table in Google Sheets, as described in the text?
-
20. Data visualization with graphs and tables
+ Exercise: Which of the following is a best practice when creating data visualizations in Google Sheets?
-
20.1. Visualizing data with graphs and tables: Types of graphs available in Google Sheets
+ Exercise: Which of the following chart types available in Google Sheets is best suited for visualizing trends over time?
-
20.2. Visualizing data with graphs and tables: Inserting graphs into a spreadsheet
+ Exercise: What is the correct sequence of steps to insert a chart into a Google Sheets spreadsheet?
-
20.3. Data visualization with graphs and tables: Customizing graphs
+ Exercise: Which of the following statements about customizing charts in Google Sheets is true?
-
20.4. Data visualization with graphs and tables: Using pivot tables for data analysis
+ Exercise: Which of the following Google Sheets features allows you to rearrange, sort, count, or average data for analysis?
-
20.5. Visualizing data with charts and tables: Conditional formatting to highlight data
+ Exercise: Which of the following statements about conditional formatting in Google Sheets is true?
-
20.6. Data visualization with graphs and tables: Creating interactive dashboards
+ Exercise: Which of the following statements best describes the purpose of interactive dashboards in Google Sheets?
-
20.7. Data Visualization with Charts and Tables: Trend Analysis with Line Charts
+ Exercise: What is the main purpose of line charts in Google Sheets as described in the text?
-
20.8. Visualizing Data with Charts and Tables: Comparing Datasets with Bar and Column Charts
+ Exercise: Which of the following statements about bar and column charts in Google Sheets is true?
-
20.9. Visualizing data with graphs and tables: Representing proportions with pie charts
+ Exercise: Which of the following statements about pie charts is correct?
-
20.10. Visualizing data with graphs and tables: Using histograms for frequency distribution
+ Exercise: Which of the following statements about creating a histogram in Google Sheets is true?
-
20.11. Data Visualization with Charts and Tables: Creating Scatter Plots for Data Correlation
+ Exercise: What is the purpose of a scatterplot in Google Sheets, and how can you add a trendline to help interpret the data?
-
20.12. Data visualization with graphs and tables: Adjusting scales and intervals of graph axes
+ Exercise: How important is it to adjust the scales and axis ranges of charts in Google Sheets?
-
20.13. Data visualization with graphs and tables: Inclusion of mini graphs or sparklines
+ Exercise: Which of the following statements about creating Sparklines in Google Sheets is correct?
-
20.14. Visualizing data with graphs and tables: Export graphs for use in presentations or reports
+ Exercise: What is the correct procedure to export a chart as an image in Google Sheets?
-
20.15. Data Visualization with Charts and Tables: Sharing and Collaborating on Charts and Tables
+ Exercise: Which of the following statements about data visualization in Google Sheets is correct?
-
21. Fine-tuning graphics
+ Exercise: Which of the following is NOT mentioned in the text as an option to customize when fine-tuning charts in Google Sheets?
-
22. Logical and search functions
+ Exercise: Which of the following statements about the logic and search functions in Google Sheets is true?
-
23. Connection to Google Forms
+ Exercise: Which of the following features can be achieved by integrating Google Forms with Google Sheets?
-
24. Spreadsheet security and sharing
+ Exercise: Which of the following is NOT a best practice for sharing spreadsheets in Google Sheets?
-
25. Version management and revision history
-
26. Creation of interactive dashboards
+ Exercise: Which of the following is NOT a recommended step in creating interactive dashboards with Google Sheets, as described in the text?
-
27. Use of scripts and Google Apps Script
+ Exercise: Which of the following statements about Google Apps Script is true?
-
28. Keyboard shortcut tips
+ Exercise: What keyboard shortcut in Google Sheets moves the selection to the last cell with data in the worksheet?
-
29. Troubleshooting and debugging errors
+ Exercise: Which of the following error messages in Google Sheets indicates that a formula is trying to divide a number by zero?
-
30. Google Sheets Integration with Other Apps
+ Exercise: Which of the following is NOT an advantage of integrating Google Sheets with other applications, according to the text provided?
-
31. Automating repetitive tasks with macros
+ Exercise: What is the purpose of using macros in Google Sheets as described in the text?
-
32. Advanced use of filters and data validation
+ Exercise: In Google Sheets, which of the following is NOT advanced filtering or data validation functionality?
-
33. Customizing menus and interfaces with UI Builder
+ Exercise: Which of the following statements about customizing menus and interfaces in Google Sheets using Google Apps Script is true?
-
34. Creating custom forms within Google Sheets
+ Exercise: Which of the following statements about creating custom forms in Google Sheets is true?
-
35. Best practices for structuring data
+ Exercise: Which of the following is NOT one of the best practices for structuring data in Google Sheets, according to the text provided?
-
36. Use of extensions and add-ons
+ Exercise: Which of the following statements about extensions and add-ons in Google Sheets is true?
-
37. Practical applications for business and personal finance
+ Exercise: Which of the following practical applications of Google Sheets is mentioned in the text for the business context?
-
38. Tips to increase productivity
+ Exercise: Which of the following tips was NOT mentioned in the text as a way to increase productivity in Google Sheets?
-
39. Creation of an integrative final project
+ Exercise: What is the main objective of the final project in the Creation of Electronic Spreadsheets with Google Sheets course?
-
40. Conclusion and next steps for further development
+ Exercise: Which of the following actions is recommended to ensure retention of the knowledge acquired about Google Sheets, as suggested in the e-book course?
About the free ebook with audio
Creation of Electronic Spreadsheets with Google Sheets
This free ebook provides a practical path to creating, organizing, and analyzing electronic spreadsheets with Google Sheets. It starts with the workspace, Google account setup, spreadsheet creation, and the essential use of cells, rows, columns, formatting, and data entry.
Build accurate formulas and useful analyses
Learn to create formulas with arithmetic operations, relative and absolute references, named ranges, dates, text, and error handling. The ebook explains key functions such as SUM, AVERAGE, COUNT, MAX, MIN, IF, VLOOKUP, INDEX, AND, OR, and rounding functions, helping you turn raw values into reliable calculations.
Organize, highlight, and visualize information
Discover ways to sort, filter, validate, and import data. Use conditional formatting to identify duplicates, deadlines, values, and text patterns. Create charts, pivot tables, sparklines, and dashboards that make results easier to interpret and share.
Work collaboratively and automate tasks
The ebook also covers spreadsheet sharing, permissions, revision history, Google Forms connections, integrations, macros, add-ons, and Google Apps Script. Practical guidance on security, troubleshooting, data structure, productivity shortcuts, and real business or personal-finance applications supports confident day-to-day use.
What you will be able to do
- Create well-structured spreadsheets for personal or professional use.
- Use formulas and functions to automate calculations.
- Analyze data with filters, pivot tables, and charts.
- Build interactive dashboards and collaborate securely.
- Reduce repetitive work with macros and scripts.
How do relative and absolute references work in Google Sheets formulas?
Relative references change when copied; absolute references use dollar signs, such as $A$1, to stay fixed.
Which Google Sheets functions are covered for data lookup and logic?
The ebook covers IF, VLOOKUP, HLOOKUP, INDEX, AND, OR, NOT, and nested formulas.
How can Google Sheets data be turned into a dashboard?
Use organized source data, pivot tables, charts, conditional formatting, and interactive controls.
This ebook/audiobook includes:
7 hours and 40 minutes of audio content
Digital certificate of course completion (Free)
Exercises to train your knowledge
100% free, from content to certificate
Ready to get started?
recommended
In the app you will also find...
Over 5,000 free courses
Programming, English, Digital Marketing and much more! Learn whatever you want, for free.
Study plan with AI
Our app's Artificial Intelligence can create a study schedule for the course you choose.
From zero to professional success
Improve your resume with our free Certificate and then use our Artificial Intelligence to find your dream job.
You can also use the QR Code or the links below.
