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

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 what stress really is, why it matters, and how to manage it through practical strategies that boost resilience and support sustainable performance.
4 videos
9 min
DEI unlocks innovation & fairness at work. Learn how to build a culture where everyone thrives ethically and profitably.
1 videos
2 min
Learn how stakeholder buy-in turns ideas into action through trust, alignment, and strategies that build lasting support.
3 videos
8 min
Discover how the design thinking process and mindset can help you overcome complex business problems through fresh, creative approaches.
7 videos
22 min
Discover how strategic planning drives long-term success by aligning goals, guiding decisions, and turning vision into action.
3 videos
12 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