Business Analytics with Excel Online Course
(All course fees are in USD)
Course Description
This Business Analytics with Excel Course is highly practical. You’ll learn basic concepts of data analysis and statistics, helping promote data-driven decision making. In addition, this course also includes business projects re practical application of Excel in business & real life situations, such as designing Sales Dashboard in Excel; predicting restaurant tips using predictive analytics in Excel etc.
Course Delivery
12 hours of online self-paced learning
Benefits
- 3 hands-on industry-based projects
- Practical exercises
- 1 year access to self-paced learning
Skills to be Learned
- Excel analytics functions
- Excel conditional formatting
- Pivot tables and slicers
- Scenario manager tool
- Solver tool
- Goal seek tool
- ANOVA
- Hypothesis testing
Award
Certificate of Achievement in “Business Analytics with Excel” issued by Simplilearn
Learning Outcome
- Understand the basic concepts of business analytics
- Analyze data with pivot tables
- Understand the principles of dashboard design and how to create charts in Excel
- Learn data analysis using statistics
- Understand conditional formatting and logical functions
Course Completion Criteria
- Complete at least 85% of the course
- Complete one project
Who Should Enrol
- Data analysts
- Analytics professionals
- Junior data scientists
- BI and reporting professionals
- Project managers
- IT developers and testers
- Anyone interested to delve deeper into functions & applications of Excel
Prerequisites
No prerequisite. But basic knowledge in Excel would be beneficial.
Course Overview
Introduction
Lesson 1 – Introduction to Business Analytics
Lesson 2 – Data Cleansing & Preparation
Lesson 3 – Formatting Conditional Formatting & Important Functions
Lesson 4 – Spotlight
Lesson 5 – Analyzing Data with Pivot Tables
Lesson 6 – Dashboarding
Lesson 7 – Business Analytics with Excel
Lesson 8 – Spotlight
Lesson 9 – Data Analysis using Statistics
Lesson 10 – Macros for Analytics
Lesson 11 – Spotlight
Accessible Period of Course
1 year from date of enrolment
Customer Reviews
Aman Saxena
I completed the Business Analytics with Excel course…. Through this course, I learned about how powerful and useful Microsoft Excel the modern era of IT. Excel is equipped with statistical tools and we learned techniques to help us to retrieve critical information from existing data……
Abdul Azeez VP
I …..enrolled in the Business Analytics with Excel course after deciding to pursue self-learning….. an excellent place to learn complex ideas online and has lifetime access to self-learning videos. I also got a good response from customer care & support whenever I had questions or issues.
Koumudi Oruganti
…..I have received one of the best services with top-quality online guidance and study material….. I highly recommend the self-paced learning program…… Their customer support is also very helpful and supportive.
Juhi Maheshwari
The session went smoothly and the overall experience was good. It offered good learning with examples from first-hand experience. Rajiv is a good teacher, explains everything in detail, backed with examples, tips, and techniques.
*Note:
(1) Course in collaboration with Simplilearn
(2) We reserve the right to revise/change any of the course content &/or instructor &/or removal of the course at our sole & absolute discretion, without prior notice to learner.
Course Features
- Students 1 student
- Max Students1000
- Duration12 hour
- Skill levelall
- LanguageEnglish
- Re-take course10000
-
Introduction
-
Lesson 1 – Introduction to Business Analytics
-
Lesson 2 – Data Cleansing & Preparation
-
Lesson 3 – Formatting Conditional Formatting & Important Functions
-
Lesson 4 – Spotlight
-
Lesson 5 – Analyzing Data with Pivot Tables
-
Lesson 6 – Dashboarding
-
Lesson 7 – Business Analytics with Excel
-
Lesson 8 – Spotlight
-
Lesson 9 – Data Analysis using Statistics
-
Lesson 10 – Macros for Analytics
-
Lesson 11 – Spotlight