Tutorial Excel or Google Sheet (Free Service)

[Rm6A1k]

Hello po , baka po meron kayong gustong itrack or something na project gamit ang MS Excel, tulad ng paggawa ng dashboard/s either for personal use niyo or kahit anong eme -- usap po tayo, willing po akong gumawa para sa inyo, walang bayad. Kailangan ko lang po mapractice MS Excel skill ko.

 

[Blasphemer-Spirit]

Pagawa po ako MRP system using excel

 

[Pinsan ni Einstien]

Pa help naman po. For example po may Main Sheet ako, dun naka input lahat ng data, which includes Entry Number, Department, Type of Expenses, Amount of Expense etc.
Then next Sheet po (Sheet 1) na filtered na yung specific Department , then sorted na po yung Type of Expenses etc. then next sheet (Sheet 2) another Department naman po then same sa unq, naka sort na din data. Possible po kaya yun na sa main na lang mag input ng data then mag auto sort na sya s corresponding sheet kung saan andun ang particular Department nya? Ang naisip ko lang po kasi is using equal formula kaso sa dami ng departments (almost 20) then Expenses type (almost 50-60) baka di na ko matapos , haha

 

[Vil_n]

Pa help naman po. For example po may Main Sheet ako, dun naka input lahat ng data, which includes Entry Number, Department, Type of Expenses, Amount of Expense etc.
Then next Sheet po (Sheet 1) na filtered na yung specific Department , then sorted na po yung Type of Expenses etc. then next sheet (Sheet 2) another Department naman po then same sa unq, naka sort na din data. Possible po kaya yun na sa main na lang mag input ng data then mag auto sort na sya s corresponding sheet kung saan andun ang particular Department nya? Ang naisip ko lang po kasi is using equal formula kaso sa dami ng departments (almost 20) then Expenses type (almost 50-60) baka di na ko matapos , haha

Pivot table sir, search ka lang kung pano gamitin

 

[Rm6A1k]

Pa help naman po. For example po may Main Sheet ako, dun naka input lahat ng data, which includes Entry Number, Department, Type of Expenses, Amount of Expense etc.
Then next Sheet po (Sheet 1) na filtered na yung specific Department , then sorted na po yung Type of Expenses etc. then next sheet (Sheet 2) another Department naman po then same sa unq, naka sort na din data. Possible po kaya yun na sa main na lang mag input ng data then mag auto sort na sya s corresponding sheet kung saan andun ang particular Department nya? Ang naisip ko lang po kasi is using equal formula kaso sa dami ng departments (almost 20) then Expenses type (almost 50-60) baka di na ko matapos , haha

Serr if interested ka po pwede po kita iguide, iPM mo po ako dito

 

[Vil_n]

I think yung department is permanent, right? all you need to do is to sort, pwede kaba mag drop ng data kahit isang sample lang?

As, lookup's formula will be better para mapadali ka , and easy to understand.

 

[jaw9090]

Available pa ba to ts? Need ko sana help sa formula

 

[Blasphemer-Spirit]

Pagawa po ako MRP system using excel

wala pa po update?

Pa help naman po. For example po may Main Sheet ako, dun naka input lahat ng data, which includes Entry Number, Department, Type of Expenses, Amount of Expense etc.
Then next Sheet po (Sheet 1) na filtered na yung specific Department , then sorted na po yung Type of Expenses etc. then next sheet (Sheet 2) another Department naman po then same sa unq, naka sort na din data. Possible po kaya yun na sa main na lang mag input ng data then mag auto sort na sya s corresponding sheet kung saan andun ang particular Department nya? Ang naisip ko lang po kasi is using equal formula kaso sa dami ng departments (almost 20) then Expenses type (almost 50-60) baka di na ko matapos , haha

send me your data and I will sent it back to you what you want to do on this.

 

[Vil_n]

Pagawa po ako MRP system using excel

Material requirements planning?

 

[Blasphemer-Spirit]

Material requirements planning?

opo, pagawa po template. Thank you

 

[Vil_n]

Hirap nun hahaha, daming factor the dapat I consider.

 

[sherwin0921]

sino po marunong gumawa nito.. i align ung am at pm sa based sa date nya.. willing to pay.

 

[Vil_n]

sino po marunong gumawa nito.. i align ung am at pm sa based sa date nya.. willing to pay.View attachment 2629940

panu pong i-aalign

 

[sherwin0921]

panu pong i-aalign

magiging ganito po,