Excel: circular reference

Learn how to use iterative calculation and fight with circular references
3.5 (37 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,512 students enrolled
50% off
Coupon valid until Mar 1, 2017 7:59 AM UTC
Take This Course
  • Lectures 16
  • Length 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 8/2015 English

Course Description

1500+ students already in circular references. 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

Who 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.


Section 1: Fighting Circular Reference
Welcome and Cource overview
Section 2: Theoretical part
What is Circular Reference?
Preventing and fixing Circular reference
Tune Excel to use Circular Reference
5 questions

Did you got circular reference?

Section 3: Practice, Practice, Practice
Lesson #0: Warming Up
Lesson #1: task
Lesson #1: solution
Lesson #2: task
Lesson #2: solution
Lesson #3: task
Lesson #3: solution
Lesson #4: task
Lesson #4: solution
Lesson #5: task
Case #5: solution
Section 4: Summing up what you've learned
Summing up

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Alexander Kaliberov, Financial and manufacturing Analyst

Alexander has Master degree in Business Administration at the area of investment management and 5 years working experience on different analytic positions for several global FMCG companies (PMI, AB InBev). 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 analytical consultant and trainer for wide range of aspects. As key achievements of the last 5 years are: building fully autonomous production team, roll out of manufacturing intelligence tool, optimization project to save 700+ man-hours per month with only excel users performance improvement and effective control over USD 25kk 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