Video summary

엑셀 처음이라면초보자를 위한 필수 기능 5가지

Main summary

Key takeaways

Educational

Main ideas / lessons conveyed

  • Excel is one of the most important IT skills to learn for workplace usefulness, and learning a small set of core features can make it feel “manageable.”
  • The video introduces five beginner Excel functions/techniques:
    1. AutoFill
    2. AutoSum
    3. Print settings / Print Preview (including fitting to one page)
    4. Efficient data/table entry + formatting so it prints correctly
    5. Filters for quickly finding subsets of data

Detailed methodology / instructions (by section)

1) Open Excel and find it (setup)

  • Open Excel:
    • If the Excel icon isn’t on your desktop:
      • Use the Start menu search.
      • Type “Excel” (the subtitles show an incorrect “2,” but the intent is searching for Excel).
  • Click New Document to start.

2) AutoFill (copying patterns, series, dates, weekdays, times)

What to know

  • Excel is made of many cells.
  • After typing into a cell:
    • You’ll see an AutoFill handle (a small square/dot) at the selection border’s lower-right corner.
    • The mouse pointer becomes a cross when hovering over the handle, indicating you can drag.

Examples / steps

  • Copy text

    • Type a name (e.g., “Lee Seong-won”).
    • Drag the AutoFill handle downward to copy.

  • Copy numbers

    • Type 1 in the next cell.
    • Drag downward to copy the same value (basic copy behavior).

  • Fill a continuous increasing sequence

    • After 1, drag to create the increasing sequence.
    • Use the AutoFill options dropdown at the corner:
      • Choose Fill Continuous Data
    • Result: 1, 2, 3, 4, 5, ...

  • Date recognition + incrementing by day

    • Type a value like 1-8 and press Enter (Excel recognizes it as a date).
    • Drag the AutoFill handle:
      • Dates increase by 1 day.

  • Fill by weekday (workweek patterns)

    • Drag the AutoFill handle.
    • Choose Fill by Weekday
    • This skips weekend cells and continues through only weekdays (Mon–Fri).

  • Time increment

    • Type the hour (e.g., 10:00).
    • Drag down:
      • Increments by 1 hour.

  • Weekday sequence with custom columns

    • Drag to produce: Monday, Tuesday, Wednesday, Thursday, Friday
    • Continue to include additional days (e.g., insert Sunday if needed).

3) AutoSum (quickly summing ranges)

Key idea

  • AutoSum makes calculating totals easy by auto-selecting the relevant range.

Examples / steps

  • Sum across a row/section

    • Click the answer/target cell.
    • Click AutoSum (second AutoSum in the subtitles; likely the Σ button).
    • Press Enter.

  • Re-run AutoSum quickly

    • Double-clicking AutoSum can reuse the logic (as described).

  • Faster clearing + re-summing

    • Select a range, press Delete to clear.
    • Select the range again and press AutoSum to fill sums automatically.

  • One-time sum for the entire selected area

    • Select the whole range.
    • Press AutoSum once:
      • It sums everything at once.

4) Printing basics (Print Preview, centering, orientation, fit-to-one-page)

Key idea

  • Beginners often get confused about what fits on one printed page and where page breaks occur.
  • Use Print Preview to see page boundaries.

Examples / steps

  • Use Print Preview to control alignment

    • Go to File > Print and open Print Preview.
    • Check/adjust:
      • Horizontal alignment vs skewed alignment.
    • Confirm by clicking OK to apply centered alignment.

  • Change orientation

    • Switch from Horizontal to landscape (described as selecting Horizontal to change orientation in the subtitles).

  • Understand page size and page breaks

    • In Print Preview, dotted guidelines indicate paper size.
    • Large tables will split across multiple sheets.

  • Force a large table onto one page

    • Go to File > Print.
    • Under Current Paper Settings, choose Fit Sheet to One Page.
    • Apply so the entire sheet/table prints on a single page.

  • Revert back

    • Use Fit Sheet again (as described) to return to prior/default settings.

5) Table input + formatting + borders (so it prints properly)

This section combines efficient typing and formatting borders/backgrounds.

A) Faster keyboard-based table entry

  • Use the arrow keys to move within cells.
  • Rules described:
    • Enter moves down.
    • Tab moves right.
    • For moving faster to a starting cell:
      • Use Tab multiple times, then Enter as needed.
  • Comparison described:
    • Entering with arrow keys may require more manual movement afterward.
    • Tab/Enter combos speed up structured data entry.

B) Make borders visible (apply borders)

Problem described

  • Gridlines you see during editing aren’t always visible in printed output.
  • To show table lines in printing:
    • Apply borders.

Examples / steps

  • Select the table range.
  • In formatting (Font group per subtitles):
    • Choose All Borders.
  • Add alignment
    • Center align cells as needed.
  • Add background color
    • Use the paint bucket tool to select a fill color.
    • Darken or style the outline as desired.
  • Title formatting (merging cells)
    • For a title spanning multiple columns:
      • Selecting and centering normally centers within a single cell.
      • Instead:
        • Merge cells across the title range.
        • Then center-align the merged cell.
  • Adjust font size (example described):
    • Increase font size (click Up three times).

C) Verify by printing

  • Click Print in the file menu.
  • Confirm that borders and formatting appear as intended.

6) Filters (find only the rows you want)

Key idea

  • Filters let you quickly show only matching records within a dataset.

Examples / steps

  • Enable filtering

    • Click inside the table.
    • Go to the Data section and click Filter.
    • A dropdown button appears next to the header row.

  • Filter by a category

    • Click the dropdown on Category.
    • Uncheck Select All.
    • Select only one item (e.g., T-shirts), then OK.

  • Check that filtering is active

    • Look for the filter icon next to the header (e.g., beside “Category”).

  • Filter by another condition

    • Use the dropdown again and select Shipped Out (or other statuses).

  • Remove filter

    • Click Remove Filter (repeat as needed per subtitles).

  • Numeric filtering

    • Use the dropdown on Sales.
    • Select Greater than or equal to.
    • Enter the threshold (example: 300,000 won).
    • Click OK to show only rows meeting the condition.

Source(s) / speakers featured (as stated in subtitles)

  • Video speaker/host (unnamed): Narrates and demonstrates the Excel features.
  • Book source (referenced by subtitles):
    • Anyone Can Learn Excel (recently published book)
  • Music: “k [Music]” appears at the end (no specific artist named in subtitles).

Original video