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

Business microlearning from Japan’s No1 MBA

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

Master AI research tools. Discover how to inspect citations, verify sources, and use follow-up prompts to refine your results.
1 videos
5 min
As AI advances, learn about why it's critical for companies to consider governance, risk, and compliance.
7 videos
33 min
Discover how artificial intelligence is transforming modern organizational structures, leadership decision-making, and industry dynamics in the era of generative technology.
7 videos
36 min
Learn how to brainstorm with AI! See how clarifying prompts and adding detailed parameters guide AI to highly specific scenarios.
1 videos
5 min
Learn about differences between US & Japan Tech ecosystems and their impact on VC and startups in this panel from the 2026 G1 Silicon Valley Conference.
1 videos
60 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