Overview

Excel is the world's most widely used analysis tool and an excellent starting point for diving into data analysis!In this course, you will learn how to leverage Excel's built-in tools to organize your data into spreadsheets and tables, analyze it using Power Query, and extract meaningful insights using Pivot Tables. Finally, you will create an interactive Dashboard in Excel to visually represent those insights.By the end of this course, you will be able to:Analyze data using Excel's built-in tools Apply formulas and functions to structure and transform data Create Pivot Tables to slice, filter, and analyze datasets Power Query Fundementals Visualize data using Pivot Charts and Excel Charts Full Project with power BICourse ContentThis course blends theoretical and practical aspects to help you build a solid foundation in data analysis with Excel.Theoretical Section (Lectures 1-3):Lecture 01: Introduction to Data AnalysisUnderstanding Data ?Types of Data (Structured, Unstructured, and Semi-Structured)What is Data Analysis?Types of Data Analysis and Its ImportanceThe Data Analysis ProcessLecture 02-03: The Role of a Data AnalystWho is a Data Analyst?The Importance of Data Analysts in OrganizationsKey Skills of a Data AnalystPopular Data Analysis ToolsSteps to Build a Comprehensive Analytical ReportPractical Section (Lectures 3-12):Module 1: Data Analysis with Excel's Built-In ToolsLecture 3: Getting Started with Excel for Data AnalysisOrganizing Data in ExcelBasic Data Cleaning TechniquesSorting and Filtering DataLecture 4: Applying Formulas and Functions (Part 1)Common Excel Functions and Logical Functions (SUM, AVERAGE, COUNT,IF, etc.)Text Functions (CONCATENATE, LEFT, RIGHT, MID)Lecture 5: Applying Formulas and Functions (Part 2)Lookup Functions (VLOOKUP, HLOOKUP, INDEX-MATCH)Date and Time FunctionsModule 2: Power Query FundamentalsLecture 6: Introduction to tables and Power QueryWhat is Power Query? and Importing Data from Different SourcesTransforming Data with Power Query EditorLecture 7: Cleaning and Shaping Data with Power QueryRemoving Duplicates and ErrorsSplitting Columns and Merging QueriesAppending and Combining DataLecture 8: Exercises in Power QueryPractical Section (Lectures 3-12):Module 3: Pivot Tables for Data AnalysisLecture 9: Introduction to Pivot TablesWhat are Pivot Tables?Creating Your First Pivot TableBasic Aggregations (Sum, Count, Average)Slicing and Filtering DataGrouping Data in Pivot TablesCustom Calculations and Field SettingsVisualizing Data with Pivot ChartsCreating Pivot ChartsLinking Pivot Charts to Pivot TablesDynamic Dashboards with Pivot ChartsModule 4: Data Visualization: Excel Dashboards in Microsoft 365Lecture 10: Visualizing Data with ChartsCreating Bar, Line, and Pie ChartsCustomizing Chart ElementsBest Practices for Data VisualizationPractical Section (Lectures 3-12):Module 5: Full Project with power BILecture 11: Building Reports and Dashboards in Power BIImporting DataData Transformation with Power QueryBuilding the Data ModelDesigning the DashboardPublishing the Report

Skills

Reviews