Microsoft Excel and Google Sheets for Data Analysis

Learn how to start and navigate Excel, understand workbook and worksheet structure, rows, columns, and cells, and explore the ribbon with its tabs for basic data tasks.

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.

Celebrate this milestone and your place in the top 50% of learners. The course evolves with enhanced resources, and you can access Q&A support and a completion certificate.

Add, rename, delete, and rearrange worksheets to keep data organized; insert, resize, and delete rows and columns, and hide or unhide sheets for focused views.

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.

Enter data and formulas in the worksheet by using an active cell, multiply C2 by C3, and save the workbook as an Excel .xlsx file.

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 to cut, copy, and paste in Excel, using Ctrl+X, Ctrl+C, and Ctrl+V; navigate with arrow keys and Ctrl+Arrow, select with Shift or Ctrl+Shift+Arrow, and undo with Ctrl+Z.

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 save and print in Google Sheets, create and open spreadsheets, share and download as Excel, and protect sheets or ranges with permissions and offline access.

Learn basic calculations in Google Sheets using cell references, including sum, sum with a constant, product, and average; master absolute references and autofill to populate tables.

Explore basic mathematical functions in Excel, including sum, min, max, and average, and learn the difference between formulas and functions, cell references, and locking ranges.

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.

Explore how to use mathematical functions in Google Sheets, including sum, min, max, average, and rank, with examples using student marks and absolute references.

Learn to compute weighted sums with sumproduct using weights, then generate random numbers with rand and rand between, and fix results by pasting values only.

Learn textual functions in Excel to clean and combine text data, using trim to remove spaces, concatenate and ampersand to join strings, and copy-paste as values for real 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.

Learn to manipulate text in Google Sheets using textual functions, including trim to remove whitespace and concatenate to join strings, with examples on absolute references and via operators.

Learn how to manipulate text in google sheets using substitute, upper, lower, len, left, right, and mid functions, with practical examples like replacing values and parsing qr codes.

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.

Explore logical functions in Google Sheets, including single and nested ifs with and/or, apply countifs, countif, and sumif to analyze student marks.

Learn date-time functions in Excel, including today and now, and handle multiple date formats. Convert dates to numbers, extract day, month, year, and compute date differences.

Explore date and time functions in Google Sheets, including today, now, date, day, month, year, and days, and learn to format results with custom date and time formats.

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.

Explore how to replace vlookup with xlookup in Excel 2021/365, using mandatory and optional parameters like lookup value, lookup array, and return array, including left and right lookups.

Learn to handle not-found values with XLOOKUP using the if not found parameter, and master exact and approximate match modes for vertical and horizontal lookups.

Learn wildcard matching in X lookup, using star and question mark to handle partial strings and match arrays with wildcard character mode, illustrated by an employee ID lookup.

Discover XLOOKUP search modes, including top-to-bottom, bottom-to-top (-1), and binary search for ascending or descending data, and learn when each speeds up lookups.

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.

Split joined data into separate cells with text-to-columns, using delimited or fixed-width options and comma or star separators, then remove duplicates and keep the entry with the highest English score.

Master advanced filters in Excel from the data tab to apply multiple conditions, output results to a location, use wildcards for text, filter by numeric ranges, and extract unique records.

Explore data tools in Google Sheets to sort, filter, validate data, and split text into columns, while removing duplicates for cleaner datasets.

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.

Master Google Sheets formatting to create visually appealing tables with bold headers, borders, colors, alignment, merged cells, and conditional formatting for highlights and ranking.

Explore pivot tables in Excel to summarize large furniture sales data by salesperson, region, and date, and learn to use rows, columns, values, filters, and slicers.

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.

Discover how charts transform numerical data into visual representations that reveal patterns and trends, highlight why charting matters as data grows, and preview exploring different chart types.

Identify chart elements such as data series and data points, category axis, primary and secondary vertical axes, legends, data labels, chart title, grid lines, chart area, and plot area.

Learn to create charts in Excel with one click using the recommended charts option, then customize colors, layouts, and styles to craft charts from scratch for clear data storytelling.

Learn to create charts in Google Sheets with one click by inserting a chart from selected data, yielding a column chart of months and sales; customize colors and titles.

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 create column and bar charts in Google Sheets, compare monthly sales using standard and 100% stacked charts, and customize axes, titles, and legends.

Format a simple column chart in Excel by selecting and customizing each element: chart area, title, axes, legend, and plot area, using fill, border, font, and number options.

Master Excel chart formatting by adjusting vertical axis grid lines, line styles and colors, and by tuning axis options for primary and secondary axes, overlap, gap width, and chart elements.

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.

Learn to create and customize line charts in Excel to plot continuous data, identify trends, compare product contributions over years, and avoid 3D charts.

Explore how line charts in Google Sheets visualize data trends across years, compare shirts and pants, and customize axes, data points, and interval steps for clear insights.

Learn how area charts differ from line charts, manage multiple data series with legends and transparency, and explore stacked, 100% stacked, and 3D area options and their business use.

Explore area charts in Google Sheets, compare shirts, pants, and others across quarters, add data series, and format legends, axis titles, and opacity, noting that 3d area charts aren’t available.

Learn to create and customize pie charts and donut charts in Excel, including pie of pie and bar of pie, with data labels and percentage contributions.

Learn to create and customize pie and donut charts in Google Sheets, including labeling and highlighting slices. Explore formatting, legends, and donut chart variations using two data tables.

Avoid pie and donut charts; use bar charts for clear comparisons of market share across suppliers, and accurately identify the largest supplier.

Learn to create scatterplots and bubble charts in Excel to explore relationships between two (and three) variables, add trend lines, interpret equations, and compare 2D and 3D bubble plots.

Create scatter plots and bubble charts in Google Sheets to analyze relationships between two and three variables, with trend lines, axis adjustments, and clear chart titles.

Explore frequency distributions for qualitative and quantitative data, learn to build bar charts and histograms in Excel, define class width and bins, and interpret relative frequencies with data labels.

Create histograms in Google Sheets by selecting the data column, inserting a chart, and adjusting the bucket size from auto to specific values; note that pie charts are not available.

Learn spark lines in Excel to show trends in a cell, including line, column, and win loss types, and how to create and clear them to enhance reports.

Learn how spark lines in Google Sheets create mini charts inside a cell, using the sparkline formula to produce line, bar, or minimax charts with color options.

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.

Learn to convert pivot tables into charts in Google Sheets, build column charts, apply slicers and filters by month, and compare two customers' sales over time.

Use the new analyze data feature in Excel (Microsoft 365) to describe analysis in English and generate pivot tables, charts, filters, and insights; keep data tabular with clear column names.