true power of MS excel. update: PowerBI

[davoi27]

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

pabookmark po..thanks

 

[BurtKocaine]

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

maraming salamat sa thread na 'to TS. ngayon ko lang nalaman na may ganitong thread pala dito

gusto po sanang magpatulong sa current excel project ko. gusto ko pong i plot or graph yung mga task per worker.

as if automatic nang mag fi fill yung duration based sa time started.


more power po sa thread na to!

- - - Updated - - -

Hello po..do you have a time and motion spreadsheet na i can use to observe and perform activities?

--- I was helped na po! yey thank you Sir!

pa share naman po. need ko rin po yang ganyang spreadsheet. thanks

 

[amirsinghsingh]

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

Good day mga excel masters! tanong ko lang kong pwede to. bale may tatlo akong criteria. tapos under sa isang criteria may mga pending. gusto ko sana na nka .vba xa. 1 click lang ng button at i fifilter na nya yung mga blank/pending cells. screenshot provided thanks!

View attachment 1179952

eto na po yung sagot sa tanong nyo po

the answer


- - - Updated - - -

maraming salamat sa thread na 'to TS. ngayon ko lang nalaman na may ganitong thread pala dito

gusto po sanang magpatulong sa current excel project ko. gusto ko pong i plot or graph yung mga task per worker.

as if automatic nang mag fi fill yung duration based sa time started.


more power po sa thread na to!

- - - Updated - - -



pa share naman po. need ko rin po yang ganyang spreadsheet. thanks

kelangan ba automatic makukulayan kapag nag input ka sa time start at time end?

 

[BurtKocaine]

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

@ amirsinghsingh

yes sir need ko po automatic makukulayan kapag nag input ka ng time start at time end

 

[themonyo]

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

@burtkocaine
hindi ba mas maganda gawin yan sa msproject?
Gantt chart yan eh


edit: heto, link ng tutorial sa excel
https://www.smartsheet.com/blog/gantt-chart-excel

 

[PENTAT0NIX]

Re: MS excel formula, programming, analysis, presentation and tutorials.

Wow TS thanks dito ng marami laking tulong

 

[BurtKocaine]

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

@burtkocaine
hindi ba mas maganda gawin yan sa msproject?
Gantt chart yan eh


edit: heto, link ng tutorial sa excel
https://www.smartsheet.com/blog/gantt-chart-excel

sir di po gantt chart kelangan ko sinubukan ko po pero di ko sya ma plot ng automatic
anyway thanks sa link na binigay nyo. ^_^

 

[bytesize]

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

@ amirsinghsingh

yes sir need ko po automatic makukulayan kapag nag input ka ng time start at time end

Conditional formatting sir:

View attachment 304256

cell H2 contains formatting formula:
=AND(H$1>=$D2,H$1<=$E2)
then drag right and down

see attached file.

Sorry mga kasymb sa late reply

 

[BurtKocaine]

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

Conditional formatting sir:

View attachment 1184045

cell H2 contains formatting formula:
=AND(H$1>=$D2,H$1<=$E2)
then drag right and down

see attached file.

Sorry mga kasymb sa late reply

@bytesize

maraming maraming salamat idol! working po sya

 

[joperd]

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

Mga masters Question..


Meron akong naka-attached na workbook.

Gusto ko sana marandomize column D sa "Accounts Tab" per associate sa Column I same sheet.
Pero dapat equally distributed yung Total workload sa "Intenal" tab.

alam ko sisiw lang sa inyo to.. thanks ng madami..

 

[bytesize]

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

Mga masters Question..


Meron akong naka-attached na workbook.

Gusto ko sana marandomize column D sa "Accounts Tab" per associate sa Column I same sheet.
Pero dapat equally distributed yung Total workload sa "Intenal" tab.

alam ko sisiw lang sa inyo to.. thanks ng madami..

sorry sir di ko magets. gawa ka screenshot ng example ng gusto mo mangyari

thanks

 

[BurtKocaine]

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

mga masters patulong po ulit sa bago kong project. malamang macro or vba na kelangan dito.
naka attach po yung working sheet ko and sa gusto ko pong maging output

View attachment 304682

 

[BurtKocaine]

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

^up ko lang po baka hindi na busy mga master dito

 

[knives645]

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

Anyone here interested working as Reports Analyst? Please do send me an email @ [email protected]. company: Shearwater Health

 

[kirby21]

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

Anyone here interested working as Reports Analyst? Please do send me an email @ [email protected]. company: Shearwater Health

hahaha. same here need 2 report analyst. sales and merchandising knowledge is a plus.

PS: report analyst lang talaga. di mo need magbenta. (baka kasi sa nakakita ng sales baka isipin kailangan din magbebenta)

 

[ohohOrmhel]

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

hahaha. same here need 2 report analyst. sales and merchandising knowledge is a plus.

PS: report analyst lang talaga. di mo need magbenta. (baka kasi sa nakakita ng sales baka isipin kailangan din magbebenta)

Magkano ba ang bigayan jan mga sir? Hehehe

 

[Gatorade]

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

keep sharing tnx

 

[ebernales]

Re: MS excel formula, programming, analysis, presentation and tutorials.

galing nito TS. thank you.

 

[pelera]

Re: MS excel formula, programming, analysis, presentation and tutorials.

Mga Master patulong naman po sa ginagawa kong Collection report. May naumpisahan na ko kaso hindi ko alam pano ko koConnect monthly Collection na nagbayad.

 

[BurtKocaine]

Re: MS excel formula, programming, analysis, presentation and tutorials.

mga master baka di na kayo busy patulong po ulit sa formula