Excel Basics Part 2 – How Excel Displays Text, Numbers + Formatting

Excel Basics Part 2 continues with core Excel concepts that often confuse beginners — especially the difference between what you see in a worksheet and what actually exists inside a cell.

This video focuses on how Excel displays text and numbers, and how formatting affects appearance without changing the underlying data.

This video sticks to foundational skills and avoids formulas and functions, which are covered separately. The goal is to help you understand how Excel behaves so your worksheets make sense visually and structurally.

Chapters

00:00 – What you see is NOT always what you get in Excel
00:32 – Text visually overflowing into neighboring cells
01:10 – Using the Formula Bar to confirm true cell contents
01:39 – Displayed values vs underlying formulas
02:16 – Hidden text when typing over overlapping cells
02:55 – Wrap Text and automatic row height changes
03:28 – Resizing rows and columns by dragging
03:50 – Setting exact row height and column width
04:20 – Horizontal and vertical alignment options
05:05 – Increasing and decreasing indent inside cells
05:35 – Default number alignment and number formats
06:09 – Dates and number formatting behavior
06:39 – Controlling decimal places without changing values
07:34 – Why formatting does not change the real data

📌 For more clear computer skills explained in plain English, subscribe to the channel.

———
Learn more at https://ProfessorTanaka.com

Видео Excel Basics Part 2 – How Excel Displays Text, Numbers + Formatting канала Professor Tanaka