Excel: circular reference
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,513 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel: circular reference to your Wishlist.

Add to Wishlist

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,513 students enrolled
Last updated 11/2015
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use iterative calculations
  • Avoid or fix circular reference
  • Understand calculation processes in Excel
View Curriculum
Requirements
  • How to create formulas
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!

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Fighting Circular Reference
1 Lecture 02:03
Welcome and Cource overview
02:03
+
Theoretical part
3 Lectures 14:36



Did you got circular reference?

Are you ready to work with Circular Reference
5 questions
+
Practice, Practice, Practice
11 Lectures 28:15
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
+
Summing up what you've learned
1 Lecture 00:36
Summing up
00:36
About the Instructor
Alexander Kaliberov
3.5 Average rating
37 Reviews
1,513 Students
1 Course
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.