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

Learn what adaptive thinking is and how it can help you react and thrive in today's fast-changing business environment.
4 videos
7 min
It's the 90s, but we're using ChatGPT! Learn to make spreadsheets (for tracking bathroom breaks) without knowing a single formula.
1 videos
6 min
Join University of Tokyo Professor Miles Pennington to hear the critical role design plays in innovation and how to promote this thinking in your company.
1 videos
9 min
Join Director of the TELL Lifeline in Japan, Vickie Skorji, as she covers common mental health challenges today and what company leaders can do to support employees.
1 videos
15 min
Hear from renowned author and professor of Japanese business, Ulrike Schade, on Japan’s evolving strengths and strategies in global business.
1 videos
17 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