MS Excel for Data Analytics: Workbook Management & Professional Formatting
Welcome to Lecture 2 of our specialized MS Excel for Data Analytics course series!
In this session, Dr. Muhammad Imdad Ullah from the Department of Statistics, Ghazi University, DG Khan, takes you from the absolute basics of workbook management to advanced visual formatting and practical data structuring.
This lecture is designed to help you transition from handling messy, manual data to creating clean, professional, and analytical-ready Excel sheets. All concepts are demonstrated using real-world practice data to ensure hands-on learning.
🔍 What You Will Learn in This Lecture:
Workbook & Sheet Management: Master saving, opening, and perfectly organizing your workspace. Learn how to rename, color-code, move, copy, and delete sheet tabs smoothly.
Professional Formatting Essentials: Make your data look highly professional. We cover font styles, font colors, fill colors, borders, text alignments, and crucial Number Formats (Currency, Percentages, Dates).
Time-Saving Shortcuts: Speed up your workflow with must-know keyboard shortcuts for saving and formatting.
Scenario-Based Data Note-Keeping: Learn the analytical mindset! Discover how to evaluate raw data for proper structure, readability, and correct data types before moving it into Excel.
Raw Data to Excel Conversion: Watch a live step-by-step demonstration of turning manual notes into clean, structured digital spreadsheets.
⏱️ Timestamps (Chapters)
00:00 - Review of previous Lecture
01:25 - Saving, Opening, & Organizing Workbooks
01:55 - Difference between Save and Save As
06:30 - Excel File Types (.xlsx and .csv)
08:20 - Organizing Sheet Tabs (Rename, Color, Move, Copy, Delete)
11:09 - Essential Formatting (Fonts, Alignment, & Borders) and shortcuts
12:32 - Adding border to cells
17:01 - Scenario-Based Data Note-Keeping Strategy
🎓 About the Instructor
Instructor: Dr. Muhammad Imdad Ullah
Department: Department of Statistics
Institution: Ghazi University, DG Khan
🔔 Don't forget to Like, Subscribe, and hit the Notification Bell to stay updated with the entire Data Analytics with MS Excel course series! Leave your questions in the comments below.
#MSExcel #DataAnalytics #ExcelShortcuts #DataScience #GhaziUniversity #Statistics #LearnExcel #DataStructuring