In this course, we’ll explore the basics of Google Sheets — one of the most important tools for every data analyst. You’ll learn how to create, edit, and format data in Sheets, use rows and columns effectively, freeze headers, auto-fill values, and even apply number formats. By the end of this session, you’ll have a solid foundation in Google Sheets — a skill every data analyst must master before diving into advanced data cleaning and visualization. 📚 What you’ll learn in this course: 00:00 - Introduction 00:30 - How to open Google Sheets 01:10 - Understanding cells, rows & columns 03:00 - Basic formatting (alignment, colors, font) 04:30 - Adding & deleting rows/columns 06:10 - Freezing headers for better data visibility 07:00 - Auto-fill and smart data patterns 09:00 - Formatting numbers, currencies & dates 10:30 - Summary & next steps

In this course, you’ll learn how to create Quick Charts in Google Sheets to visualize your data effectively. Charts make raw data easy to understand — whether it’s sales, expenses, or any dataset you work with. In this course, you’ll learn: How to insert charts in Google Sheets Difference between Pie Chart and Bar/Column Chart Customizing chart titles, axes, and legends Adding and removing data series Enabling 3D charts and adjusting chart styles

In this session, we’ll dive deep into Filters in Google Sheets - one of the most powerful and essential tools for every data analyst. You’ll learn how to: ✅ Apply filters and understand their purpose ✅ Sort data alphabetically and numerically ✅ Use filter by condition for smarter selections ✅ Filter by text, number, or date ✅ Quickly remove or reapply filters ✅ Sort and filter large datasets easily Timestamps: 00:00 Introduction 00:35 What are filters? 02:00 Applying filters in Google Sheets 04:30 Filter by condition 06:10 Sort data A to Z / Z to A 07:45 Remove & reapply filters 09:00 Sort by color 09:45 Wrap-up

In this session, we dive deep into two powerful Google Sheets features — Data Validation and Conditional Formatting. These tools help you keep your data clean, structured, and visually meaningful. In this video, you’ll learn: What is Data Validation and why it’s important How to create dropdown lists and restrict invalid entries Using Conditional Formatting for visual data insights Custom rules for numbers, text, and dates Real-world examples to make your sheets smarter and more interactive By the end of this tutorial, you’ll be able to build error-free and visually clear datasets — a key skill for every data analyst.

In this session, we’ll explore one of the most fundamental and essential parts of data analysis — Formulas in Google Sheets. You’ll learn: ✅ How to create and apply basic formulas ✅ Multiplication and division operations in spreadsheets ✅ Using the SUM, AVERAGE, MIN, and MAX functions ✅ Tips to make your data neat using text wrapping and alignment ✅ How to quickly calculate total sales and profit per quantity By the end of this video, you’ll have a strong understanding of how formulas make your data work smarter — not harder! 📊 Topics Covered: Understanding cell references (B2, C2, etc.) Formula basics in Google Sheets Sum, Average, Min, Max functions Auto-fill and drag formulas Data formatting for better readability

In this 8th video, we’ll learn one of the most practical and essential skills every data analyst must know — Data Cleanup in Google Sheets. You’ll discover how to: ✅ Remove unnecessary whitespaces ✅ Identify and delete duplicate rows ✅ Use the “Data Cleanup” feature effectively ✅ Make your dataset clean, structured, and ready for analysis Data cleaning is a real-world skill that makes you job-ready as an analyst. In upcoming videos, we’ll move on to real projects — applying all the skills you’ve learned so far!