Big Data and AI

Lesson 4.5 – Removing Duplicates Duplicate values can cause errors, incorrect calculations, and misleading analysis. Excel provides a simple and reliable tool to remove duplicates from your dataset in just a few clicks. In this lesson, you will learn how to identify and remove duplicate rows safely. SEO Description Learn how to remove duplicate values in Excel using the built‑in Remove Duplicates tool to clean data quickly and accurately. Publication date: 19 March 2025 1. What Are Duplicates? A duplicate occurs when one or more rows contain the same information. Duplicates often appear when data is imported, copied from other files, or collected from multiple sources. Examples of duplicates: Two identical customer names Repeated product codes Duplicate email addresses Rows with the same values across all columns 2. How to Remove Duplicates Steps: Select your dataset (or click inside an Excel Table). Go to Data → Remove Dupl...

Lesson 4.4 – Conditional Formatting Conditional Formatting allows Excel to automatically highlight cells based on rules. It helps you identify trends, spot errors, and visualize patterns without creating charts. In this lesson, you will learn how to apply basic conditional formatting rules used worldwide. SEO Description Learn how to use Conditional Formatting in Excel to highlight values, apply color scales, add data bars, and visualize data instantly. Publication date: 17 March 2025 1. What Is Conditional Formatting? Conditional Formatting changes the appearance of a cell based on its value. Excel can automatically apply colors, icons, or data bars when certain conditions are met. Highlight values greater than 100 Color cells containing specific text Show data bars to compare numbers visually Highlight duplicate values 2. How to Apply Conditional Formatting Select the range you want to format. Go to Home → Conditional Fo...

Lesson 4.4 – Conditional Formatting Conditional Formatting allows Excel to automatically highlight cells based on rules. It helps you identify trends, spot errors, and visualize patterns without creating charts. In this lesson, you will learn how to apply basic conditional formatting rules used worldwide. 1. What Is Conditional Formatting? Conditional Formatting changes the appearance of a cell based on its value. Excel can automatically apply colors, icons, or data bars when certain conditions are met. Examples: Highlight values greater than 100 Color cells containing specific text Show data bars to compare numbers visually Highlight duplicate values 2. How to Apply Conditional Formatting Steps: Select the range you want to format. Go to Home → Conditional Formatting . Choose the rule type you need. Excel will instantly apply the formatting based on your rule. 3. Highlight Cell Rules These rules highlight cells base...

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...

Lesson 4.2 – Sorting and Filtering in Tables Sorting and filtering are two of the most powerful features of Excel Tables. They allow you to organize, analyze, and explore your data quickly and efficiently. In questa lezione impari come ordinare e filtrare i dati in modo professionale. 1. Sorting Data in a Table Sorting means arranging your data in a specific order, such as: Alphabetical (A → Z or Z → A) Numeric (smallest → largest or largest → smallest) Date order (oldest → newest or newest → oldest) How to sort: Click the filter arrow in the column header. Select Sort A to Z or Sort Z to A . Sorting inside a Table keeps all rows aligned, preventing data corruption. 2. Filtering Data in a Table Filtering allows you to show only the rows that match specific criteria. How to filter: Click the filter arrow in the column header. Check or uncheck the values you want to display. Use Text Filters , Number Filters , or Date F...

Lesson 4.1 – Creating and Formatting Tables Excel Tables transform a simple data range into a dynamic, structured, and easy-to-manage dataset. Tables automatically expand, apply formatting, update formulas, and provide powerful tools for sorting, filtering, and analysis. In questa lezione impari come creare e formattare una Tabella in modo corretto. 1. What Is an Excel Table? An Excel Table is a structured data container with built-in features such as: Automatic formatting Filter buttons on each column Dynamic expansion when adding new rows Structured references in formulas Optional Total Row for quick calculations Tables are essential for working with real datasets, reports, and dashboards. 2. How to Create a Table Method 1 – Using the Ribbon: Select your data range (e.g., A1:D20). Go to Insert → Table . Confirm the range and check “My table has headers”. Method 2 – Using the Shortcut: Ctrl + T This is the fastest and...

Module 4 – Working with Tables Excel Tables are one of the most powerful tools for organizing, analyzing, and updating data. Unlike normal ranges, Tables automatically expand, apply formatting, update formulas, and provide structured references that make your spreadsheets more reliable and easier to maintain. In this module, you will learn how to: Convert a normal range into an Excel Table Use Table features such as sorting, filtering, and banded rows Apply and customize Table styles Use structured references in formulas Add and remove columns dynamically Use the Total Row for automatic calculations Excel Tables are essential for anyone working with real datasets, reports, dashboards, business analysis, or automation. Once you understand how they work, they become an indispensable tool in your workflow. Lessons in This Module Lesson 4.1 – Creating and Formatting Tables Lesson 4.2 – Sorting and Filtering in Tables Lesson 4.3...

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...