Tips & Tricks Tuesdays week 1

Words
163
Reading
1 min
Listen
Play
3y

We can use Named Ranges to make our formula/functions easier to understand/audit.

I just thought of sharing it as I clean up my templates.

Here's a sample for a Revenue - Cost = Profit:

Formula used in column D to get the Profit is
=Revenue-Cost

Normally, we use
=B2-C2

Oh and yes you can also do this in GoogleSheets. 馃槈


Still need help with Excel and Google Sheets?

Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

Get Instant Expert Help on Fiverr

Get Instant Expert Help in PeoplePerHour

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.


This post is designated as a reviewer for Excel trainings I conduct.

Feel free to share with anyone. 馃槈

Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva

Tips & Tricks Tuesdays week 1 | Ecency