Big Data and AI

Lesson 4.3 – Filtering Data Filtering allows you to display only the rows that match specific criteria while temporarily hiding the rest. It is one of the most useful tools in Excel for exploring, cleaning, and analyzing data without modifying or deleting anything. 1. What Is Filtering? Filtering helps you focus on the information you need by showing only the rows that meet your conditions. You can filter text, numbers, dates, and even colors. Examples: Show only “Electronics” products Display sales greater than 500 Show dates from the last 30 days Filter rows with a specific color 2. How to Apply a Filter Method 1 – Using the Ribbon: Select your dataset. Go to Home → Sort & Filter → Filter . Filter arrows will appear on each column header. Method 2 – Using a Table: If your data is formatted as an Excel Table, filters are automatically enabled. 3. Filtering Text Text filters allow you to show rows that match specif...

Excel Basic Course – International Beginner Guide Welcome to the Excel Basic International Course , a complete beginner-friendly learning path designed to help you master the world’s most widely used spreadsheet tool. Whether you are starting from zero or refreshing your skills, this course will guide you step by step through the essential features of Microsoft Excel. By the end of this course, you will be able to create spreadsheets, use formulas, analyze data, build tables, create charts, and work efficiently using shortcuts and best practices adopted in professional environments worldwide. Why This Course Matters Excel is a global standard in business, finance, data analysis, project management, and everyday productivity. This course follows international standards aligned with: ICDL / ECDL – Spreadsheets MOS Excel Associate Microsoft 365 Fundamentals Corporate Excel onboarding programs Each lesson is clear, structured, and practical, wit...