Business Analytics
1
Introduction to Basics of Business Analytics
2
Types and Areas of Business Analytics
Custom and Conditional Formatting
1
Logical Functions, Lookup and Reference Functions
2
VLOOKUP, HLOOKUP, MATCH, INDEX AND OFFSET, Statistical, SUMIFS, COUNTIFS, PERCENTILE and QUARTILE, STDEV,MEDIAN, RANK
Pivot Table and Analyzing Data with Pivot Tables
1
Pivot Table, Grouping, Custom Calculation, Calculated Field and Calculated Item, Slicer
Dashboards
1
Principles and Creation, Chart Creation and Formatting (Pareto and Thermometer Chart)
2
Form Controls and Chart with Checkbox, Interactive Chart
Business Analytics with Excel
1
Video Histogram, Solver Addin, Goal Seek, Scenario Manager, Data Table, Descriptive Statistics
Data Analytics Using Statistics
1
Moving Average, Hypothesis Testing, Anova, Covariance, Correlation, Regression, Normal Distribution
Power BI
1
Power Pivot, View, Query, Map
Projects to Provide Hands-on Experience
1
Projects to Provide Hands-on Experience
Be the first to add a review.
Please, login to leave a review
