Business Analytics Certification Training with Excel
4.7 /5- Offered bySimplilearn
- Private Institute
- Estd. 2010
Business Analytics Certification Training with Excel at Simplilearn Overview
Duration | 15 hours |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
Future job roles | EAI, Ecommerce development, E-commerce development, Data Analyst |
Business Analytics Certification Training with Excel at Simplilearn Highlights
- Code a React app with an online IDE
- A great course for learning Business Analytics
- Certification Course
Business Analytics Certification Training with Excel at Simplilearn Course details
- Data Analysts
- Junior Data Scientists
- Project Managers
- Software Engineers
- Professionals who want to move to a data/business analytics profile
- Graduates who want to start a career in business intelligence/analytics
- 12 hours of High Quality e Learning content
- 2 projects to provide hands on experience
- Latest Excel 2016 and MS Power BI training
- 8 End of chapter exercises and 45 concept videos
- Downloadable e book
- Business analytics (BA) is the practice of iterative, methodical exploration of an organization's data, with an emphasis on statistical analysis.
- This Business Analytics Certification Training with Excel course has been designed specifically to initiate candidates to the world of analytics
- It provides extensive training to candidates on MS Excel, one of the most common analytical tools which will help in kick-starting their career in analytics
- Designed by some of the experts in the industry, this course provides a holistic learning experience to the candidates with quality learning modules
- It covers a plethora of topics like pivot tables, dashboarding, importing functions, and other related areas
- Candidates will get a course-completion certification
Business Analytics Certification Training with Excel at Simplilearn Curriculum
Introduction
Course Introduction
Introduction to Business Analytics
Introduction
What Is in It for Me
Types of Analytics
Areas of Analytics
Quiz
Key Takeaways
Conclusion
Formatting Conditional Formatting and Important Fuctions
Introduction
What Is in It for Me
Custom Formatting Introduction
Custom Formatting Example
Conditional Formatting Introduction
Conditional Formatting Example
Conditional Formatting Example
Conditional Formatting Example
Logical Functions
Lookup and Reference Functions
VLOOKUP Function
HLOOKUP Function
MATCH Function
INDEX and OFFSET Function
Statistical Function
SUMIFS Function
COUNTIFS Function
PERCENTILE and QUARTILE
STDEV, MEDIAN and RANK Function
Exercise Intro
Exercise
Quiz
Key Takeaways
Conclusion
Analyzing Data with Pivot Tables
Introduction
What Is in It for Me
Pivot Table Introduction
Concept Video of Creating a Pivot Table
Grouping in Pivot Table Introduction
Grouping in Pivot Table Example
Grouping in Pivot Table Example
Custom Calculation
Calculated Field and Calculated Item
Calculated Field Example
Calculated Item Example
Slicer Intro
Creating a Slicer
Exercise Intro
Exercise
Quiz
Key Takeaways
Conclusion
Dashboarding
Introduction
What Is in It for Me
What is a Dashboard
Principles of Great Dashboard Design
How to Create Chart in Excel
Chart Formatting
Thermometer Chart
Pareto Chart
Form Controls in Excel
Interactive Dashboard with Form Controls
Chart with Checkbox
Interactive Chart
Exercise Intro
Exercise
Exercise
Quiz
Key Takeaways
Conclusion
Business Analytics With Excel
Introduction
What Is in It for Me
Concept Video Histogram
Concept Video Solver Addin
Concept Video Goal Seek
Concept Video Scenario Manager
Concept Video Data Table
Concept Video Descriptive Statistics
Exercise Intro
Exercise
Quiz
Key Takeaways
Conclusion
Data Analysis Using Statistics
Introduction
What Is in It for Me
Moving Average
Hypothesis Testing
ANOVA
Covariance
Correlation
Regression
Normal Distribution
Exercise Intro
Exercise
Exercise Intro
Exercise
Exercise Intro
Exercise
Quiz
Key Takeaways
Conclusion
Power BI
Introduction
What Is in It for Me
Power Pivot
Power View
Power Query
Power Map
Quiz
Key Takeaways
Conclusion
Other courses offered by Simplilearn
Student Forum
Anything you would want to ask experts?