Carry Marks Adjustment

Assalamualaikum..

Each year, I've seen my sister struggling to key-in, compile, calculate and adjust students' carry marks per agreed deadline..Without having much knowledge in Excel, she tend to do everything manually..not until we had the chance to sit together and solve the problems using Excel.

Calculating data using Excel might be simple to do but adjusting values to our expectation may require a bit of advance skill. Nevertheless, it is not a waste to try and come out with a suitable coding or formula to help with this situation.

As to solve the adjustment problem,  we use IF ELSE formulas like displayed in the example below; If you ever came across this problem, feel free to try this method and adjust the equations accordingly;

Inventory and Gross Profit Calculation

Assalamualaikum..

A few months ago, I joined an entrepreneurship training in Perak, as a facilitator. This training  was managed by FAMA as to help entrepreneurs managing their account and expenses accordingly. And most of the participants are small retailers which most of their products' price are subjected to Government price control. Hence, the profit is not that much compared to others.

So, as to adjust the profit margin, they have to closely monitor the stocks and % of discounts given to ensure that daily sales & profits are reachable within target.

Looking at their needs, then I have construct a simple but yet reliable application  to capture all the above aspects. This template is best used for ready made product and required to be key in daily for good results.

Feel free to try..;-)

Gender Identification Based On IC No. - Part2

Assalamualaikum

Further to our previous discussion on Gender Identification Based on IC, let's take a look for the 2nd case which is having data of IC Numbers without '-'.

The formula does not much differ compared to the 1st case. All you have to do is just eliminate the Right Formula while others are remain the same. Please refer pic below for easy reference;

Have a nice working days!

Gender Identification Based On IC No. - Part1

Assalamualaikum.

As per above title, i'm sure a lot of people has came across this topic in daily work or task. Without having a proper knowledge on Excel, may lead us to manually identify the gender one by one. If the data that required to be checked is very few, then it won't take much time. But if it is the other way around, then you are ADVISED to ask Excel to do the work. Why?? Because it SAVE much of your TIME!!

Now, what you have to do is just construct a simple formula in Excel and walla! the result is automatically displayed in just a few seconds.

As to help you understand better about what I was talking about, I've prepared an example with a suitable coding as shown in pic below;

Please take note that the formula is not absolute. Different people might apply different formula, depending on individual level of knowledge in Excel.

Hope this help! ;-)

Choosing Correct Price of Quantity Purchased (Staggered Price)

Assalamualaikum.

Masih lg fokus kt scope usahawan... Ada tak usahawan yang offer staggered price to customer depending on quantity purchased?

Cth: Beli 1->5 ea - price/unit = RM5.00
Beli 6->10 ea - price/unit = RM4.50
Beli 11->Above ea - price/unit = RM4.00

Instead of manually select the price, we can just ask Excel to do the work. Just plug in the quantity required in a correct database, Excel will automatically select the right unit price to be used. It is just as easy as ABC!!

Attached herewith is a sample of template that you can try!

Counting Orders (Mengira Order)

Ha, for the first time, moh kita tengok applikasi Excel dalam bisnes. Assuming we have a list of orders untuk t-shirt as below;

In order to know the exact quantity of orders for the respective sizes,  normally we have to manually calculate items one by one. This non value added process of course will take a lot of time depending on the number of orders received that day.

As to shorten the time, why not try using Excel to solve the problem! If you are using the correct formula to do your work, I'm sure you will save more time and most importantly obtain an accurate result.

Then, let's see how can we summarize the info using Excel;

In this example; i use COUNTIF formula as it suite with the problem. 

Hope that will help!

Pengenalan..

Assalamualaikum & Greetings to all..

I've been dreaming to have this kind of blog to share info related to Excel's application as to help people doing and solving their daily works fastest as they can. Either you are a lecturer, teachers, businessman, engineer and so on, Excel can play a vital role in solving your problems whenever you are dealing and analyzing large amount of data.

So, through time, i'll be sharing examples of application that commonly used and needed by most of us.