Fraud Blocker
Announcement bar drops down here to inform users of the latest news and sales!

Excel Functions & Formulas: Cell References

18 minutes (1 section)

Course Description

Increased productivity leads to higher output in less time.
Using cell references in Excel can significantly increase productivity by enabling fast copying of formulas.

In this course, you’ll discover how to:
• Use relative and absolute references correctly,
• Copy and paste formulas in different ways,
• Add hyperlinks,
• Create absolute cell references with two different methods,
• Add, copy and update external links,
• And, use the ADDRESS function to return the reference to a particular cell as a text value.

Join us, and master this critical skill to create dynamic and scalable spreadsheets!

Share this course:

Related Courses

Learn how to plan, conduct, and evaluate job interviews in a way that supports fair hiring and a positive candidate experience.
4 videos
8 min
Why do people fear GMOs if science says they are safe? Learn how transparency and clear labeling can build consumer trust in food.
1 videos
4 min
Learn how to use kokorozashi to rediscover your purpose, overcome mid-career malaise, and take meaningful steps toward a more fulfilling career.
4 videos
19 min
Learn how to handle difficult workplace conversations with clarity, calm, and respect.
1 videos
2 min
Learn how self-compassion helps professionals respond to mistakes, reduce stress, and build resilience, growth, and healthier leadership at work.
4 videos
8 min

Start your free trial

Sign up to watch the rest of this course for free - no strings attached!
Continue with a subscription of USD 16.67 / month* after free trial ends
*USD 99.99 billed every 6 months