Location

Community Services & Continuing Education - Alexandria

Objectives

• • Understand what business analytics means and its importance in industry.• Grasp fundamentals of excel analytics functions and conditional formatting.• Learn how to analyses with complex datasets using pivot tables and slicers.• Solve stochastic and deterministic analytical problems using tools like scenario manager, solver and goal seek.• Apply statistical tools and concepts like moving average, hypothesis testing, ANOVA and regression to data sets using excel.Represent your findings using charts and dashboards get introduced to the latest Microsoft analytic and visualization tools

Outcomes

Upon successful completion of this course , participants will be able to:• Understand key concepts in the field of Business Intelligence and its important role in helping businesses achieve their goals.• Be more productive and creative in their use of Excel for business data analysis and reporting.• Use powerful excel functions like Lookup functions and others to undertake more dynamic calculations and analysis.• As well as use Text functions to manipulate data into desired formats.• Employ Goal Seek and Scenario Manager to conduct sensitivity analysis and solve practical business problems.• Utilize PivotTables and slicers to conduct more effective data manipulation and analysis.• Create effective charts and dashboards in Excel for improved data visualization.• Import data from online and other sources into Excel to facilitate analysis.

Course Contents

• Building Spread Sheet• Drawing Chart (Chart types)• Business Analytics with Excel.• Introduction to Business Analytics.• Formatting Conditional Formatting and Important Functions.• Analyzing Data with Pivot Tables.• Data Analysis Using Statistics.• What If Analysis• Goal Seek• One-Tow Dimension Table• Combining Table with Data base Function• Analyzing Data with Moving Averages.• Forecast Function• Correlation Function