Video summary

Excel Beginner Tutorial

Main summary

Key takeaways

Educational

Main ideas / lessons conveyed

Excel 365 overview

  • Excel 365 is Microsoft’s subscription-based Excel that integrates with Microsoft 365 cloud services.
  • Key benefits:
    • Autosave to the cloud (commonly OneDrive) to reduce data loss
    • Real-time collaboration (multiple people editing simultaneously)
    • Access across devices, including mobile
    • Frequent updates pushed to devices automatically

Training goal: by the end, you should be able to:

  • navigate the interface
  • input/edit data
  • use formulas/functions
  • print with correct settings

Excel interface navigation

  • Startup page

    • Open a blank workbook
    • Use templates
    • Reopen recent files

  • Core UI components:

    • Quick Access Toolbar (customizable; includes autosave/undo options)
    • Ribbon:
      • tabs (e.g., Home, Insert)
      • command groups
      • commands
    • Name box
      • shows the current cell reference (e.g., column letter + row number)
      • mentions named ranges (for a later episode)
    • Formula bar
      • shows the cell’s true contents (important because display can look the same for values vs. formulas)
    • Sheet tabs
      • rename / add / move / delete (with later details)
    • Zoom controls
      • buttons, percentage display
      • Ctrl + mouse wheel / pinch gestures

  • Search and Help

    • Search bar
      • finds features/actions using keywords or full sentences
      • suggests options
    • Help pane
      • search, video tutorials, contact support, feedback, community resources

Cell selection and navigation

  • Keyboard navigation
    • Arrow keys
    • Tab / Shift+Tab
    • Enter / Shift+Enter

  • Mouse navigation

    • click around to move/activate cells

  • Selection methods:

    • single cell selection
    • click-and-drag to select ranges
    • fast range selection:
      • Ctrl + Shift + Arrow to extend selection to the next empty cell in the indicated direction
    • Ctrl + A selects all data in the worksheet

Building “Cup of Joe’s yearly report” (hands-on exercise)

Create structure

  • Put a title in A1.
  • Create headers in row 3:
    • Items
    • Price
    • quarters QTR 1–QTR 4
  • Enter example items (e.g., original coffee, espresso, latte, blueberry muffin, breakfast sandwich, croissant).
  • Enter prices and quarter sales numbers.

Common issues addressed

  • Text/headers getting cut off because columns are too narrow
    • not deleted—just hidden by column width
  • Numbers like 2.0 turning into 2 due to formatting
    • Excel default/General formatting

Editing and deleting data

  • Backspace
    • replaces/edits cell content (cursor stays to type)
  • Delete
    • removes selected content
  • Multiple selected cells:
    • Delete removes everything correctly
    • Backspace may only replace/delete the first selected cell
  • Ctrl+Z
    • undoes changes
    • undo is also accessible from the Quick Access Toolbar

Formatting and layout adjustments

Number formatting

  • Home → Number command group
  • Change General to Currency
    • adjust decimals and currency symbols
  • Use dropdown predefined formats

Column resizing

  • Drag the boundary between column letters (double-headed arrow)
  • Auto-size: double-click the column divider
  • “Pound signs” (####) indicate the value exists but doesn’t fit the column
  • Auto-adjust all columns:
    • select all columns (via the corner/selector)
    • then double-click a divider to autosize everything

Calculations vs formulas vs functions

  • Calculation

    • direct math like 1+2+3+4+5 (calculator-like)
    • not dynamic: may not update automatically if inputs change

  • Formula

    • starts with =, uses cell references (e.g., sum of selected cells)
    • dynamic: updates when referenced cells change
    • uses operators like +, -, *, /

  • Function

    • a pre-built formula (e.g., SUM, AVERAGE, MIN, MAX)
    • also starts with =
    • accessed by:
      • typing the function name (e.g., =S... for matches)
      • using the Function Library in the formula bar

Automation with autofill

  • Uses the Autofill handle (small square at bottom-right of a selected cell)

  • Autofill can copy:

    • formulas/functions (following patterns)
    • numbers/dates/series
    • categorical sequences (months/days)
    • text with increasing indices (e.g., Joe 1, Joe 2…)

  • Autofill behaviors:

    • regular autofill repeats values
    • Ctrl + autofill creates sequential order when appropriate
    • pattern completion works especially when starting with two values (e.g., 2 and 4 → 2,4,6,8,10)
    • autofill can also “fill across” when applied horizontally

Building totals and tax calculations

Totals

  • Use SUM to compute total items sold per item across quarters
  • Use SUM across quarter columns for quarter totals

Sales totals

  • Use multiplication with *
    • e.g., total sales = price × total quantity sold

Tax calculation

  • Tax rate stored in J1 (example: 7.25%)
  • Tax owed = total sales × tax rate

Relative vs absolute references

  • Relative references move during autofill
    • e.g., I4*J1 becomes I5*J2, etc.
  • Absolute reference locks a cell so it doesn’t move
    • e.g., $J$1
  • Two ways to make absolute references:
    • manually add $ anchors: $J$1
    • use F4 to toggle absolute/relative anchors quickly

Saving and sharing in Excel 365

  • Autosave

    • turn on in the top-left if enabled
    • saves to OneDrive/cloud
    • if not visible: customize Quick Access Toolbar

  • Manual saving

    • floppy icon or Ctrl+S
    • Save As available

  • Sharing (real-time collaboration)

    • share link via OneDrive
    • set permissions: view vs edit
    • optionally add expiration date and password
    • important distinction:
      • attaching/exporting a copy (Excel/PDF) enables sharing but not real-time co-editing

Comments for asynchronous teamwork

  • Comments live in Review tab → Comments or the top-right comment button.
  • Features:
    • add new comment on a selected cell
    • @mentions teammates
    • assign tasks in comment text
    • replies, resolve threads, delete, reopen

Inserting rows/columns

  • Insert row: inserts above the selected row
  • Insert column: inserts to the left of the selected column
  • Multi-insert: select multiple rows/columns and insert once to add multiple at once

Cut/Copy/Paste and moving/copying data

  • Clipboard tools:
    • Cut (Ctrl+X), Copy (Ctrl+C), Paste (Ctrl+V)
  • Memory tips:
    • Ctrl+X resembles scissors
    • Ctrl+C resembles “copy”
    • Ctrl+V resembles a glue bottle tip
  • Drag-and-copy:
    • drag border to move
    • hold Ctrl while dragging border to copy

Styling the worksheet with formatting and cell styles

  • Formatting options:
    • Home tab → font formatting (color, size, bold/italic/underline, borders, cell color)
  • Cell Styles
    • Home → Styles → Cell Styles dropdown
    • apply styles like Title, Heading, Notes, Input, Calculation
  • Styling improves readability; it doesn’t change logic
  • sheet remains functional/automated when input areas change

Scaling the report to multiple years

  • Rename sheet (double-click tab)
  • Duplicate sheet:
    • long way: Move/Copy → create a copy
    • faster way: Ctrl + drag sheet tab to instantly copy
  • Clear data for later years without rebuilding logic:
    • group worksheets (select multiple tabs, Ctrl-click)
    • delete note dates and input data in grouped sheets so formulas remain but results reset

Custom views for different audiences

  • Hide vs delete:
    • hide removes visibility only; data remains
  • Hide rows/columns:
    • right-click → Hide / Unhide
  • Create custom views:
    • View tab → Custom Views
    • custom views can only be created when worksheets are not grouped
  • Workflow:
    • create an Original view snapshot
    • hide items the CEO doesn’t want (e.g., taxes/report sections)
    • add another view (e.g., CEO view)
    • switch quickly between views without manual un-hiding

Review and proofreading

  • Review tab commands:
    • spell check (watch for dictionary-valid typos)
    • Smart Lookup (definitions/images/pronunciation)
    • workbook statistics (cells with data, formulas, tables, etc.)
    • accessibility checks

Printing / exporting

  • File tab → Print
  • Fix fit-to-page issues:
    • change orientation (portrait/landscape)
    • use scaling to fit on one page
  • Add print headers/footers:
    • View tab → Page Layout
    • add sheet name, page number, and a logo picture
    • resize logo within header/footer using picture formatting options
  • Export:
    • print to PDF and save (example: to Desktop)

Instructional / methodology bullet list (step-by-step elements)

A) Understand Excel 365 features (concept checklist)

  • Use Excel 365 as a subscription version of Excel
  • Enable autosave to store changes in OneDrive/cloud automatically
  • Use real-time co-collaboration for simultaneous editing
  • Expect regular updates pushed to your device

B) Navigate the Excel interface

  • Open Excel → choose a blank workbook from the startup page
  • Identify:
    • Ribbon tabs → command groups → commands
    • Name box for current cell reference
    • Formula bar for true cell contents
    • Sheet tabs and zoom controls
  • Use the Search bar for features/actions via keywords or full sentences
  • Use the Help pane for tutorials, support, feedback, and community resources

C) Select/navigate cells quickly

  • Move:
    • Arrow keys
    • Tab / Shift+Tab (left/right)
    • Enter / Shift+Enter (down/up)
  • Select:
    • click-and-drag ranges
    • Ctrl+Shift+Arrow to extend selection to next empty cell
    • Ctrl+A to select all worksheet data

D) Build “Cup of Joe’s yearly report” (core worksheet build steps)

  • Enter title in A1
  • Create headers in row 3:
    • Items, Price, QTR1–QTR4
  • Enter item names in the Items column
  • Enter prices in the Price column
  • Enter quantities/sales numbers across quarter columns
  • If text is cut off:
    • adjust column width (drag divider or double-click for auto-size)
  • If decimal formatting is wrong (e.g., 2.0 → 2):
    • apply proper number format (Home → Number → Currency, etc.)

E) Delete vs replace correctly

  • For one cell:
    • Backspace = replace/edit
    • Delete = remove
  • For multiple selected cells:
    • use Delete to remove all selected cells
  • Use Ctrl+Z to undo mistakes

F) Create totals using functions

  • Use = then a function name (or use the function library)
  • Total items sold (per item across quarters):
    • SUM(range_of_quarter_values)
  • Total sales:
    • price_cell * quantity_total_cell

G) Apply autofill efficiently

  • Use the Autofill handle to copy formulas/functions down or across
  • For repeating series:
    • use autofill normally to repeat
    • use Ctrl + autofill for sequential progression
  • For arithmetic patterns:
    • provide at least two starting values (e.g., 2 and 4) then autofill

H) Compute taxes and use absolute references

  • Put tax rate in a single cell (example: J1)
  • For each item/quarter total sales:
    • total_sales_cell * tax_rate_cell
  • When autofilling, lock the tax-rate cell:
    • convert tax rate reference to absolute (e.g., $J$1)
    • use F4 to add anchors quickly

I) Save and share

  • Turn on autosave (if desired) to OneDrive/cloud
  • Manual save with:
    • save icon or Ctrl+S
  • Sharing:
    • use Share → create a link
    • choose view/edit permissions
    • optionally add expiration/password
  • Real-time collaboration requires sharing the workbook (not attaching a static copy)

J) Add comments for collaboration

  • Select a cell → Review tab → New Comment (or top-right comment button)
  • Optionally:
    • @mention teammates
    • assign a task in the comment
  • Resolve threads when done

K) Insert notes section and manage layout

  • Insert row:
    • select row number → Insert row above (right-click)
  • Insert column:
    • select column letter → Insert column left (right-click)
  • Insert multiple at once:
    • select multiple rows/columns → insert once

L) Duplicate the report for multiple years

  • Rename current sheet (e.g., 2023)
  • Copy sheet for new years:
    • Ctrl + drag tab to create copy
  • Group the sheets (Ctrl-click multiple year tabs):
    • delete old input data in grouped sheets to reset later years while preserving formulas

M) Create custom views (audience-based display)

  • View tab → Custom Views
  • Create an Original view snapshot first
  • Hide cells/rows/columns not needed for the target audience
  • Add a new view (e.g., CEO view)
  • Switch using “Show” between views

N) Proofread and print/export

  • Review tab → Spelling (pay attention to dictionary-valid typos)
  • Smart Lookup for definitions/pictures/pronunciation
  • File → Print:
    • adjust orientation/scaling if content doesn’t fit
  • Add header/footer in Page Layout:
    • sheet name, page number, logo image
  • Export:
    • print to PDF and save

Speakers / sources featured

  • Joe Patty (main instructor; referenced as “Joe”)
  • Microsoft (Excel 365 features, function library, and support/help content)

Original video