Spreadsheets for Beginners: Master your Data Game

Master the basics of spreadsheets by learning rows, columns, and cells, how to enter data, and how coordinates like G2 and E6 map the sheet in Google Sheets.

Explore the tabular structure in spreadsheets by creating a two-column table with headers 'student name' and 'student age', navigate with keyboard arrows, and identify the range from A1 to B4.

Create and format a table in Excel by inserting it and selecting A1 to D6. Use headers, filters, and adjust column widths as needed.

Open Google Sheets files, rename workbooks, and add or rename multiple worksheets to organize data across tabs. Switch to Microsoft Excel, download as xls/xlsx, and handle protected view.

Save your spreadsheets in Google Sheets and Microsoft Excel by using auto-save to Google Drive or Ctrl+S, and use save as to choose new locations, while noting last save location.

Explore how to create formulas in Google Sheets, calculate VAT and total sales using cell references, handle decimals, and apply relative references to replicate calculations across rows.

Master relative references in Excel and Google Sheets to propagate a 10% VAT and total value across rows by dragging the fill handle, while noting absolute references introduced next.

Learn to use absolute references in spreadsheets by fixing rows and columns with dollar signs, so tax rate changes automatically update vat calculations.

Master basic spreadsheet calculations by using the four operators and the sum function, and learn to work with relative and absolute references for efficient data totals.

Use the max and min functions on sales data in Google Sheets or Excel, using ranges and arguments to extract the largest and smallest values.

Reference data from other worksheets to sum total sales by store using the sum and sumif functions. Build an aggregated sales sheet that updates automatically as you add data.

discover how to use count and countif to tally numeric cells and apply simple criteria, fix absolute references, and apply these functions to a data table in Excel.

Learn how to sum data across worksheets in Excel by selecting cells from another sheet, using the sum function, then compare with Google Sheets.

Take on an eBay analyst exercise with the eBay data spreadsheet to practice core functions, from sum, max, and min to calculating averages and analyzing notebook brands by price.

Format and style worksheet cells to improve the visual presentation of sales data, including totals and value added tax. Learn basic number formatting and rounding.

Format dates by first setting the date format, then entering dates to prevent bugs; learn how Excel stores dates as serial numbers and shows the time part when applicable.

Learn to format text and data in spreadsheets by applying bold, italic, underline, color, and font size, and set currency and percentage formats for a polished look.

Format spreadsheets by applying header fill colors, adjusting fonts and bold, using the format painter to copy styles, and adding or removing borders for a polished table.

Learn to format cells and text in spreadsheets by applying center and right alignment, auto-fit columns, and highlight totals with borders, larger fonts, and decimal control.

Master merging cells to create headers and summaries, apply borders and center text, and highlight input data while mastering selection, formatting icons, and basic formulas.

learn how to apply conditional formatting in spreadsheets, use color scales and rules for values such as greater than 10,000, and for text and dates, with practical examples.

Navigate Excel’s home tab to locate conditional formatting, font and text formatting, wrap text, and merge cells. Compare with Google Sheets and skim menus to find the exact options quickly.

Learn to format and analyze a census dataset with more than 70,000 rows in Google Sheets or Excel, improving readability and aesthetics while answering data analysis questions.

Learn to manage data by freezing header rows and sorting by total sales in ascending order, while preserving headers and safely undoing unintended changes.

Apply filters to spreadsheet data to view relevant rows using color and condition filters. Start filters on the table across multiple columns, and clear them to restore the full dataset.

Learn to create and customize bar plots in Google Sheets and Excel, map data to x and y axes, and personalize colors, fonts, and titles, with dynamic updates from data.

Learn data validation in spreadsheets to prevent negative values and restrict input to a, b, or c with dropdowns, validation messages, and date checks.

Learn to build conditional formulas with if and iferror in spreadsheets, using over 10,000 thresholds, text vs numeric comparisons, relative and absolute references, error handling, and pivot tables.

Discover how pivot tables turn raw data into quick insights by summarizing sales by store location and product category using lines, columns, values, and filters.

Role-play as an Airbnb analyst to practice filter and sorting, data validation, and pivot tables on an Airbnb listings dataset.

Learn how to extract distinct values with the unique function in spreadsheets, including selecting full columns or specific ranges and handling headers, using a practical eBay data example.

Master vlookup to pull a brand's average price from a reference table, using an absolute cell reference, and auto-fill results to keep data updated without manual copy-paste.

Learn to combine index and match to look up values across rows and columns, fetch specific data from a data range, and build dynamic references for spreadsheet analysis.

Master how to use the and or functions to validate data and control calculations in spreadsheets, applying multiple conditions for reliable validations in Excel and Google Sheets.

Master vlookups, index match, and the end order condition while integrating pivot tables and conditional formatting to analyze Spotify data as a practical data analyst exercise.