MIS and Excel Analysis using Excel

Course Content

Data Analysis in Excel

• Organizing data for analysis
• Data cleaning and preparation techniques

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

PivotTables and Data Modeling

• Creating and manipulating PivotTables to summarize and analyze data
• Understanding data modeling and its importance in data analysis
• Creating and using data models to analyze large datasets
• Using Excel add-ins to extend functionality

Power Query & Power Pivot for advanced data analysis

Power Query: a data transformation and cleaning tool that helps you easily connect to and transform data from various sources.

• Quickly clean and shape data with an intuitive interface
• Combine data from multiple sources, like Excel sheets, PDF, Folders, CSV files, and databases
• Transform data using over 300 built-in functions and formulas
• Automatically refresh data with the click of a button

Power Pivot: an advanced data modeling tool that helps you analyze large datasets and create complex relationships between data.

• Quickly analyze large datasets without the need for complicated formulas or macros
• Create and manage relationships between multiple tables with ease
• Create custom calculations and measures with DAX formulas
• Build interactive reports with PivotTables, PivotCharts, and Slicers
• Work with larger datasets without the need for complex formulas or macros
• Create complex relationships between data that can help you gain insights and make better decisions
• Build interactive reports and dashboards that can help you easily communicate your findings to others