Spreadsheet: Excel & Google Sheet (Beginner to Intermediate)

Explore the Microsoft Excel environment, compare access options through Microsoft 365 and single system installation, and review major versions while learning to analyze, manipulate, and organize fields.

Explore the Microsoft Excel environment, understand workbook and worksheet structures, and navigate the ribbon, quick access toolbar, cells, and formula bar to perform basic data tasks.

Learn how to enter and organize data in Excel, including structuring worksheets with rows and columns, budgeting examples, editing cells, autofill with dragging, and currency formatting.

Learn practical techniques to modify rows, columns, and cells in spreadsheets, including adjusting column width with auto fit, inserting or deleting columns, and merging cells for clean headers.

Select text and apply font style, size, color, bold and italics to emphasize headings and data. Learn to apply borders and alignment, and manage hiding, deleting, and replacing text.

Launch Microsoft Excel, choose a blank workbook or open an existing file by double-clicking or using the open command, and manage multiple workbooks and worksheets.

Save your workbook in Excel through three methods: initial save, continuous updates, and save as a different format (such as pdf). Use OneDrive or computer storage.

learn to manage multiple worksheets in Excel by adding, naming, duplicating, deleting, and hiding sheets; group sheets to apply formatting and formulas across them, and navigate between tabs.

Format dates and numbers in Excel and Google Sheets using currency, accounting, decimal places, thousands separators, and date styles, then apply percentage and time formats across ranges.

Learn to apply simple formulas in Microsoft Excel, starting with an equals sign and cell references like C4 and D4, with later coverage of complex formulas.

apply complex formulas in spreadsheets by following the order of operations, using parentheses, and correctly sequencing addition, subtraction, multiplication, and division.

Master relative and absolute cell references in Excel and Google Sheets by learning to drag formulas, fix cells with dollar signs, and build cost and selling price calculations.

Learn how to use the autosum function in Excel to sum ranges, and explore related functions like sum, max, min, average, and count with practical examples.

Discover how to insert images from your computer or online, use SmartArt and shapes, and apply formatting like borders, backgrounds, and alignment to enhance data visuals.

Set up spreadsheet layouts and prepare worksheets for printing by configuring page size and orientation (A4, portrait or landscape), adjusting margins, headers and footers, and defining print areas.

Learn how to sort data from highest to lowest or A to Z and apply filters in Excel, using the data menu and table formatting to preview results.

Learn how to visualize data in Microsoft Excel using charts, including choosing suitable chart types like column, line, and pie, and formatting to highlight trends and comparisons.

Analyze and visualize data with pivot tables and pivot charts in Excel or Google Sheets, using drag-and-drop fields, filters, and value summaries to compare monthly data.

Explore how to use the subtotal function in spreadsheets to sum quantities and revenue by branch, adjust for changes, and understand grand totals versus filtered results.

Learn to lock formulas in cells by unlocking all cells, selecting formula-containing cells, applying protection, and optionally hiding formulas with a password to prevent edits.

Protect worksheets and entire workbooks in Excel and Google Sheets by locking cells, applying password protection, and encrypting with a password.

Learn how to work with templates in Excel by reading formulas, understanding template structure, and applying ready-made templates to organize data and automate calculations.

Learn how to create and run your first macro in Excel to automate repetitive formatting tasks, using the developer tab, recording actions, assigning a shortcut, and saving macro-enabled workbooks.

Review Microsoft Excel 2021, compare it with 2013, and note familiar interface, faster performance, and collaboration with multiple authors via Microsoft Teams.

Explore Google Sheets as a cloud-based spreadsheet tool, learning to organize, sort, and manipulate data, compare it with Excel, and understand Google Drive integration for easy access.

Sign into your Google account, access Google Drive from Chrome, and create or open Google Sheets, then upload files, share links, and manage view or edit permissions.

Navigate Google Sheets interface, explore menus and the toolbar, and learn to create, name, share, and export spreadsheets to PDF, Open Document, or Excel.

Master Google Sheet basics by learning to adjust column width with double-click, insert and delete columns, drag and drop data, and freeze panes while merging cells and sorting ranges.

Learn to work with multiple worksheets in Google Sheet by adding, renaming, and duplicating sheets for monthly budgets, and organizing with colors, hiding, moving, and copying sheets across workbooks.

Learn to craft complex formulas in Google Sheets by applying the order of operations, using parentheses to group steps, and handling multiplication, division, addition, and subtraction.

Explore how to use functions and autosum in Google Sheets and Excel, including sum, average, maximum, minimum, and the argument syntax for ranges.

Learn to sort and filter data in Google Sheets by selecting a range and choosing ascending or descending. Use filter views to analyze data without affecting others.

Explore how to apply conditional formatting in Google Sheets, using manual and automatic methods, select data ranges, apply alternating colors and color schemes, set rules and presets to highlight data.

Learn to create and customize charts in google sheets by selecting meaningful data, choosing a chart type, adjusting colors and fonts, adding or removing series, and exporting or relocating charts.

Learn to create and customize a pivot table in Google Sheets, analyze student data, compare English and math scores, and apply filters to summarize totals with an interactive editor.

Master Google Sheets basics and its differences from Microsoft Excel, including formulas, comments, and images inside cells. Export to Excel or PDF and explore sharing and add-ons.