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

Business microlearning from Japan’s No1 MBA

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

Apply Bayes’ Theorem to real-world business challenges to strengthen analytical thinking and data-driven decisions under uncertainty.
4 videos
10 min
Web2 gave us connection; Web3 gives us ownership. Explore decentralization and the future of the web.
1 videos
5 min
Learn AI in the 90s! Host Chad Allman combines AI tools Gemini & Firefly to design a motivational poster for the office.
1 videos
5 min
Learn how to use proven frameworks CO-STAR, CRISPE, and BAB to write clear, structured prompts that produce more accurate, tailored AI responses.
5 videos
7 min
Discover what kokorozashi is and how to begin developing your own personal mission.
4 videos
9 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