Fraud Blocker
Announcement bar drops down here to inform users of the latest news and sales!
Search
Close this search box.

Business microlearning from Japan’s No1 MBA

Search
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

Curious about startup funding? Discover the stages of venture capital, from idea pitches to market success, and understand their essential role.
1 videos
4 min
Learn the 3 steps of hou-ren-sou, a Japanese business framework that focuses on reporting, informing, and consulting; to ensure smooth communication and effective decision-making.
4 videos
10 min
Learn how companies use Generative AI for content creation in minutes, enhancing tasks and generating social media images.
1 videos
3 min
Master the ins and outs of Japanese train etiquette with Dave as he navigates the complexities of the public transportation system.
1 videos
9 min
Discover the steps of the Japanese business card exchange, and how to show respect and professionalism with your Japanese client interactions.
4 videos
8 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