Expert Programmes

Business Analytics with Excel Online Course

(0 review)
$599.00
Excel
(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

    Instructor

    0.0
    0 total
    5
    0
    4
    0
    3
    0
    2
    0
    1
    0

    Related Courses