Excel: circular reference

Learn how to use iterative calculation and fight with circular references
3.2 (33 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.
1,509 students enrolled
$20
Take This Course
  • Lectures 16
  • Contents Video: 1 hour
  • Skill Level Intermediate Level
  • 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 8/2015 English

Course Description

08/08/2015 Update: 463 student from 74 countries enrolled the course during first 24h. Are you ready to be next?

Unique and exclusive training!

Have you ever created big nice Excel workbook based on great numbers of links and formulas? Where you expecting it to work without tuning up values? And once you have almost complete it after several hours of hard word, have you ever faced error message "Careful, we found one or more circular references in your workbook that might cause your formulas to calculate incorrectly"? Remember what you was feeling like? Annoyed? Frustrated? Willing to make circular... hole in your screen?

I know how to help you!

Circular references are useless and annoying, but that is only at first sight. In fact, if you learn how to use them you will be able to solve exotic and hard tasks very fast. Circular references aren't a bad thing in itself: you can use them to achieve complex calculations that are otherwise impossible to do.

If you are struggling to be real Excel professional, you need to have this tool in your portfolio! Stand out from friends and colleagues! Begin thinking wider in Excel!

Course is mainly focused on two key aspects of circular references: how to prevent and fix them if you do not need those and how you can use them for different tasks. Only practical side of the tool in easy to understand form followed with examples.

Files with all tasks are available for downloading along the course.

That is what you was looking for! And you will LEARN IT in 45 minutes!

What are the requirements?

  • How to create formulas

What am I going to get from this course?

  • Use iterative calculations
  • Avoid or fix circular reference
  • Understand calculation processes in Excel

What is the target audience?

  • Using excel every day
  • Working with Big Data
  • Need accurate data in worksheets
  • Hate annoying error messages
  • Want to learn new cool Excel feature

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: Fighting Circular Reference
Welcome and Cource overview
02:03
Section 2: Theoretical part
What is Circular Reference?
Preview
03:29
Preventing and fixing Circular reference
Preview
06:48
Tune Excel to use Circular Reference
Preview
04:19
5 questions

Did you got circular reference?

Section 3: Practice, Practice, Practice
Lesson #0: Warming Up
12:48
Lesson #1: task
00:39
Lesson #1: solution
01:16
Lesson #2: task
01:04
Lesson #2: solution
01:51
Lesson #3: task
01:08
Lesson #3: solution
01:56
Lesson #4: task
00:22
Lesson #4: solution
02:26
Lesson #5: task
00:51
Case #5: solution
03:54
Section 4: Summing up what you've learned
Summing up
00:36

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Alexander Kaliberov, MBA, Financial and manufacturing Analyst

Alexander has MBA in investment management and 5 years working experience on different analytic positions for several global FMCG companies (PMI, AB InBev, ets). Solid expertise in process creation and improvement, project management, software development, public speaking, self organization combined with creative and optimistic mind allowed Alexander to become corporate analitical consultant and trainer for wide range of aspects. As some key achievements of the last 5 years can be mentioned optimization project that saved more that 700 man-hours per month with only excel users performance improvement and effective control over 25 mio USD budget.

Before becoming a working professional Alexander had established and leaded a school of Entrepreneurship for high school students in Kharkiv, Ukraine involving experts from all around the globe to share their experience and support young people on bringing to life their business ideas. Also while being a student Alexander became an all-Ukraine champion for Computer Science for non programmers 3 years in a raw and deepened knowledge on software engineering, particularly web based applications (php, javascript, sql, css, xml, html).

Summing up, Alexander can and willing to share most effective practices from personal life with everyone who is struggling to continuous self-development and personal performance improvement.

Ready to start learning?
Take This Course