Free ebook
Free ebook: Excel for Beginners
A complete starting point for Excel: the screen, entering and formatting data, how formulas work, the functions everyone should know, and a gentle introduction to charts and PivotTables.
Get the ebook4 subtopics in this path
Layout patterns, number formats, styles, sheet organization, workbook conventions, readability, and professional spreadsheet presentation.
Each item pairs the learning structure with curated public YouTube resources where available, so learners can move from outline to video practice quickly.
Separate inputs, calculations, reports, and notes so users can follow the workbook.
Leila Gharani
Open on YouTube (opens in a new tab)
KnowHow
Open on YouTube (opens in a new tab)Use formats and styles consistently for currency, dates, percentages, negatives, and headers.
Use clear sheet names, table of contents sheets, freeze panes, and section markers.
Control spacing, alignment, colors, borders, and visual hierarchy without over-decorating.
Real Excel screenshots showing what this topic looks like in practice.
Leila Gharani
Extracted from saved YouTube search results - titled "Do's & Don'ts of Spreadsheet Design (with Examples)", filed under Workbook Design Formatting.
Open on YouTube (opens in a new tab)LearnFree
Extracted from saved YouTube search results - titled "Understanding Number Formats", filed under Workbook Design Formatting for its number formats coverage.
Open on YouTube (opens in a new tab)KnowHow
Extracted from saved YouTube search results - titled "Mastering Number Formats in Currency, Percentage, and Date Formatting", filed under Workbook Design Formatting for its number formats coverage.
Open on YouTube (opens in a new tab)
Technology for Teachers and Students
Extracted from saved YouTube search results - titled "Number Formats Explained", filed under Workbook Design Formatting for its number formats coverage.
Open on YouTube (opens in a new tab)
Mind Your Exam Channel
Extracted from saved YouTube search results - titled "Number Formats in Number, Currency, Accounting, Percentage, Date, F...", filed under Workbook Design Formatting for its number formats coverage.
Open on YouTube (opens in a new tab)
Kmacims Education Annex
Extracted from saved YouTube search results - titled "Data Formatting Apply Currency, Percentage, Accounting Number Forma...", filed under Workbook Design Formatting for its number formats coverage.
Open on YouTube (opens in a new tab)26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
ExcelJet (opens in a new tab)
MyOnlineTrainingHub (opens in a new tab)
XelPlus (opens in a new tab)
Excel Campus (opens in a new tab)
Wise Owl (opens in a new tab)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)Course platforms
