Becoming a Google Sheet Wizard

Explore Google Sheets terminologies, learn about cells and their naming, formatting, undo, sharing, charts, formulas, data tools, and file, edit, and view options like freeze panes and protection.

Learn essential Google Sheets shortcuts for copying, pasting, undoing, redoing, finding, replacing, and selecting rows and columns, plus filtering by green color.

Use filter views to apply a temporary, personal filter that shows only event four, then revert to all data.

Learn to filter Google Sheets by text conditions, such as cells containing a word, and by color like green, to isolate relevant data.

Learn to sort data in Google Sheets by applying a filter and using the sort option to arrange values numerically, in ascending or descending order, and by color.

Learn how data validation in Google Sheets streamlines data entry by using dropdown lists, selecting validation from a range or list items, and removing validation when needed.

Master data cleanup by removing duplicates and applying the unique function to create a clean, unique list from a dataset, improving data management in Google Sheets.

Learn to apply conditional formatting in Google Sheets to highlight cells or rows, such as highlighting $400 values in green by selecting a range and setting a condition.

Become proficient with advanced conditional formatting in Google Sheets by using custom formulas to apply row-wide color rules, anchoring rows and comparing cell values.

Explore advanced conditional formatting in Google Sheets by combining data validation with custom formulas to automatically color cells based on completion status.

Learn to create a pivot table in Google Sheets, place it in a new or existing sheet, and configure rows, columns, and values to count attendance.

Learn to refine pivot tables in Google Sheets using filters and slicers, ensure new data auto-appears, and apply dynamic conditions to display relevant categories.

Explore pivot table techniques in Google Sheets by creating a pivot on a new sheet, placing money paid as values, and using filters to summarize totals.

Learn how to use average, sum, and count functions in Google Sheets, with range or column selections, tab auto-complete, and dynamic updates as new data is added.

Master sumif and sumifs to sum values under single or multiple conditions, using criteria ranges, criteria, sum ranges, and examples like even numbers and event attendance.

Explore counting functions in Google Sheets, including count, counta, countif, and countifs, to count numerical values or all data, and apply criteria for conditional counts.

Use date functions today and now to derive current dates and times, and to calculate ages or expiry dates, inputting them with =today() or =now().

learn to merge cell contents with the concatenate function, using a comma and space as delimiters, and create unique row values with concatenation in google sheets.

Learn to automate formatting in Google Sheets by recording and editing macros, including conditional formatting, bold, italic, underline, and applying the script across sheets.

Learn to create and edit macros in Google Sheets, generating a new sheet on each run, naming and clearing content, saving the macro, and assigning a shortcut.

Learn how to use the importdata function in Google Sheets to pull CSV or tab-delimited data from a URL, specify delimiters, and convert it into a clean table.

Use the importhtml function in Google Sheets to fetch a specific table from a web page, specify the table index and optional locale, and automate updates via a URL cell.

Learn how to create a one-way link between Google Sheets using importrange, including master and advanced sheets, range selectors, and access controls for safe data sharing.

Understand how #REF errors arise with import range in Google Sheets, where a one-way link can break if intermediate content appears. Resolve by deleting conflicting content so the data reappears.

Master the VLOOKUP function in Google Sheets by learning how to set the search key and the range. Use exact-match, lock ranges, and retrieve values left-to-right, such as money paid.

learn how to use trim with vlookup to clean spaces in names, normalize data, and achieve exact matches by nesting the functions.

Master VLOOKUP across Google Sheets by linking two workbooks with the importrange function, selecting the correct import range and index for exact matches.

Take VLOOKUP a step further by merging it with iferror to handle errors and return blanks for clean data. Automate lookups across many fields instead of autofill for streamlined workflow.

Learn to optimize Google Sheets with a nesting of arrayformula and vlookup to prevent lag as your data grows, while handling errors to return blanks for empty cells.

Learn how to overcome vlookup limitations by using index match to retrieve event names from nominations, using a nested index and match with exact matching in Google Sheets.

Master index and match in Google Sheets by nesting import range to pull data across sheets, creating a single lookup with range and precise matching.

Master reverse VLOOKUP and array formulas to populate an entire column without index match, using dynamic ranges and returning blanks on errors.

Master the Google Sheets query function to build dynamic queries, select ranges, and filter by money paid at least 300, returning unique event names with flexible header options.

Learn to build complex Google Sheets queries by selecting events and total money paid, filtering blanks, grouping, ordering in descending order, and applying limit and offset.

Apply a query to data from another sheet in Google Sheets using import range, and learn how to reference columns (such as column two) when combining query with import range.

learn how to create a dynamic query in google sheets by referencing a cell as the criteria, using ampersand concatenation to pass the value (e.g., 300) for the f column.

Learn to automate a Google Sheets snapshot that sums events, nominations, attendance, attendance percentage, and paid amounts (with refunds), using a month-dependent query and end-of-month date logic.

Learn to automate nominations counting in Google Sheets using a multi-criteria countifs approach, dynamically matching event names and the month and year, and clean up zero results.

Compute attendance count, attendance percentage, and total money by event name, month, and year using multi-criteria formulas in Google Sheets.

The lecture guides you to format a Google Sheet snapshot, apply conditional formatting, and create automated charts for attendance percentages, using data ranges, color rules, and chart customization.

Becoming a google sheets wizard shows how to build dependent dropdowns with data validation and vlookup, using dynamic ranges to filter team members by team.

Learn to automate tasks in Google Sheets by inserting checkboxes, using conditional formatting with custom formulas, and color-coding completed (green) and pending (gray) rows.