Getting started in Google Sheets 2022

Course: 28 Minutes

• Overview: Using functions in Sheets 2022
• Creating a named function in Sheets 2022
• Working with the LAMBDA function in Sheets 2022
• Using the MAP & REDUCE functions in Sheets 2022
• Using the BYROW & BYCOL functions in Sheets 2022
• Using the SCAN function in Sheets 2022
• Using the MAKEARRAY function in Sheets 2022
• Using the XLOOKUP function in Sheets 2022
• Using the XMATCH function in Sheets 2022

Creating & managing sheets in Google Sheets 2022

Course: 45 Minutes

• Overview: Using functions in Sheets 2022
• Creating a named function in Sheets 2022
• Working with the LAMBDA function in Sheets 2022
• Using the MAP & REDUCE functions in Sheets 2022
• Using the BYROW & BYCOL functions in Sheets 2022
• Using the SCAN function in Sheets 2022
• Using the MAKEARRAY function in Sheets 2022
• Using the XLOOKUP function in Sheets 2022
• Using the XMATCH function in Sheets 2022

Inserting & managing data in Google Sheets 2022

Course: 43 Minutes

• Overview: Using functions in Sheets 2022
• Creating a named function in Sheets 2022
• Working with the LAMBDA function in Sheets 2022
• Using the MAP & REDUCE functions in Sheets 2022
• Using the BYROW & BYCOL functions in Sheets 2022
• Using the SCAN function in Sheets 2022
• Using the MAKEARRAY function in Sheets 2022
• Using the XLOOKUP function in Sheets 2022
• Using the XMATCH function in Sheets 2022

Formatting data in Google Sheets 2022

Course: 40 Minutes

• Overview: Using functions in Sheets 2022
• Creating a named function in Sheets 2022
• Working with the LAMBDA function in Sheets 2022
• Using the MAP & REDUCE functions in Sheets 2022
• Using the BYROW & BYCOL functions in Sheets 2022
• Using the SCAN function in Sheets 2022
• Using the MAKEARRAY function in Sheets 2022
• Using the XLOOKUP function in Sheets 2022
• Using the XMATCH function in Sheets 2022

Enhancing documents in Google Sheets 2022

Course: 46 Minutes

• Overview: Enhancing documents in Sheets 2022
• Inserting rows & columns
• Resizing your columns & rows
• Hiding columns & rows
• Freezing & unfreezing columns & rows
• Inserting an image
• Inserting a drawing
• Editing your drawing
• Inserting a hyperlink
• Inserting people chips
• Inserting borders
• Adding headers
• Knowledge Check: Enhancing documents in Sheets 2022

Collaborating on a document in Google Sheets 2022

Course: 44 Minutes

• Overview: Collaborating on a document in Sheets 2022
• Publishing your document on the web
• Sending your document via email
• Protecting your document
• Sharing a spreadsheet
• Adjusting sharing options
• Working with other users on the same document
• Inserting comments in your document
• Assigning tasks
• Managing comments
• Knowledge Check: Collaborating on a document in Google Sheets 2022

Finding & filtering data in Sheets 2022

Course: 42 Minutes

• Overview: Finding & filtering data in Sheets 2022
• Using the Find & Replace tools
• Using the Find & Replace tools in a formula
• Sorting the data in your spreadsheet
• Filtering the data in your spreadsheet
• Using the advanced filtering options
• Sorting and filtering data with colors
• Using filtered views
• Using slicers
• Customizing slicers
• Grouping data
• Knowledge Check: Finding & filtering data in Sheets 2022

Using data in Sheets 2022

Course: 54 Minutes

• Overview: Using data in Sheets 2022
• Referencing cells in Sheets 2022
• Using absolute, mixed & relative cell references in Sheets 202
• Defining a new data range in Sheets 2022
• Using data from multiple sheets in Sheets 2022
• Calculating with constant values in Sheets 2022
• Using cell references indirectly in Sheets 2022
• Inserting drop-down menus in Sheets 2022
• Inserting menus with predefined options in Sheets 2022
• Validating your data in Sheets 2022
• Inserting checkboxes in Sheets 2022
• Viewing embedded Office files in Sheets 2022

Managing & calculating data in Sheets 2022

Course: 46 Minutes

• Overview: Managing & calculating data in Sheets 2022
• Calculating the interest on a loan in Sheets 2022
• Comparing loans in Sheets 2022
• Finding duplicate values in your spreadsheet in Sheets 20223
• Counting the total number of duplicates in Sheets 2022
• Managing duplicate entries in Sheets 2022
• Avoiding duplicate values in Sheets 2022
• Finding data in a database in Sheets 2022
• Performing calculations using your database in Sheets 2022
• Finding a value in a double-entry table in Sheets 2022
• Performing a search across two tables in Sheets 2022

Using basic formulas in Sheets 2022

Course: 47 Minutes

• Overview: Managing & calculating data in Sheets 2022
• Calculating the interest on a loan in Sheets 2022
• Comparing loans in Sheets 2022
• Finding duplicate values in your spreadsheet in Sheets 2022
• Counting the total number of duplicates in Sheets 2022
• Managing duplicate entries in Sheets 2022
• Avoiding duplicate values in Sheets 2022
• Finding data in a database in Sheets 2022
• Performing calculations using your database in Sheets 2022
• Finding a value in a double-entry table in Sheets 2022
• Performing a search across two tables in Sheets 2022

Using functions in Sheets 2022

Course: 32 Minutes

• Overview: Using functions in Sheets 2022
• Creating a named function in Sheets 2022
• Working with the LAMBDA function in Sheets 2022
• Using the MAP & REDUCE functions in Sheets 2022
• Using the BYROW & BYCOL functions in Sheets 2022
• Using the SCAN function in Sheets 2022
• Using the MAKEARRAY function in Sheets 2022
• Using the XLOOKUP function in Sheets 2022
• Using the XMATCH function in Sheets 2022

Using formulas to get data in Sheets 2022

Course: 40 Minutes

• Overview: Using formulas to get data in Sheets 2022
• Getting to know your data in Sheets 2022
• Retrieving date information in Sheets 2022
• Displaying & retrieving information about your data in Sheets 2022
• Finding the largest & smallest values in a list in Sheets 2022
• Separating your data in Sheets 2022
• Combining data in Sheets 2022
• Comparing two lists in Sheets 2022
• Inserting data automatically in Sheets 2022
• Identifying errors in formulas in Sheets 2022

Using charts in Sheets 2022

Course: 41 Minutes

• Overview: Using charts in Sheets 2022
• Creating a pie chart in Sheets 2022
• Creating a scatter chart in Sheets 2022
• Creating a bubble chart in Sheets 2022
• Creating a radar chart in Sheets 2022
• Creating a table chart in Sheets 2022
• Combining two types of charts in Sheets 2022
• Placing data on a map in Sheets 2022
• Using Sparklines in Sheets 2022
• Publishing your chart in Sheets 2022

Analyzing tables & customizing charts in Sheets 2022

Course: 47 Minutes

• Overview: Analyzing tables & customizing charts in Sheets 2022
• Analyzing your data with a pivot table in Sheets 2022
• Developing your pivot table in Sheets 2022
• Sorting & filtering a pivot table in Sheets 2022
• Adding calculated fields to your pivot table in Sheets 2022
• Copying & exporting your pivot table in Sheets 2022
• Creating a quick chart in Sheets 2022
• Editing a chart in Sheets 2022
• Customizing your chart in Sheets 2022
• Customizing your chart's axes in Sheets 2022
• Connecting a sheet to BigQuery in Sheets 2022
• Managing your connected sheet in Sheets 2022

Performing calculations in Sheets 2022

Course: 41 Minutes

• Overview: Performing calculations in Sheets 2022
• Using conditional formulas in Sheets 2022
• Inserting a conditional sum formula in Sheets 2022
• Creating multiple conditions in Sheets 20224
• Performing complex conditional formulas in Sheets 2022
• Using IF, OR & AND in conditional formulas in Sheets 2022
• Viewing data in different languages in Sheets 2022
• Using reference positions in conditional formulas in Sheets 2022
• Keeping your table updated with conditional formulas in Sheets 2022
• Creating automatic reports in Sheets 2022