Excel Basics

Core workbook skills: navigation, data entry, formatting, printing, tables, and the habits that make every later Excel topic easier.

View subtopics All topics

=SUBTOPICS

What to learn inside Excel Basics

Each item pairs the learning structure with curated public YouTube resources where available, so learners can move from outline to video practice quickly.

01Beginner

Workbook layout and navigation

Understand sheets, rows, columns, cells, ranges, the ribbon, and common workbook views.

YOUTUBE

02Beginner

Data entry and editing

Enter values quickly, edit cells safely, fill series, use AutoFill, and avoid common entry mistakes.

QUICK NOTES

Double-click the fill handle (bottom-right corner of a cell) to auto-fill a formula down to match the length of an adjacent column, instead of dragging by hand.
Ctrl+D fills the selection down from the top row; Ctrl+R fills right from the left column.
Ctrl+E (Flash Fill) spots a pattern from one example and fills the rest -- useful for splitting or combining text without a formula.

03Beginner

Formatting and number formats

Format tables, dates, currencies, percentages, alignment, borders, and reusable cell styles.

YOUTUBE

04Beginner

Page setup and printing

Control print area, page breaks, headers, footers, scaling, margins, and PDF exports.

QUICK NOTES

Page Layout > Print Area > Set Print Area limits printing to a chosen range instead of the whole sheet.
View > Page Break Preview shows exactly where pages will split, and lets you drag the blue lines to move a break.
Use Page Layout > Margins/Orientation/Size for the basics before reaching for Scale to Fit -- most print surprises come from skipping this step.

05Intermediate

Workbook protection basics

Lock cells, protect sheets, hide formulas, and understand what protection does and does not secure.

QUICK NOTES

Protect Sheet stops accidental edits to locked cells; it is not encryption and does not stop someone from opening the file.
For real confidentiality use File > Info > Protect Workbook > Encrypt with Password, which requires a password just to open the file.
Cells are locked by default -- unlock the ones meant to stay editable (Format Cells > Protection) before turning Protect Sheet on.

=PREVIEW