MS Excel has many features that help in efficient data analysis. Some of the important features are:

• Pivot Tables
• Data analysis and data cleaning functions and formulas
• Power Pivot
• OLAP Pivot (Data model)
• ‘Power Query/Get and transform’ for data mashing
• Conditional formatting for data visualization
• Excel dashboards
• What IF, Scenario Manager, Forecasting
• Power BI Publisher
• Excel charts and graphs

​Homepage​​​
​MS EXCEL TRAINING​​​