I Heart Google Sheets: Training for Skills Employers Want

Explore the view menu in Google Sheets to freeze rows or columns, toggle grid lines and the formula bar, view all formulas, and switch to full-screen.

Explore the Google Sheets format menu to adjust how text and numbers appear, including number formats, font size, italic, underline, and strikethrough styles, text alignment, and merging cells.

Explore the data menu in Google Sheets, learn to sort data by column and range, create named ranges, protect sheets, apply filters and filter views, and use data validation.

Explore Google Sheets add-ons to boost functionality and discover free options for personal projects. Find tools for charts, text analysis, productivity boosts, and QR codes to streamline spreadsheets.

Explore the Google Sheets help menu to search topics, learn about formulas and pivot tables, and navigate the functions list with parameters, examples, and keyboard shortcuts to save time.

Explore the Google Sheets toolbar for formatting, alignment, borders, merging, and quick access to links, comments, charts, and functions. Use explore for quick statistics and recommended graphs.

Explore foundational Google Sheets formulas, covering basic arithmetic, counting, averaging, and rounding. Learn logical and conditional functions like IF, OR, AND, plus MIN, MAX, and practical applications for data analysis.

Use Google Sheets to perform sum, subtract, multiply, and divide on a team salary dataset to analyze totals and compute the average salary per player.

Learn how to use count and counta in Google Sheets to distinguish numeric data from non-empty values, and count elements in ranges like Column C or a players list.

Use the Google Sheets average function to compute simple averages from salaries, compare with sum divided by count, and note when weighted averages are needed.

Learn how to use the MIN and MAX functions in Google Sheets to identify the lowest and highest salaries within a range, illustrated with Arizona Diamondbacks data.

Explore how the if function in Google Sheets evaluates a logical test and returns different values, demonstrated with salary data and future use with other formulas.

Explore or and operators in Google Sheets to build logical tests with the IF function, combining salary criteria and pitcher status to return yes or no.

Master Google Sheets text functions, including len, left, right, mid, and find. Learn to extract last names, first names, and character counts for data cleanup.

Explore how the index function provides an alternative lookup in Google Sheets, pairing it with the match function for exact results, anchoring ranges, and common pitfalls when dragging formulas.

Learn to create and customize charts in Google Sheets by manually selecting data and visualizing salary and bonus with line, combo, and stacked column charts.

Explore business and statistics formulas in Google Sheets, including financial calculations such as net present value, payment, period, PV, and FMV, plus distribution functions and rand.

Learn how to use autofill in Google Sheets with a simple function, then double-click the fill handle to extend the formula to the last row, or copy-paste using keyboard shortcuts.

Master anchoring in Google Sheets to lock ranges with dollar signs, keeping formulas consistent when dragged across data. Learn anchored columns and rows for cumulative sums and stable totals.

Learn conditional formatting in Google Sheets by creating rules to highlight values, such as salaries above 400000, and using color scales to generate quick data heat maps.

Learn to apply borders in Google Sheets to enhance readability and structure, using all borders, outer borders, vertical borders, and bottom borders to separate data and totals.

Explore how to use Google Sheets comments to collaborate: add, reply, and resolve comments on cells, manage notifications, and distinguish comments from notes.

Explore Google Sheets keyboard shortcuts for copy, paste, cut, undo, redo, anchoring with dollar signs, inserting links, bold/italics/underline formatting, navigating sheets, renaming and editing cells quickly.

Master efficient navigation in Google Sheets by using arrow keys, control and shift modifiers to jump to data boundaries, highlight ranges, and quickly return to the first or last cell.

Learn how to find and import templates for Google Sheets using the Virtex 42 add-on, access the template gallery, browse templates, and copy them to Google Drive.

Learn how to draw on Google Sheets by treating each cell as a pixel, resizing columns, and filling colors to create a logo and heart shapes.