Скачать или смотреть Excel: Review, View & Help Tabs | Excel Full Course | Lecture 5

Unlock the full power of Excel’s Review, View & Help tabs with this easy tutorial — learn Protection, Macros, Freeze Panes, Workbook Views & Window tools (with practical examples).

In this video you’ll learn when and how to use high-impact tools like Protect Workbook/Worksheet (Allow Edit Ranges), recording/running Macros, keeping headers visible with Freeze Panes & Split, preparing for print with Page Break / Page Layout, comparing files using New Window / Arrange / View Side by Side, and quick proofing & accessibility checks. Perfect for busy professionals who want practical, searchable Excel skills. Whether you’re a beginner or improving your Excel skills, this video will save you time and make your work easier.

---

📌 What you’ll learn:

1. Proofing essentials: Spelling, Thesaurus & Workbook Statistics
2. Accessibility check & Translate — when and how to run them
3. Protection: Protect Workbook vs Protect Sheet + Allow Edit Ranges
4. Freeze Panes & Split to lock rows/columns while scrolling
5. Workbook Views: Page Break Preview, Page Layout & Custom Views for printing
6. Show group must-knows: Gridlines, Formula Bar, Headings, Data Type icons, Focus Cell
7. Zoom tricks: 100%, Zoom to Selection
8. Window tools: New Window, Arrange All, View Side by Side, Synchronous Scrolling, Hide/Unhide & Reset Window
9. Switch Windows & simple Macros (record → run) for automation
10. Help, Feedback & Show Training — get answers without leaving Excel

---

Timestamps
00:00 – Intro
00:21 – Review Tab
00:40 – Proofing: Spelling, Thesaurus & Workbook Stats
02:13 – Accessibility Checker & Translate
04:21 – Protection: Workbook vs Worksheet & Allow Edit Ranges
07:25 – View Tab
07:47 – Workbook Views: Page Break Preview / Page Layout / Custom Views
09:56 – Show group: Gridlines, Formula Bar, Headings, Data Type icons, Focus Cell
11:14 – Zoom options & Zoom to Selection
11:39 – Window Group: New Window, Arrange All, Hide/Unhide, Reset Window
12:18 – Freeze Panes & Split
13:22 – View Side by Side & Synchronous Scrolling (compare files)
13:53 – Macros: record & run
16:24 – Help, Feedback & Show Training

---

Why watch?
✅ Focused on the most-searched, high-impact tools (Protection, Macros, Freeze Panes, Views)
✅ Step-by-step examples you can apply right away
✅ Saves time and avoids common mistakes before sharing or printing

---

Resources / Downloads

Cheat Sheet: https://drive.google.com/file/d/1O5G2...

If this helped — please Like, Share, and Subscribe to Learn with Raju for weekly Excel tutorials. Tell me in the comments which tool you want a deep-dive on next!

#Excel #ExcelTips #ProtectSheet #Macros #FreezePanes #WorkbookViews #ViewSideBySide #Proofing #Accessibility #ExcelTutorial #ExcelInHindi