true power of MS excel. update: PowerBI

[kuroydada123]

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

posbile ba na gumawa ng macro for data validation? then mag lalabas ng output na report. ipapakita yung mga maling data na nilagay?

salamat sa tutulong

 

[alvinMe28]

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

Pa BM sir., thanks. TS

 

[kirby21]

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

posbile ba na gumawa ng macro for data validation? then mag lalabas ng output na report. ipapakita yung mga maling data na nilagay?

salamat sa tutulong

why not conditional formating?

 

[tepits]

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

Sino po nakakaalam dito saan maganda magtraining ng advance excel ung may vba and macro. Thanks in advance.

 

[kidmarvel]

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

Thanks for sharing

 

[lime12]

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

pabm author thank you

 

[arlenekyut]

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

UP! Thank you

 

[joperd]

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

Sino po nakakaalam dito saan maganda magtraining ng advance excel ung may vba and macro. Thanks in advance.

Sa MAPUA..

 

[Tuwalya]

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

baka po may alam kayo pano icrack o gawin unprotected ung excel file na may password? salamat po

 

[iduyanrosielyn]

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

hi mga sir baka pde pong patulong. pwede po bang makuha yung details sa ibang sheet na tapos dun sa pag lalagyan ng sheets is nakafilter na po yung dapat na makukuhang details? uubra po kaya yung patulong naman po tia

 

[puuts]

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

hi mga sir baka pde pong patulong. pwede po bang makuha yung details sa ibang sheet na tapos dun sa pag lalagyan ng sheets is nakafilter na po yung dapat na makukuhang details? uubra po kaya yung patulong naman po tia

Pwede yan. Upload mo dito ung file mo at lagyan mo din ng detailed instructions.

 

[albert3]

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

Hi Master,
Patulong naman po.

Pano ko po ma kacopy yung na sa CMS sheet papuntang SUMMARY sheet.
Bali yung sa CMS sheet under STATUS is ma filter. Lets say NEW so lahat ng
NEW is matatransfer sa SUMMARY sheet without duplicate bali mga unique value lang. same with Revision, SAME AS MED NEC,
WITH LCD MED NEC and PENDING WITH QUERY.

gaya mo ng attached sample workbook.


Salamat po Master!

 

[puuts]

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

Hi Master,
Patulong naman po.

Pano ko po ma kacopy yung na sa CMS sheet papuntang SUMMARY sheet.
Bali yung sa CMS sheet under STATUS is ma filter. Lets say NEW so lahat ng
NEW is matatransfer sa SUMMARY sheet without duplicate bali mga unique value lang. same with Revision, SAME AS MED NEC,
WITH LCD MED NEC and PENDING WITH QUERY.

gaya mo ng attached sample workbook.


Salamat po Master!

Pa-check TS.

 

[albert3]

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

Pa-check TS.

Amazing morethan expectation Master.

Thank you so much!

 

[iduyanrosielyn]

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

Pwede yan. Upload mo dito ung file mo at lagyan mo din ng detailed instructions.

View attachment 324224

sir eto po TIA

 

[puuts]

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

View attachment 1219817

sir eto po TIA

Pa-check TS

 

[nash0260]

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

Mga boss patulong naman po baka may alam po kayo na excel password recovery po sobrang kailangan kong mabuksan yung file po sana may makatulong po

Advance Thank you po

 

[iduyanrosielyn]

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

Pa-check TS

Thnx dito.. pero pede po ba yung prang drop list po sia lalabas?

 

[puuts]

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

Thnx dito.. pero pede po ba yung prang drop list po sia lalabas?

panong drop down list?

may example kaba? if meron, paki-post.

 

[chot07]

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

Hello guys! ask lang po, may way ba para mapabilis yung processing ng excel with vba? mga PC kasi sa office commonly 2 cores 2 gb ram lang eh, minsan pag mejo dumadami na ang data, bumabagal na ang processing ng excel though maliit lang ang file size nya