Exploring the Analytics aspect of Excel using simple example

A drill down approach course helps you to perform different types of analysis that fit your needs.
5.0 (3 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
427 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 13
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

Course Description

Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the maximum. This Course emphasizes on 'Analytics' approach of Excel using simple examples. By this course, you will able to learn about the quality analysis tools, regression tools and forecasting techniques.

The forecasting techniques and data visualization explained in this course offer executives and other knowledge personnel, new approaches to dramatically improve their ability to grasp information hiding in their data.

What are the requirements?

  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment

What am I going to get from this course?

  • Appreciate data exploration utilities in Excel
  • Use ‘What-If-Analysis’ and Data representation techniques
  • Understand data co-relation for any given data set
  • Demonstrate forecasting techniques using Excel functions
  • Understand terms used in simple regression

What is the target audience?

  • Anyone who uses MS Excel as part of their job or profession can choose this course to get a hold of Lookup functions and increase their productivity
  • There is no eligibility Criteria

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Introduction
Course Introduction
Preview
02:22
Section 2: Reducing speculation with What-If-Analysis
Reducing speculation with What-If-Analysis
Preview
13:54
Section 3: Quick Analysis Tools
Quick Analysis Tools
06:03
Section 4: Understanding terms used in Analytics
Understanding terms used in Analytics
Preview
03:25
Section 5: Finding co-relation in any given data set
Finding co-relation in any given data set
12:08
Section 6: Using Excel Forecasting techniques to demonstrate regression
Using Excel Forecasting techniques to demonstrate regression
Preview
09:49
Section 7: Displaying regression equations on Chart
Displaying regression equations on Chart
08:54
Introduction to what-if analysis
Article
Calculate multiple results by using a data table
Article
Excel Regression Analysis Output Explained
Article
Section 8: Practice Test
Practice Test 1
20 questions
Practice Test 2
20 questions
Section 9: Exercises
Exercises
1 page
Section 10: Course Conclusion
Review Appreciated
Article
Quick Bonus for You!
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

GreyCampus Inc., Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.

Ready to start learning?
Take This Course