Exploring the Analytics aspect of Excel using simple example
4.5 (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.
433 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Exploring the Analytics aspect of Excel using simple example to your Wishlist.

Add to Wishlist

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.
4.5 (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.
433 students enrolled
Created by GreyCampus Inc.
Last updated 12/2015
English
Current price: $10 Original price: $200 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 5 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 13 Lectures Collapse All 13 Lectures 58:59
+
Course Introduction
1 Lecture 02:22
+
Reducing speculation with What-If-Analysis
1 Lecture 13:54
+
Quick Analysis Tools
1 Lecture 06:03
Quick Analysis Tools
06:03
+
Understanding terms used in Analytics
1 Lecture 03:25
+
Finding co-relation in any given data set
1 Lecture 12:08
Finding co-relation in any given data set
12:08
+
Using Excel Forecasting techniques to demonstrate regression
1 Lecture 09:49
+
Displaying regression equations on Chart
4 Lectures 08:59
Displaying regression equations on Chart
08:54

Introduction to what-if analysis
00:01

Calculate multiple results by using a data table
00:01

Excel Regression Analysis Output Explained
00:01
+
Practice Test
0 Lectures 00:00
Practice Test 1
20 questions

Practice Test 2
20 questions
+
Exercises
1 Lecture 00:00
Exercises
1 page
+
Course Conclusion
2 Lectures 02:22
Review Appreciated
00:15

Quick Bonus for You!
02:07
About the Instructor
GreyCampus Inc.
3.9 Average rating
1,721 Reviews
21,031 Students
42 Courses
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.