true power of MS excel. update: PowerBI

[BurtKocaine]

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

mga sir pwede pong magpatulong kung meron na po bang nakagawa dito ng start and stop timer na may data log? if wala pa sana po may petmalu na gumawa dito

 

[XKiritoX]

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

salamat sir nakita ko to

 

[oman17]

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

salamat po dto

 

[vancurioso]

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

maraming salamat po

 

[joffer7410]

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

sir deadlink na ung wiley book, pa reupload naman po. thank you so much. merry christmas

 

[Holiday2015]

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

Hi sir gusto ko lang po magpaturo kasi may gusto ako makuhang specific value sa notepad gsto ko sana pagclick ng button sa excel mapupunta dun ung value na need ko eto ung need ko ung 385777 and 1336499 tska 475461 tska 754342146 bali gsto ko pagclick ko ng button mappnta sya sa specific cell patulong naman po pls thanks po sana may makatulong bago lang po ako sa vba excel kay ndi ko alam panu ggwin slmat

ISR2#sh int giga0/1 | i bytes
MTU 1500 bytes, BW 6000 Kbit/sec, DLY 100 usec,
385777 packets input, 35169810 bytes, 0 no buffer
1336499 packets output, 140787372 bytes, 0 underruns
ISR2#sh int gig0/2 | i bytes
MTU 1500 bytes, BW 39000 Kbit/sec, DLY 10 usec,
475461 packets input, 85183562 bytes, 0 no buffer
754342146 packets output, 3691906948 bytes, 0 underruns

 

[aubrey03]

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

@Holiday2015, check mo to

 

[KeepMeSafe]

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

Thanks ditto master

 

[billboypogi]

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

Master hihingi sana ako ng tulong kung pano gawin ung VB.

Gusto ko sana gumawa ng excel file na iaaccess ang isang webpage para kunin ung data.
1. Access website.
2. Enter username and password.
3. Select dropdown.
4. Export file going to template.

Pasensya na master pero d ko kasi pede ibigay ung mismong website... per kung makaka pag bigay ka kahit sample lang...

Thanks in advance master

 

[YoDee]

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

SALamat TS

 

[rubie08]

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

Super thanks!

 

[jccaguisa]

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

salamat po. magagamit po ito ng mga ordinaryong mga empleyado. salamat

 

[Mar Lon]

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

Mga LODI pa help naman kung anong code nararapat dito, nasa baba po yung picture.

 

[jskhulitz]

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

Mga LODI pa help naman kung anong code nararapat dito, nasa baba po yung picture.

paano kung dela cruz john joseph?
eh kung de la torre, michael?

Sadya ba talaga na 1 cell lang ang pinaglagyan ng full name? marami kailangan i-consider para magawan ng tamang formula yan. Pinakamadali kung separate ang first and last names.

 

[Mar Lon]

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

paano kung dela cruz john joseph?
eh kung de la torre, michael?

Sadya ba talaga na 1 cell lang ang pinaglagyan ng full name? marami kailangan i-consider para magawan ng tamang formula yan. Pinakamadali kung separate ang first and last names.

Ah ganon po ba sir, pano po gagawin ko kung seperate ang first and lastnames?

 

[puuts]

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

Ah ganon po ba sir, pano po gagawin ko kung seperate ang first and lastnames?

Lagay mo sa Column A ung Firstname at Column B ung Lastname.

 

[gbaddic]

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

Patulong ako sa mga master dito. Hindi ko alam kung paano ako na-trace ng boss ko. Ganito kasi may excel file na sinend sa mga emails namin at bawat employee may individual na username at password para maopen/edit yung file pero limited info/access. Nakuha ko username at pw ng boss ko at na-access ko yung same file this time with admin access so lahat kita ko. Ang tanong ko ay paano nya nalaman na naaccess ko yung excel file gamit yung username/pw nya eh sa workstation ko yun inopen at galing yung file sa email. Kung ni-rename ko ba yung file at ginamit yung username/pw nya, mattrace pa rin ba? thanks sa sasagot.

 

[themonyo]

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

Patulong ako sa mga master dito. Hindi ko alam kung paano ako na-trace ng boss ko. Ganito kasi may excel file na sinend sa mga emails namin at bawat employee may individual na username at password para maopen/edit yung file pero limited info/access. Nakuha ko username at pw ng boss ko at na-access ko yung same file this time with admin access so lahat kita ko. Ang tanong ko ay paano nya nalaman na naaccess ko yung excel file gamit yung username/pw nya eh sa workstation ko yun inopen at galing yung file sa email. Kung ni-rename ko ba yung file at ginamit yung username/pw nya, mattrace pa rin ba? thanks sa sasagot.

Sa tingin ko, nakita nya yung excel registered user name mo. May logs din ng last accessed by:

 

[gbaddic]

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

Pano yun macheck sa last accessed by kung yung file sinend sa email? Bale kasi hindi sya shared sa isang location so na-open sya sa email tapos sinave sa workstation.

 

[jskhulitz]

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

Yung file ba talaga ang sinend sa email? Or baka link nung file ang sinend? Tapos yung file ay naka-store sa isang shared location, tapos hindi mo napansin?