true power of MS excel. update: PowerBI

[aklanon]

Re: MS excel reportings, presentations, and vba helping thre

oa bm po salamat

 

[mrgreed]

Re: MS excel we give solutions. formula, codes and tutorials.

Sa 2nd sheet merong Import button, click mo lang yun, may lilitaw na form,
1. Browse your text file.
2. Click Import.
3. Check Sheet 3, the data should be there.

Enjoy!

ok boss ng madami... echeck q to after work d q kasi ma dl d2 sa office hehehe anyway thanks again..

 

[kaytoy]

Re: MS excel reportings, presentations, and vba helping thre

Nice Thread... Keep it Up.. pra may matutunan din ako

 

[akosidereck]

Re: MS excel reportings, presentations, and vba helping thre

nice thread TS..



ask ku lang po kung anu yung mbpivot saka vlookup.. and how to use.. hehehe

 

[countkenshin]

Re: MS excel reportings, presentations, and vba helping thre

buti meron neto,

tanong ko lang

let say for example sales sheet and inventory sheet = 2 sheets
sales sheet (id num and amount) , inventory sheet (id num and item and bcode)
gagawin ko pivot table

tanong ko lang panu ko magagawa pivot table sya ng lalabas sa pivot

id num , amount , item(item name) , bcode(barcode)

**

kase lumalabas saken
id num , amount(ginagawa ko sum) , item(naka count sya hindi yung item talaga lumalabas), bcode (naka count din sya hindi lumalabas ung barcode talaga)

panu un?

 

[mabangiz32]

Re: MS excel we give solutions. formula, codes and tutorials.

pa-subscribe ako TS.

salamat sa share.

 

[dean007]

Re: MS excel reportings, presentations, and vba helping thre

example sheet po para mas madaling intindihin. baka makatulong po

- - - Updated - - -

buti meron neto,

tanong ko lang

let say for example sales sheet and inventory sheet = 2 sheets
sales sheet (id num and amount) , inventory sheet (id num and item and bcode)
gagawin ko pivot table

tanong ko lang panu ko magagawa pivot table sya ng lalabas sa pivot

id num , amount , item(item name) , bcode(barcode)

**

kase lumalabas saken
id num , amount(ginagawa ko sum) , item(naka count sya hindi yung item talaga lumalabas), bcode (naka count din sya hindi lumalabas ung barcode talaga)

panu un?

attach ka po ng example sheet. baka makatulong po

- - - Updated - - -

nice thread TS..



ask ku lang po kung anu yung mbpivot saka vlookup.. and how to use.. hehehe

pivot table po ay isang dynamic table. ibig sabihin mas madaling magconsolidate ng data. kahit gaano pa po karami . kaya nyang isummarize kahit 5000 cells of information with just a click. pag aralan mo po at matutuwa ka sa wonders ng function nito. it helps me a lot sa daily reports ko.

eto po link. magandang reference yan. dyan ako natuto eh.
http://excelcentral.com/excel2007/expert/tutorials/Session%2005%20Pivot%20Tables.html

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

example sheet po para mas madaling intindihin. baka makatulong po

- - - Updated - - -



attach ka po ng example sheet. baka makatulong po

- - - Updated - - -



pivot table po ay isang dynamic table. ibig sabihin mas madaling magconsolidate ng data. kahit gaano pa po karami . kaya nyang isummarize kahit 5000 cells of information with just a click. pag aralan mo po at matutuwa ka sa wonders ng function nito. it helps me a lot sa daily reports ko.

eto po link. magandang reference yan. dyan ako natuto eh.
http://excelcentral.com/excel2007/expert/tutorials/Session 05 Pivot Tables.html

salamat sa pag tulong while im away sir. dami ko reports. kakatapos lang kasi ng quarter, hahaha

 

[countkenshin]

Re: MS excel reportings, presentations, and vba helping thre

example sheet po para mas madaling intindihin. baka makatulong po

- - - Updated - - -



attach ka po ng example sheet. baka makatulong po

- - - Updated - - -



pivot table po ay isang dynamic table. ibig sabihin mas madaling magconsolidate ng data. kahit gaano pa po karami . kaya nyang isummarize kahit 5000 cells of information with just a click. pag aralan mo po at matutuwa ka sa wonders ng function nito. it helps me a lot sa daily reports ko.

eto po link. magandang reference yan. dyan ako natuto eh.
http://excelcentral.com/excel2007/expert/tutorials/Session 05 Pivot Tables.html

bro asan ung attach mo ng example sheet? yan na ba yung sa link?
talanga urgent ko need matutunan yung pivot table need ko sa interview kase

 

[dean007]

Re: MS excel reportings, presentations, and vba helping thre

bro asan ung attach mo ng example sheet? yan na ba yung sa link?
talanga urgent ko need matutunan yung pivot table need ko sa interview kase

yep refer ka lang dyan sa link na prinovide ko.. covered nya naman mga basic and intermediate function to manipulate data using pivot.

- - - Updated - - -

salamat sa pag tulong while im away sir. dami ko reports. kakatapos lang kasi ng quarter, hahaha

no probs sir.

 

[calle]

Re: MS excel we give solutions. formula, codes and tutorials.

Pre patulong naman dito sa problem ko...

I just want to ask how can I get the value of x in the equation y=arctan (sin(x)/(4+cos(x)) ? I have the value of y from 0-360 degrees and I want to know the value of x when i change the value of y. I want to do this in excel, so what do i need to solve this problem?

Thanks in advance!

Regards,

 

[1sttimer]

Re: MS excel we give solutions. formula, codes and tutorials.

View attachment 189459
Guys anong formula gagamitin nyo dito?

 

[puuts]

Re: MS excel we give solutions. formula, codes and tutorials.

View attachment 973252
Guys anong formula gagamitin nyo dito?

ano ung check and cross? symbol ba yan? or special characters?

 

[james1184]

Re: MS excel we give solutions. formula, codes and tutorials.

sa share TS! pabookmark po dito!

 

[1sttimer]

Re: MS excel we give solutions. formula, codes and tutorials.

ano ung check and cross? symbol ba yan? or special characters?

Font yan bro, Wingdings 2.
Letter P= Check
Letter O = X

 

[puuts]

Re: MS excel we give solutions. formula, codes and tutorials.

Font yan bro, Wingdings 2.
Letter P= Check
Letter O = X

Sa 'B13', ilagay mo to:

=COUNTIFS(A1:A12,"Small",B1:B12,"P")

Kahit Wingdings ang Font nya, hindi yan makaka apekto sa formula.
Hope it helps.

 

[1sttimer]

Re: MS excel we give solutions. formula, codes and tutorials.

Sa 'B13', ilagay mo to:

=COUNTIFS(A1:A12,"Small",B1:B12,"P")

Kahit Wingdings ang Font nya, hindi yan makaka apekto sa formula.
Hope it helps.

Thanks Bro!

 

[ohohOrmhel]

Re: MS excel we give solutions. formula, codes and tutorials.

Sir ni try ko po gayahin eto kaso paano ko po ilalagay ung Code na $B$4? hindi ko po alam eh hindi ko naman makita yung format control. Ung sa Conditional Formatting nakuha ko na po yan nalang =/

 

[puuts]

Re: MS excel we give solutions. formula, codes and tutorials.

Sir ni try ko po gayahin eto kaso paano ko po ilalagay ung Code na $B$4? hindi ko po alam eh hindi ko naman makita yung format control. Ung sa Conditional Formatting nakuha ko na po yan nalang =/

anong gusto mo gawin jan? for example pagka click nung checkbox na 'display top 5 brands' magddisplay ung top 5, then if not check then display all? tama ba pagkaka intindi ko?

 

[ohohOrmhel]

Re: MS excel we give solutions. formula, codes and tutorials.

anong gusto mo gawin jan? for example pagka click nung checkbox na 'display top 5 brands' magddisplay ung top 5, then if not check then display all? tama ba pagkaka intindi ko?

opo sir un nga po.