Short Courses

- Worksheet Setup
- Data Validation
- Input Cells Formatting
- Data Entry
- Shortcuts
- Capstone Project
- Documentation

- Basic IF Function
- Multiple Conditions with Nested IF
- Using IF with Text Values
- Nested IF with Logical Operators
- Handling Errors with IFERROR
- Using IF with Dates
- Using IF with Blank Cells
- Applying IF Across Worksheets
- Using IF with Text Functions

- Highlighting Cells Based on Values
- Data Bars for Visualization
- Icon Sets for Comparative Analysis
- Color Scales for Gradient Effects
- Highlighting Duplicate or Unique Values
- Creating Custom Conditional Formatting Rules
- Clearing Conditional Formatting Rules
- Managing Conditional Formatting Rules
- Copying Conditional Formatting
- Capstone Project

- Creating Pivot Tables
- Customizing Pivot Tables
- Calculated Fields
- Table Level Calculations
- Pivot Formatting
- Data Visualization with Pivot Charts
- VLOOKUP
- HLOOKUP
- NESTED VLOOKUP
- LOOKUP WITH ERROR HANDLING
- VLOOKUP WITH PIVOT TABLES

- Data Import
- Identify Data Quality Issues
- Handle Missing Values
- Remove Duplicates
- Standardize Data Formats
- Split and Merge Columns
- Data Validation
- Transpose Data
- Pivot Data

-Dynamic Data Range Setup
- Basic Chart Creation
- Adding Data Labels
- Dynamic Chart Title
- Adding Interactive Controls
- Data Series Selection
- Dynamic Axis Scaling
- Conditional Formatting in Charts
- Dynamic Trendlines
- Dynamic Chart Range Update
- Interactive Chart Filters
- Global Filters
- Dynamic Chart Dashboards
- Capstone Project

- What-if Analysis
- Data Table
- Goal Seek
- Scenario Manager
- Forecast
- Capstone Project

- Worksheet Protection
- Workbook Protection
- Cell Locking
- Formula Protection
- Workbook Encryption
- Document Inspector
- Password Protection for VBA Code

- Data Connection
- Data Transformation & Cleaning
- Data Modeling
- Data Merging
- Data Pivot/Unpivoting
- Data Splitting
- Data Filtering and Sorting
- Data Aggregation
- Data Grouping
- Data Calculations
- Data Conditional Formatting
- Data Refreshing
- Check Data Hygiene
- Edit Changes
- Data Importing

- Data Modeling & Relationship
- Data Analysis
- Data Aggregation & Calculation
- Data Filtering and Sorting
- Data Slicers
- Data Pivot/Unpivoting
- Data KPIs
- Data Calculated Columns
- Data DAX Formulas
- Data Connections
- Data Tables
- Data Refreshing
- Data Importing
- Capstone Project

- Selection of Data
- Define Objectives and Audience
- Gather Data
- Finalize KPIs list
- Plan Dashboard Layout
- Design Worksheets
- Perform Data Analysis
- Design Visualizations
- Insert Charts and Graphs
- Add Interactivity in Dashboard
- Include Summary Metrics
- Ensure Consistency and Clarity
- Test and Review
- Capstone Project-1