MIS & Data Analysis with EXCEL & ChatGPT

Advanced Excel for Data Analysis

Formulas and Functions

Charts and Graphs to present the data.

• Creating charts and graphs to visualize data
• Customizing charts to highlight important information.
• Identifying trends and outliers in data

Pivot Tables & Power Pivot – Advanced Pivot Techniques and Dashboards

• Pivot Tables for Reporting & Summarization: Different reports & layouts, Automating & updating pivots on data modification
• Data Modelling: Creating relationships between different data tables.
• Creating Calculated Columns and Measures: Using DAX (Data Analysis Expressions).
• PivotTables with Power Pivot: Creating advanced PivotTables using the Power Pivot model.
• Data visualization: Advanced charting techniques, Slicers, Sparklines and Timelines
• Use Case Example: Building a dynamic dashboard.

Power Query – Advanced Data Cleaning & Automation

• Data Import: Importing data from various sources (Excel, CSV, Folders, PDF, databases, web).
• Data Transformation: Cleaning, reshaping, and preparing data with Power Query.
• Merging and Appending Data: Combining & Consolidation data from different sources.
• Use Case Example: Automating data preparation for monthly reports.

Data Analysis – Advanced Analysis & Forecasting techniques

Scenario Planning and Analysis

• Creating Scenarios: creating and managing different scenarios.
• Analysing Scenarios: Techniques for comparing and analysing multiple scenarios to understand potential outcomes.

Solver Tool for Advanced Analysis techniques

• Setting Up Solver: Define and set up problem statements, constraints, and objectives in Solver.
• Running Solver: Executing Solver to find optimal solutions and interpreting the results.
• Practical Applications: Using Solver for resource allocation, cos t minimization, and other common research-related problems.

Automation with Macros and VBA

• Automating repetitive tasks and data processes.

CHATGPT and its integration with Excel

• Practical applications of ChatGPT in various Excel scenarios

Timings: 10:00 am – 5:30 pm, Registration begins at 9:30 am