Data Analysis and Visualization Using Microsoft Excel

Microsoft Excel is an important tool for data analysis. It helps organizations and companies to gain insights and make better business decisions. Instructor will helps you unlock the power of your organization's data using the data analysis and visualization tools built into Excel. Excel offers a large number of charts and graphing tools that complement its data analysis toolset.

Statistics transforms data into meaningful information, enabling organizations to make better decisions and predictions. That’s why statistics—collecting, analyzing, and presenting data—is a valuable skill for anyone in busines

Course Outline

Data formatting

• Alignment tools
• Numeric formats
• Data with conditional formatting
• Tables, Styles, and themes
• Row and Column Adjustments
• Power formatting techniques

Formulas and functions

• Tools
• IF and Related Functions
• Lookup and Reference
• Power Functions
• Statistical Functions
• Math Functions
• Date and Time Functions
• Reference Functions
• Text Functions
• Using Dynamics Array Functions
• Information Functions

Charts

• Overview
• Create Charts
• Fine-tune Your Charts
• Adjust Chart Elements
• Formatting Tab Options
• Working with Popular Chart Types
• Work with Specialized Excel Charts
• New Chart Types in Excel
• Work with different Chart’s Data Sources
• Print, Export and Share Charts

PivotTable

• Understanding Power Pivot
• Building a Basic Data Model
• Summarizing PivotTable Data
• Sorting and Filtering PivotTable Data
• Formatting PivotTables
• Applying Conditional Formats to
• Create and Manipulating PivotCharts
• Manipulating PivotTables
• Creating PivotTables using the Data Model
• Add Tables to the Data Model
• Print, Export and Share PivotTables

Visualization Dashboard

• Understand Visualization
• Setting Up the Supporting Workbook
• Create a Dashboard Worksheet
• Building a Dynamic Dashboard

Data Analysis

• Statistics Fundamentals
• Data Distributions
• Visualizing Distributions
• Business Intelligence
• Analysis of Variance, Co-variance
• Advanced Correlation
• Linear Regression
• Understanding Probabilities
• Description, Predictive and Prescriptive
• Testing of Hypotheses