Key features

MONEY BACK GUARANTEE

How this works :

At Simplilearn, we greatly value the trust of our patrons. Our courses were designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Self Placed Learning :

Raise refund request within 7 days of purchase of course. Money back guarantee is void if the participant has accessed more than 25% content.

  • 12 hours of self-paced video
  • 2 hands-on industry-based project on healthcare & ecommerce domains
  • Includes training on business intelligence using Power BI
  • 8 practical exercises
  • Downloadable e-book

Course description

  • What is this course about?

    Business Analytics with excel training has been designed to help initiate you to the world of analytics. For this we use the most commonly used analytics tool i.e. Microsoft Excel. The training will equip you with all the concepts and hard skills required to kick start your analytics career. If you already have some experience in the IT or any core industry, this course will quickly teach you how to understand data and take data driven decisions relative to your domain using Microsoft excel. For a new-comer to the analytics field, this course provides the best required foundation. The training also delves into statistical concepts which are important to derive the best insights from available data and to present the same using executive level dashboards. Finally we introduce Power BI, which is the latest and the best tool provided by Microsoft for analytics and data visualization.

  • What are the course objectives?

    With Simplilearn’s training on Business Analytics with Excel, you will be able to -
    • Understand what business analytics means and its importance in industry
    • Grasp fundamentals of excel analytics functions and conditional formatting
    • Learn how to analyse 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 i.e. Power BI

  • Who should do this course?

    The Business Analytics with excel is a great course for both beginners and experienced professionals who are uninitiated to or have recently stepped into the field of analytics. This course is beneficial for
    • IT developers & testers
    • Data analysts
    • Junior Data scientists
    • Analytics Professionals
    • BI and reporting professionals
    • Project managers
    • Students
    • Professionals working with data in any industry

  • What is prerequisite for this course?

    There are no prerequisites for this course other than an analytical bent of mind.
    We do expect the participants to have a basic knowledge of working with Microsoft Excel.

  • What projects will you be working on?

    Project 1 (Submission and Evaluation) - ECommerce
    The Analytics team of an Online E-Commerce Company wants to design a Sales dashboard to analyze the sales based on various product categories. The company wants to add user control for product category, so users can select a category and can see the trend month-wise and product-wise accordingly. The Analytics team also wants to create a histogram to analyze number of shipping days.

    Project 2 (Practice) – Pharmaceuticals and Healthcare
    The Analytics team of a pharmaceutical company wants to design a dashboard to analyze the sales of products across various regions and brands. It wants to create a chart with User control functionality, so users can easily see the total Sales and “commission of external agents” categorized by brands and region.

Course preview

    • Lesson 00 - Introduction 05:27
      • 0.1 Course Introduction 05:27
    • Lesson 01 - Introduction to Business Analytics 09:52
      • 1.1 Introduction 02:15
      • 1.2 What Is in It for Me 00:10
      • 1.3 Types of Analytics 02:18
      • 1.4 Areas of Analytics 04:06
      • 1.5 Quiz
      • 1.6 Key Takeaways 00:52
      • 1.7 Conclusion 00:11
    • Lesson 02 - Formatting Conditional Formatting and Important Fuctions 38:29
      • 2.1 Introduction 02:12
      • 2.2 What Is in It for Me 00:21
      • 2.3 Custom Formatting Introduction 00:55
      • 2.4 Custom Formatting Example 03:24
      • 2.5 Conditional Formatting Introduction 00:44
      • 2.6 Conditional Formatting Example1 01:47
      • 2.7 Conditional Formatting Example2 02:43
      • 2.8 Conditional Formatting Example3 01:37
      • 2.9 Logical Functions 04:00
      • 2.10 Lookup and Reference Functions 00:28
      • 2.11 VLOOKUP Function 02:14
      • 2.12 HLOOKUP Function 01:19
      • 2.13 MATCH Function 03:13
      • 2.14 INDEX and OFFSET Function 03:50
      • 2.15 Statistical Function 00:24
      • 2.16 SUMIFS Function 01:27
      • 2.17 COUNTIFS Function 01:13
      • 2.18 PERCENTILE and QUARTILE 01:59
      • 2.19 STDEV, MEDIAN and RANK Function 03:02
      • 2.20 Exercise Intro 00:35
      • 2.21 Exercise
      • 2.22 Quiz
      • 2.23 Key Takeaways 00:53
      • 2.24 Conclusion 00:09
    • Lesson 03 - Analyzing Data with Pivot Tables 19:32
      • 3.1 Introduction 01:47
      • 3.2 What Is in It for Me 00:22
      • 3.3 Pivot Table Introduction 01:03
      • 3.4 Concept Video of Creating a Pivot Table 02:47
      • 3.5 Grouping in Pivot Table Introduction 00:24
      • 3.6 Grouping in Pivot Table Example 1 01:42
      • 3.7 Grouping in Pivot Table Example 2 01:57
      • 3.8 Custom Calculation 01:14
      • 3.9 Calculated Field and Calculated Item 00:25
      • 3.10 Calculated Field Example 01:22
      • 3.11 Calculated Item Example 02:52
      • 3.12 Slicer Intro 00:35
      • 3.13 Creating a Slicer 01:22
      • 3.14 Exercise Intro 00:58
      • 3.15 Exercise
      • 3.16 Quiz
      • 3.17 Key Takeaways 00:35
      • 3.18 Conclusion 00:07
    • Lesson 04 - Dashboarding 32:07
      • 4.1 Introduction 01:18
      • 4.2 What Is in It for Me 00:18
      • 4.3 What is a Dashboard 00:45
      • 4.4 Principles of Great Dashboard Design 02:16
      • 4.5 How to Create Chart in Excel 02:26
      • 4.6 Chart Formatting 01:45
      • 4.7 Thermometer Chart 03:32
      • 4.8 Pareto Chart 02:26
      • 4.9 Form Controls in Excel 01:08
      • 4.10 Interactive Dashboard with Form Controls 04:13
      • 4.11 Chart with Checkbox 05:48
      • 4.12 Interactive Chart 04:37
      • 4.13 Exercise Intro 00:55
      • 4.14 Exercise1
      • 4.15 Exercise2
      • 4.16 Quiz
      • 4.17 Key Takeaways 00:34
      • 4.18 Conclusion 00:06
    • Lesson 05 - Business Analytics With Excel 25:48
      • 5.1 Introduction 02:12
      • 5.2 What Is in It for Me 00:24
      • 5.3 Concept Video Histogram 05:18
      • 5.4 Concept Video Solver Addin 05:00
      • 5.5 Concept Video Goal Seek 02:57
      • 5.6 Concept Video Scenario Manager 04:16
      • 5.7 Concept Video Data Table 02:03
      • 5.8 Concept Video Descriptive Statistics 01:58
      • 5.9 Exercise Intro 00:52
      • 5.10 Exercise
      • 5.11 Quiz
      • 5.12 Key Takeaways 00:39
      • 5.13 Conclusion 00:09
    • Lesson 06 - Data Analysis Using Statistics 31:57
      • 6.1 Introduction 01:51
      • 6.2 What Is in It for Me 00:21
      • 6.3 Moving Average 02:50
      • 6.4 Hypothesis Testing 04:20
      • 6.5 ANOVA 02:47
      • 6.6 Covariance 01:56
      • 6.7 Correlation 03:38
      • 6.8 Regression 05:15
      • 6.9 Normal Distribution 06:49
      • 6.10 Exercise1 Intro 00:34
      • 6.11 Exercise 1
      • 6.12 Exercise2 Intro 00:17
      • 6.13 Exercise 2
      • 6.14 Exercise3 Intro 00:19
      • 6.15 Exercise 3
      • 6.16 Quiz
      • 6.17 Key Takeaways 00:52
      • 6.18 Conclusion 00:08
    • Lesson 07 - Power BI 14:01
      • 7.1 Introduction 01:17
      • 7.2 What Is in It for Me 00:18
      • 7.3 Power Pivot 04:16
      • 7.4 Power View 02:36
      • 7.5 Power Query 02:45
      • 7.6 Power Map 02:06
      • 7.7 Quiz
      • 7.8 Key Takeaways 00:32
      • 7.9 Conclusion 00:11
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Exam & certification

  • How to get certified in Business Analytics with Excel?

    In order to get certified in Business Analytics with excel, the participant must complete and submit the evaluation project. On successful evaluation, the participant will receive the certification.

  • How will you do the projects?

    • Problem statements along with Data points are provided in the Learning Management System.
    • On the completion of the course, you have to submit the project which will be evaluated by the trainer. On successful evaluation of the project and completion of the online exam you will get a certification in Business Analytics using Excel from Simplilearn. You can submit your project through LMS.

  • What do I need to do to unlock my Simplilearn certificate?

    Online Self-Learning:
    • Complete 85% of the course.
    • Complete 1 project.

FAQs

  • What are the System Requirements?

  • Who are the trainers?

    Highly qualified and certified instructors with industry relevant experience deliver trainings.

  • Can I cancel my enrolment? Do I get a refund?

    Yes, you can cancel your enrolment. We provide a complete refund after deducting the administration fee. To know more, please go through our refund policy.

  • Who provides the certification?

    The certification is provided by Simplilearn.

  • What are the payment options?

    Payments can be made using any of the following options and a receipt of the same will be issued to you automatically via email.
    • Visa Debit/credit Card
    • American Express and Diners Club Card
    • Master Card
    • PayPal

  • Who are our Faculties and how are they selected?

    All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience.

    Each of them have gone through a rigorous selection process which includes profile screening, technical evaluation, and training demo before they are certified to train for us.  

    We also ensure that only those trainers with a high alumni rating continue to train for us.

  • What is Global Teaching Assistance?

    Our teaching assistants are here to help you get certified in your first attempt.

    They are a dedicated team of subject matter experts to help you at every step and enrich your learning experience from class onboarding to project mentoring and job assistance.

    They engage with the students proactively to ensure the course path is followed.

    Teaching Assistance is available during business hours.

  • What is covered under the 24/7 Support promise?

    We offer 24/7 support through email, chat, and calls.  

    We also have a dedicated team that provides on demand assistance through our community forum. What’s more, you will have lifetime access to the community forum, even after completion of your course with us.

Contact Us

+1-844-532-7688

(Toll Free)

People also bought this Masters Program:

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
/index/hidden/ - Never remove this line