Back to Browse

"Stop Struggling with Excel! (Beginner Guide Part 2)"

19 views
Apr 14, 2026
1:09:33

Welcome back to our Beginner-Friendly Excel Series! In Part 1, we covered the absolute basics. Now, in Part 2, we are moving into the tools that actually make your data professional, readable, and error-free. Whether you are a student or looking to impress recruiters, mastering these specific groups in the Excel ribbon is a game-changer for your workflow. What You Will Learn in This Video: The Power of Formatting: Master the Font and Number groups to handle currencies, percentages, and separators correctly. Grid Mastery: How to draw borders manually and automatically for a cleaner look. Conditional Formatting: Learn how to make your data speak by highlighting trends automatically. The Editing Group: Understanding Clear all, Sort, Filter, and Fill to manage your data sets faster. Formulas Auditing: A deep dive into the Show Formulas tool to help you troubleshoot your work. View & Window Settings: Learn the "Life-Saving" Freeze Panes trick to keep your headers visible no matter how big your sheet is. Chapters: 00:00 - Introduction & Part 2 Overview 01:43 - Lesson 1: Understanding Workbook & Worksheet. 22:18- Lesson 2: Mastering the Clipboard Group (Paste, Cut, Copy). 28:49 - Lesson 3: Font Group & Formatting (Bold, Italicize, Colors). 35:16 - Lesson 4: How to Draw Border Grids Manually & Automatically. 37:56 - Lesson 5: Number Group (Currency, Separators, & %). 40:37 - Lesson 6: Conditional Formatting Basics. 48:54 - Lesson 7: Editing Group (Clear All, Sort, & Filter). 50:37- Lesson 8: How to Take Screenshots & Use Textboxes. 52:43 - Lesson 9: How to use Textbox. 1:02:57 - Lesson 10: Formula Auditing (Show Formulas). 1:05:53 - Lesson 11: Mastering Zoom group. 1:09:04- Lesson 12: Window Group & Freeze Panes (Top Row/Column). Kindly like, Share , Subscribe and Stay Tuned for more.

Download

1 formats

Video Formats

360pmp467.5 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

"Stop Struggling with Excel! (Beginner Guide Part 2)" | NatokHD