Data Analysis Using Excel and Google Sheets : Ultimate Guide

Explore how Excel and Google Sheets organize data using workbooks, sheets, cells, and templates. Learn the interface basics, including the menu bar, tab bar, and collaboration features.

Learn how to input and manage data in spreadsheets, use autocomplete and drag to fill patterns, and apply absolute and relative references to create robust formulas across cells.

Learn how to format data and tables in spreadsheets, including alignment, wrapping, fonts, currency, dates, and conditional formatting, to ensure clean, professional, and collaborative analytics.

Format tables by applying alternating colors, borders, and fonts, set grid lines and headers, merge cells, add checkboxes, freeze headers, and customize rows and columns for a polished spreadsheet.

Master conditional formatting in Excel to highlight data with rules, using a range and colors to identify values like high and low prices, and prepare for data analytics with formulas.

Explore how to format data in Excel, apply templates, wrap and align text, customize currency and date formats, and use pivot tables and conditional formatting.

Explore data analysis in Excel and Google Sheets, from automatic insights to filtering, sorting, slicers, dropdowns, and extracting data like names from emails, including health and medical functions.

Learn to filter and sort data in spreadsheets using the data menu, filter views, and ascending or descending order. Utilize slicers for multi-criteria filtering to refine datasets.

Master data validation and dropdown lists, use checkboxes and warnings, and learn core Excel and Google Sheets formulas and functions, including absolute references and today.

Master concatenation to join names, and use left, right, and length to extract components, plus text to column and find and replace with regular expressions.

Explore using the if function in Excel to categorize salaries as high paid or low paid, apply logical tests, handle errors with iferror, and implement data validation.

Learn to use vlookup to join data across sheets, identify unique identifiers, and clean data by pulling divisions into a master sheet for sales analysis and customer retention insights.

Master Excel features like checkboxes, slicers, and data validation with dropdown lists, plus conditional formatting with heat maps and data bars, to create dynamic dashboards and charts.

Review core Excel and Google Sheets features for data analysis, including formatting, data validation, filtering, and creating multiple sheets, then build dashboards with macros to automate tasks.

Learn to create and customize pivot tables in Excel to analyze yearly product sales by country, including profit, percentage of grand total, filters, and multi-dimensional layouts.

Learn to create and customize bar, line, and map visualizations in Excel using pivot tables, data ranges, and the chart editor to build dynamic dashboards with slicers.

Learn to create pivot tables and charts in Excel, use slicers and filters, and build dynamic dashboards to analyze product and country data.

Create dynamic dashboards in Excel by blueprinting data, adding slicers, charts, and labeled headers to visualize sales across countries and regions.

Master macros to automate repetitive data formatting and cleaning in Excel and Google Sheets by recording steps, using developer tools, and triggering macros with buttons.

Celebrate completing the data analysis course and prepare for advanced steps by mastering Excel and Google Sheets, creating dashboards, and leaving a review.