Buying for a Team? Gift This Course
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.
432 students enrolled
Last updated 12/2015
$10 $30 67% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • 5 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

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
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
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
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
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
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

Introduction to what-if analysis

Calculate multiple results by using a data table

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

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

Quick Bonus for You!
About the Instructor
4.2 Average rating
1,539 Reviews
17,676 Students
35 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.

Report Abuse