Excel: circular reference
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.
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.
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!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Fighting Circular Reference|
Welcome and Cource overview
|Section 2: Theoretical part|
What is Circular Reference?Preview
Preventing and fixing Circular referencePreview
Tune Excel to use Circular ReferencePreview
|Quiz 1||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|
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.
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.