Microsoft Excel and Google Sheets for Data Analysis

Learn to use Google Sheets alongside Microsoft Excel, mastering formulas, functions, tables, charts, and core tools such as cells, rows, columns, sheets, and auto saving.

Learn how to manage Google Sheets as worksheets by adding, renaming, deleting, and rearranging sheets for subject data, insert rows and columns, resize columns, and hide or show sheets.

Learn to enter data and create formulas in Google Sheets, using active cells, cell references, and the formula bar to compute values. Save, download, and locate sheets in Google Drive.

Learn how to edit and clear cell data in Excel, using double-click, the formula bar, or backspace, and distinguish textual, numeric, and formula data types, including date and time formats.

Manipulate and format cell data in Google Sheets and Excel by editing text, using the formula bar, clearing values, and applying number, date, time, and currency formats.

Learn Google Sheets basics: navigate large tables with control arrow shortcuts, cut, copy, and paste via menus, right-click, or keyboard shortcuts, and use paste special and transpose.

Master saving, opening, and printing in Excel via the file tab, including new, open, save, save as, and password protection, plus print preview and page layout.

Learn to use the sumproduct formula in Excel to compute weighted totals across multiple series. Explore rand and randbetween for generating random values and the paste-as-values technique to freeze results.

Master the substitute function to replace strings, including changing b to d and noting case sensitivity, and learn upper, lower, length, left, right, and mid for transforming and extracting strings.

Explore logical functions in Excel, starting with single-argument tests and expanding to and/or conditions and nested ifs. Apply IF, COUNTIF, COUNTIFS, and SUMIF to grade students and summarize scores.

Apply vlookup and hlookup to retrieve scores from tables, and learn index and match as a faster alternative for large data sets.

Explore Google Sheets lookup functions, including vlookup, lookup, index, and match, to retrieve scores from data tables and build dynamic references with absolute references.

Learn to sort data, filter cases, and apply data validation in Excel and Google Sheets for data analysis, including multi-level sorts, numeric and text filters, and input restrictions.

Master formatting data and tables in Excel, from bold headers and italics to borders, alignment, wrap text, and merge and center, plus conditional formatting like color scales and icon sets.

Power tables and pivot tables in Google Sheets summarize large data by automatically grouping variables like salesperson, region, and date to show total sales, with slicers for interactive filtering.

Learn to create column and bar charts in Excel, including clustered, stacked, and 100% stacked types, with data series, axis labels, and chart title and legends.

Learn to format Google Sheets charts by using the chart editor to customize style, colors, titles, axes, data series, labels, legends, and grid lines for clear visual data representation.

Create pivot charts from pivot tables in Excel to visually summarize data with region filters and slicers; observe the two-way link that updates both chart and table.