Tips & Tricks Tuesdays week 1

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

H2
H3
H4
3 columns
2 columns
1 column
Join the conversation now