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

Explore how everyday communication choices shape inclusion, access, and trust across teams and organizations.
4 videos
9 min
What is Omiyage? Discover the custom of bringing souvenirs to the Japanese office, before Dave destroys the space-time continuum.
1 videos
18 min
Learn how to approach recruitment and hiring as strategic, inclusive, and performance-driven processes that strengthen your organization.
4 videos
10 min
Dave has no idea what his new team does. Watch him learn how to run a Chorei, a morning meeting to align goals and communicate effectively.
1 videos
19 min
Learn what the dark web really is, how cybercriminals sell leaked passwords, and the steps you can take to protect your business.
1 videos
3 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