true power of MS excel. update: PowerBI

[maxbox]

HOW TO UNLOCK VBA PROJECT
credits goes to athenesia[/CENTER]

Hi sir Kirby,

Dun sa pag unlock ng excel password, after ko gawin to na access ko na ung vba ,tas sinubukan kong tanggalin ung password protect sa properties and then i save it.. pero nung na close ko na and then i tried running the excel file still nanghihingi ng password.

pano ko po kaya pwedeng ipadala sa inyo tong file na to? binayaran pa kasi to ng kasama ko dati sa para gamitin sana sa pageestimate kaso nakalimutan daw nya password. Sana po matulungan nyo ko salamat

 

[romcel11]

Hi sir Kirby,

Dun sa pag unlock ng excel password, after ko gawin to na access ko na ung vba ,tas sinubukan kong tanggalin ung password protect sa properties and then i save it.. pero nung na close ko na and then i tried running the excel file still nanghihingi ng password.

pano ko po kaya pwedeng ipadala sa inyo tong file na to? binayaran pa kasi to ng kasama ko dati sa para gamitin sana sa pageestimate kaso nakalimutan daw nya password. Sana po matulungan nyo ko salamat

boss na try mo na ung appication dito sa post na to?

CLICK HERE

 

[WakaTok]

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

Pa BM nito malaking tulong ito salamat TS

 

[jayvin0016]

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

Gandang umaga boss romcel11 may update na po sa workbook ko. salamat po ng marami

 

[komiya5]

wow salamat dito sir. magagamit ko to sa quiz namin

 

[maxbox]

boss na try mo na ung appication dito sa post na to?

CLICK HERE

Sir,

di ko mapagana sir..baka matulungan nyo ko attach ko po file dito

Salamat

 

[romcel11]

@maxbox, ano pong password ung tatanggalin?
1) if ung vba, pede mo gamitin ung application.
2) pero kung ung password para buksan ung excel file. you need to.....

2.1)_ open excel file

2.2)_ click on file

2.3)_ goto general options

2.4)_ remove password and save

 

[maxbox]

Sir Pareho po sana..
1. inopen ko ung excel file.. then nanhihingi ng password. Once i clicked the cancel button nagoopen sya ng panibagong workbook. pag sinubukan ko namang i close lang ung password window. di ko maaccess ung file. Please see attached file.

2. Regarding sa VBA sinubukan ko po ung unang post ni sir kirby so i was able to remove the password sa vba. tas punta po ko sa properties and then i uncheck ung protection tas sinubukan kong isave.. after nun ganun parin balik sa dati request parin po ng pasword..pano po i extract ung files from here ?

novice po kasi ako sa ganito.. ung bypasser sinubukan kong i open ung file through bypasser pero di po natanggal ung password pati sa vba

 

[laslas98]

Mga Sir. paano po yung format na walang border ang lahat ng cell maski yung default border nya? as in all white lahat.. need ko sa mga reports na gagawin ko. any feed back mga sir..

 

[akosiunknown2017]

Uncheck the gridlines View attachment 349931View attachment 349932

 

[laslas98]

Uncheck the gridlines View attachment 1267845View attachment 1267846

kahit basic reports palang gagawin ko laking tulong guide mo Salamat lodi!

Lodi, pano i'install ang macros sa 2007 MsExcell? same procedure ba sa mga new version ng ms excel?

 

[wagnausalitae]

see 2nd reply for powerbi update​

Hello guys ginawa ko lang tong thread para sa mga kasymb natin na need ng tulong about MS excel. mga reporting staff, encoders, data analyst, secrectary, or Ms excel systems. pasok po kayo dito. share tayo ng knowledge. i will provide tutorials too. believe me after learning this things after a month i got my promotion to go up another level from our company. so try it now. made your bosses like their jaws drop.​

on my first example. you will see chart with controls like the picture below.
View attachment 887637

here you will see conditional formatting with toggle.like the picture below.
View attachment 887650

now you will see a picture album using excel. but in this tutorial i'll give you an example of animal album.
View attachment 888228

in this picture you will see a chart that looks like a temperature. it would be helpful to a presentations with a sales and target sales.
View attachment 888874

now in this picture you will see a speedo meter chart with control. the tutorial was provided from the attachment.
View attachment 888895

at eto naman ang sample dashboards ko

sample 1
http://i.giphy.com/xTiTnzLUI4whphKpoc.gif

sample 2
http://i.giphy.com/3o85xkmN4eEdkNV6Zq.gif
​

if nagustohan nyo po. pwede nyo sya idownload sa baba.

digital clock by dhok si...

​

sana po magshare din ang iba,


grading system excel application upload by our contributors. http://www.symbianize.com/showthread.php?t=1132342&p=19858679&viewfull=1#post19858679

eto na po para yung iba di na masyado magtanong sa excel tricks. lalo na mga charts with controls. im giving you all this.

http://i.imgsafe.org/19867c1.jpg

Excel hacks.rar


eto po splitted into two parts. thanks to devildarkrs
part 1
http://www.symbianize.com/attachment.php?attachmentid=1043979&d=1436253924
part 2
http://www.symbianize.com/attachment.php?attachmentid=1043978&d=1436253924
credits to creator of the book.

HOW TO UNLOCK VBA PROJECT
credits goes to athenesia​

nice thread! ang dami plang technique sa excell. hehehe

 

[leosterb]

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

Gusto ko din matuto ng PowerBi,

 

[pizzaboydee]

Wow grabe, akalain mong natapos kong basahin ang thread na ito (hindi naman kabuuan) at ang dami kong natutunan, iba talaga nagagawa ng VBA, ang laking tulong nito sa trabaho natin, tuwang tuwa na naman si boss nito at malamang madami na namang ipapagawa hahaha, di bale mas maigi na yun dahil hindi nila tayo basta basta matatanggal sa trabaho at makakapag demand pa tayo ng salary increase hahaha.
Okay itong PowerBI na bago, sakto pang reports talaga.

 

[bhoc84]

waiting for power BI tutorials..... thanks

 

[kirby21]

stand by muna mga boss. medyo busy lang. ofcourse setting up powerbi sa office.

 

[jayvin0016]

Sir Romcel11 any update po sa workbook? thank you

 

[piona07]

ollah mga k sv pa help nmn ako qng ano formula pede ko gamitin dito paulit ulit kasi ginagamit ko para sa lahat ng magiging tama sagot..

meron ba paraan or way para mapadali pg gawa koView attachment 351206View attachment 351206

 

[romcel11]

salamat sa inyong lahat...
mauna na akong umalis...
pasara na kasi si symb...
sobrang nakakalungkot.

 

[ravenhash]

see 2nd reply for powerbi update​

Hello guys ginawa ko lang tong thread para sa mga kasymb natin na need ng tulong about MS excel. mga reporting staff, encoders, data analyst, secrectary, or Ms excel systems. pasok po kayo dito. share tayo ng knowledge. i will provide tutorials too. believe me after learning this things after a month i got my promotion to go up another level from our company. so try it now. made your bosses like their jaws drop.​

on my first example. you will see chart with controls like the picture below.
View attachment 887637

here you will see conditional formatting with toggle.like the picture below.
View attachment 887650

now you will see a picture album using excel. but in this tutorial i'll give you an example of animal album.
View attachment 888228

in this picture you will see a chart that looks like a temperature. it would be helpful to a presentations with a sales and target sales.
View attachment 888874

now in this picture you will see a speedo meter chart with control. the tutorial was provided from the attachment.
View attachment 888895

at eto naman ang sample dashboards ko

sample 1
http://i.giphy.com/xTiTnzLUI4whphKpoc.gif

sample 2
http://i.giphy.com/3o85xkmN4eEdkNV6Zq.gif
​

if nagustohan nyo po. pwede nyo sya idownload sa baba.

digital clock by dhok si...

​

sana po magshare din ang iba,


grading system excel application upload by our contributors. http://www.symbianize.com/showthread.php?t=1132342&p=19858679&viewfull=1#post19858679

eto na po para yung iba di na masyado magtanong sa excel tricks. lalo na mga charts with controls. im giving you all this.

http://i.imgsafe.org/19867c1.jpg

Excel hacks.rar


eto po splitted into two parts. thanks to devildarkrs
part 1
http://www.symbianize.com/attachment.php?attachmentid=1043979&d=1436253924
part 2
http://www.symbianize.com/attachment.php?attachmentid=1043978&d=1436253924
credits to creator of the book.

HOW TO UNLOCK VBA PROJECT
credits goes to athenesia​

Sir pwede ko pa ba makahinge ng copy ng dashboard nyo gusto ko lang mapagaralan gusto ko rin sana gumawa ng version ko pero monitoring naman ng mga field employee.


samalat in adv.