ECMP 455 · Learning Project

Excel Tables (Continued)…


I could not finish with Excel Tables in my previous post. Today, I am going to talk about a couple of more functions that we can use in excel tables. I am using same set of excel data that I used for my previous post.

 To calculate revenue for a specific age group [IFS ( ) ]:

I hope I was clear enough in explaining how to use IFS ( ) function.

To calculate revenue by a sub-category [ IF() and Right ()]:

Now, let’s add a “Frame Size” column. Insert a new column to the left of the Order Quantity, and use formula to derive the frame size of a bicycle from the last two characters of the Product column, when the Product Category is Bikes. Otherwise, leave it blank.

Stay tuned for next episode !

2 thoughts on “Excel Tables (Continued)…

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s