Introduction
- Course Introduction and About the Instructor
- Course Introduction
- Introduction to Excel Environment
- Microsoft Excel 101 - All about the Fundamentals of Excel
- Practice files and some Instructions
Flash Fill - A data Cleaning and Processing Feature
- Practice File for Flash Fill
- Introduction to Flash Fill - Magical Feature of Excel
- FlashFill for Joining Data in Excel
- FlashFill to Split Data
- FlashFill for Dates Extraction and Manipulation
- FlashFill for Formatting Data
- Flash Fill for Complex Data Situations
- Where Flash Fill would Fail
- FlashFill Assignment - Question
- Flash Fill Assignment Solution
- Flash Fill Answer File
- What have we Learnt so Far
Data Validation - A Data Collection and Data Quality Management Tool - Basics
- Practice File for Data Validation
- Introduction to Data Validation
- How Data Validation works
- Validating an input with certain number of characters
- Replicating Data Validation to Other Rows
- Validating an Input of Date values using Data Validation
- Enabling Input Message and Error Alert for Data Validation Cells
- Data Validation for Time Information
- Custom List of Items in Data Validation
- Data Validation Assignment Question
- Data Validation Assignment Solution
- Data Validation - Answer File
- Learning so Far
Filtering and Sorting - A Data Interpretation Tool
- Practice File for this Section
- Introduction to Filtering
- Applying Filter for the First Time
- Filtering Data On Misaligned Dataset
- Filtering Data on a Text based Information
- Filtering Date information with 1 criteria
- Filtering Date information with 2 criteria
- Filtering Time information with Multiple Criteria
- Filtering Data on Multiple Fields
- Introduction to Sorting
- Sorting Date Information
- Filtering and Sorting Dates
- Advanced Sorting Along with Filtering
- Practice File with Answers
- So Far in this Course
Excel Pivot Tables - A Data Analysis Tool
- Practice file for Pivot Tables
- The Business Story Continuation
- Pivot Tables Introduction
- Pivot Table Interface and our First Pivot Table
- How Pivot Table Works
- First Pivot Table with a Calculation
- Different Calculations from the Same Field
- Using Rows and Columns in Pivot Tables for the Same Field
- Using Rows and Columns for 2 different fields
- Managing Labels of a Complex Pivot Table
- Sorting Values in Pivot Table
- Label Filtering in Pivot Tables
- Values Filtering in Pivot Tables
- Report Level Filters in Pivot Tabels
- Formatting Values in Pivot Table
- Managing Date Information in Pivot Tables
- Multi Field Calculations in Pivot Tables
- Top 3 and Bottom 3 in Pivot Tables
- Changes in the Data Source
- Adding New Rows of Data to the Pivot Table - Manual Method
- Column Referencing and the Challenges of Blanks
- Range Vs Table Source for Pivot Tables
- Grouping Data in Pivots
- Using Slicers to Filter single and Multiple Reports
- Using Timelines to filter single and Multiple Reports
- Pivot Table Assignment Question Walkthrough
- Pivot Table Assignment Solution Walkthrough
- Our Learning So Far
- Practice File with Answers
Visualizing Data with Conditional Formatting - Basics
- Practice File for Conditional Formatting
- Challenges of Understanding Summarized Data
- How Effective is Conditional Formatting
- Understanding Data Bars and How it works
- Using Data Bars on Same Filed and Adjacent Field
- Customizing Data Bars
- Introduction to Color Scales
- Applying Color Scales on Pivot Table Report
- Customizing Color Scales
- Introduction to Icon Sets
- Applying Icon Sets on a Report and Customizing Criteria
- Customizing the Icon Sets
- Duplicates Highlight and Where Conditional Formatting Fails
- Conditional Formatting - Icon Sets and Top Bottom Rules
- Conditional Formatting Assignment Walkthrough
- Answer file for Conditional Formatting
- Learning so Far
Excel Formulas and Functions 101
- Why Use Functions or Formulas and its Fundamentals
- Excel Formula Vs Excel Function
