true power of MS excel. update: PowerBI

[Mar Lon]

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

eto brader

Boss thanks update na lang po kita pag may mga changes pa ako, if available ka! salamat talga.

 

[puuts]

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

hi mga sir, please help me. i want to do a program using vba/macro (not sure if ano ba talaga dapat since i only know advanced excel pero wala pa kong idea sa vba and macro and programming).

i am doing weekly sales report and the raw data is coming from a data warehouse (in excel din) and i am doing vlookup for each day which is tedious kasi i need to do it everyday. now, i want my file to automatically get the data from another excel file and hindi ko na i-vlookup yung everyday sales from another excel.

is it possible na i-refresh ko lang yung file ko and it would automatically get the data from another file? kindly take note na dapat everyday siya mag-update then may mga formulas like sum of specific cells sa baba.

thank you so much in advance!!

yes possible po yan. pa-attached na lang po yung raw data file and yung sample output mo po.

 

[Mar Lon]

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

eto brader

Boss ask ko lang sana kung pano mo nalagyan ng button sa worksheet yung BROWSE at UPLOAD.

 

[jskhulitz]

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

Akyat ka dito sa MIS department. Turuan kita...

 

[kazumi08]

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

pa book mark muna thanks po.

 

[buddy74]

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

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​

THANK YOU SO MUCH WITH THIS TS....

pa bm po muna ako nito

 

[knives645]

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

hi mga sir, please help me. i want to do a program using vba/macro (not sure if ano ba talaga dapat since i only know advanced excel pero wala pa kong idea sa vba and macro and programming).

i am doing weekly sales report and the raw data is coming from a data warehouse (in excel din) and i am doing vlookup for each day which is tedious kasi i need to do it everyday. now, i want my file to automatically get the data from another excel file and hindi ko na i-vlookup yung everyday sales from another excel.

is it possible na i-refresh ko lang yung file ko and it would automatically get the data from another file? kindly take note na dapat everyday siya mag-update then may mga formulas like sum of specific cells sa baba.

thank you so much in advance!!

kindly send some files and sample report.

 

[copmit]

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

galing nito marami matututunan

 

[lloydmark13]

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

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!! NICE!!! ty for sharing TS

 

[Mar Lon]

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

Mga ka Ts pa help naman balak ko sana lagyan to ng search engine which is yung name nila yung i-sesearch. Paturo naman kung pano? Actually galeng ito kay sir puuts. naka attached po yung file.

 

[christina]

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

meron po bang pang id system monitoring with sms sira kasi sa skul namin... tnx po pm me please!

 

[puuts]

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

Mga ka Ts pa help naman balak ko sana lagyan to ng search engine which is yung name nila yung i-sesearch. Paturo naman kung pano? Actually galeng ito kay sir puuts. naka attached po yung file.

try mo tong nka-attached.

 

[Mar Lon]

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

try mo tong nka-attached.

Sir puuts maraming salamat po na check ko na po yung file, may tanong po ako possible po ba na pag ka pindot mo na go is lalabas din yung graph?

 

[tepits]

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

Kapag mag enrol ba ng macro excel anong basic knowledge aside sa excel. Dapat ba may programming experience. Also, saan maganda mag enrol ng ahort course nito? Thanks thanks.

 

[jskhulitz]

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

AFAIK, walang establishment ang nag-ooffer ng courses for macro. Pero madaming online courses para diyan.

For the basic knowledge, pinakamaganda ay marunong ka na ng visual basic dahil VBA ang ginagamit for macro.

 

[mistysparkles]

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

yes possible po yan. pa-attached na lang po yung raw data file and yung sample output mo po.

sir, thank you so much for your reply. naka-attach na po yung mga files.

yung data source, yun po yung sample data na kinukunan ko everyday, then ang gagawin ko naman is i-vlookup ko yung data sa another sheet (yung result file naman) for each day. sobrang matrabaho po nito and need na gawin ko everyday. then may gagawin pa po akong mga analysis after ko kumuha ng data.

sana po you can help me figure out a way para di ko na kelangan i-vlook up yung mga data sa data source and automatic ma-update yung another file ko everyday.

thank you so much again.

 

[exmachina]

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

Maraming Salamat sa thread na ito!

 

[dimerdime]

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

Hello po, baguhan lang po sa excel

Paano po i include ung orange line mismo sa graph - un po sana ung target line ko sana which is ung august sa first tab. Nag insert lang po kasi ako ng shape. Thanks in advance po

 

[tepits]

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

Sinong willing dito magturo ng vba in person? Mejo mahirap po kasi makasabay sa mga comments. Salamat salamat po.

 

[charleen]

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

Up for you maganda at malinis gusto ko sana nito pero pref visual basic