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

Business microlearning from Japan’s No1 MBA

検索
Close this search box.
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

This discussion panel from the 2024 G1 Silicon Valley conference focuses on the divided political and social climate in the US and the role media companies play.
6 videos
59 min
This discussion panel from the 2024 G1 Silicon Valley conference features tech and design leaders as they share how AI is transforming how we live and work.
7 videos
59 min
This discussion panel from the 2024 G1 Silicon Valley conference features experts in design and technology as they discuss how these two fields are converging.
8 videos
59 min
Curious about NFTs? Learn what they are, how they're made, and the pros and cons of digital asset ownership.
1 videos
2 min
Discover omotenashi in a galactic adventure! Learn timeless hospitality principles with Dave aboard the Starship Orbiter!
1 videos
11 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