Re: MS excel formula, programming, analysis, presentation and tutorials.
Maraming salamat dito master. Working po ito.
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.if nagustohan nyo po. pwede nyo sya idownload sa baba.
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
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
Maraming salamat dito master. Working po ito.