Advance Excel → Data cleaning and preparation - Home

Curriculum

20 Sections
80 Lessons
20 Weeks

Expand all sectionsCollapse all sections

Introduction to Excel
4
- 1.1
  Overview of the Excel interface
- 1.2
  Workbook and worksheet basics
- 1.3
  Cell basics: selecting, editing, and formatting
- 1.4
  Basic formulas and functions (SUM, AVERAGE, MIN, MAX)
Data Entry and Basic Formatting
4
- 2.1
  Entering and editing data
- 2.2
  Formatting cells (number, text, date formats)
- 2.3
  Using the Format Painter
- 2.4
  Conditional formatting basics
Basic Formulas and Functions
4
- 3.1
  Arithmetic operations in Excel
- 3.2
  Introduction to functions (SUM, AVERAGE, COUNT, COUNTA)
- 3.3
  Relative, absolute, and mixed cell references
- 3.4
  Using the AutoFill feature
Data Management
4
- 4.1
  Sorting and filtering data
- 4.2
  Using tables in Excel
- 4.3
  Data validation (dropdown lists, data types)
- 4.4
  Removing duplicates
Advanced Formulas and Functions
4
- 5.1
  Logical functions (IF, AND, OR, NOT)
- 5.2
  Lookup functions (VLOOKUP, HLOOKUP)
- 5.3
  Text functions (LEFT, RIGHT, MID, CONCATENATE)
- 5.4
  Date and time functions (TODAY, NOW, DATE, TIME)
Working with Charts and Graphs
4
- 6.1
  Creating and customizing charts (bar, line, pie, etc.)
- 6.2
  Using Sparklines
- 6.3
  Formatting chart elements
- 6.4
  Using trendlines and error bars
PivotTables and PivotCharts
4
- 7.1
  Introduction to PivotTables
- 7.2
  Creating and formatting PivotTables
- 7.3
  Using PivotCharts
- 7.4
  Grouping and filtering data in PivotTables
Advanced Data Analysis Tools
4
- 8.1
  Introduction to What-If Analysis (Goal Seek, Data Tables, Scenario Manager)
- 8.2
  Using Solver for optimization
- 8.3
  Creating and using Data Models
- 8.4
  Using Power Query for data import and transformation
Advanced Lookup Functions
4
- 9.1
  INDEX and MATCH functions
- 9.2
  Using XLOOKUP for more powerful lookups
- 9.3
  Combining functions for complex lookups
- 9.4
  Using INDIRECT for dynamic ranges
Working with Large Datasets
4
- 10.1
  Techniques for handling large datasets
- 10.2
  Using Excel’s built-in data tools (Remove Duplicates, Text to Columns)
- 10.3
  Advanced filtering techniques
- 10.4
  Introduction to Excel’s Power Pivot
Macros and VBA Introduction
4
- 11.1
  Recording and running Macros
- 11.2
  Understanding the VBA editor
- 11.3
  Writing simple VBA code
- 11.4
  Automating tasks with VBA
Data Cleaning Techniques
4
- 12.1
  Identifying and correcting data errors
- 12.2
  Using text functions for data cleaning
- 12.3
  Advanced Find and Replace techniques
- 12.4
  Data normalization techniques
Data Visualization Techniques
4
- 13.1
  Advanced chart types (Combo Charts, Waterfall, Funnel, etc.)
- 13.2
  Using conditional formatting for data visualization
- 13.3
  Creating and using Excel Dashboards
- 13.4
  Using Power BI with Excel for advanced visualization
Statistical Analysis in Excel
4
- 14.1
  Descriptive statistics (mean, median, mode, standard deviation)
- 14.2
  Using Analysis ToolPak for statistical analysis
- 14.3
  Hypothesis testing
- 14.4
  Regression analysis
Working with External Data
4
- 15.1
  Importing data from different sources (CSV, databases, web)
- 15.2
  Using Power Query for data connection and transformation
- 15.3
  Linking and embedding objects
- 15.4
  Data consolidation techniques
Collaboration and Sharing
4
- 16.1
  Protecting worksheets and workbooks
- 16.2
  Sharing and co-authoring workbooks
- 16.3
  Tracking changes and comments
- 16.4
  Using Excel Online and OneDrive for collaboration
Advanced Formulas and Arrays
4
- 17.1
  Using array formulas
- 17.2
  Introduction to dynamic arrays and spill functions
- 17.3
  Using SEQUENCE, SORT, FILTER, UNIQUE functions
- 17.4
  Advanced conditional formatting with formulas
Time-saving Tips and Tricks
4
- 18.1
  Keyboard shortcuts
- 18.2
  Using templates
- 18.3
  Customizing the ribbon and Quick Access Toolbar
- 18.4
  Best practices for efficient Excel use
Project Management with Excel
4
- 19.1
  Creating Gantt charts
- 19.2
  Using Excel for task management
- 19.3
  Resource allocation and tracking
- 19.4
  Project tracking and reporting
Capstone Project
4
- 20.1
  Applying learned skills to a real-world data analysis project
- 20.2
  Data cleaning and preparation
- 20.3
  Data analysis and visualization
- 20.4
  Presenting findings and insights

Call Us Chat With Us Live Consultation