true power of MS excel. update: PowerBI

[pusanggala]

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

Tama po ba yung code? May error akong natanggap at sabi ay "Compile Error" Expected: Sub or Function.

 

[bitter2better]

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​

100 x thanks sir

 

[zackarnaiz]

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

hello sir. pa turo naman ksi may template ako gusto ko sya gawan ng macro. v.basic. please help thanks.

 

[Jay0003]

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

Salamat po sa pag share nito

 

[jhencalucag]

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

Mga Sir. Pa help naman po ako kung pano gumawa ng asset monitoring. may pinapagawa saken. kaso di ako masyado sa marunong sa excel. about sa mga company phone na iniissue namin per department . tapos kung ilang unit yung na release then ilang unit yung natira. mga ganon po.
inventory then monitoring. gusto ko kasing matuto. then pinapalagyan pa ng graph. jusme idont know how to start. sana po may makatulong saken.

 

[kirby21]

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

Mga Sir. Pa help naman po ako kung pano gumawa ng asset monitoring. may pinapagawa saken. kaso di ako masyado sa marunong sa excel. about sa mga company phone na iniissue namin per department . tapos kung ilang unit yung na release then ilang unit yung natira. mga ganon po.
inventory then monitoring. gusto ko kasing matuto. then pinapalagyan pa ng graph. jusme idont know how to start. sana po may makatulong saken.

gawa ka muna list. let say anong unit anong plan. phone number at kanino nakaissue.

 

[ohohOrmhel]

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

hello sir. pa turo naman ksi may template ako gusto ko sya gawan ng macro. v.basic. please help thanks.

upload mo dito paps ung template mo then kung ano gusto mo maging end look

 

[gkr08]

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

TS help naman i need accurate inventory System kahit na excel lang basta accurate

thanks sa reply ts keep sharing sa mga talent na nashashare mu

 

[beverly dela cruz]

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

meron ba kayo na sheet para sa inventory. halimbawa delivery ng item at sales ng item. malalaman kung ilan pa ang available na stocks??

 

[themonyo]

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

TS help naman i need accurate inventory System kahit na excel lang basta accurate

thanks sa reply ts keep sharing sa mga talent na nashashare mu

meron ba kayo na sheet para sa inventory. halimbawa delivery ng item at sales ng item. malalaman kung ilan pa ang available na stocks??

pareho kayo ng kelangan ah

heto nahanap ko sa google
https://www.smartsheet.com/free-excel-inventory-templates

 

[crazyish24]

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

Salamat sa pag share nito .

 

[nash0260]

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

Mga Master pasensiya na ngaun na lng ulit nag online at nag chat dto sa grup ntn kainis ung company ko before naka restrict ung social media po

 

[BurtKocaine]

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

mga master patulong po ulit para ma sum ko yung mga items 1,2,3,4 sa sheet1 by date, line at product. thanks

 

[athenesia]

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

mga master patulong po ulit para ma sum ko yung mga items 1,2,3,4 sa sheet1 by date, line at product. thanks

Ganito ba yun.

 

[popo007]

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

Mga master,

Pa help naman po.. I setup a conditional formatting sa excel as below

=A2>=A1 mag color green yung cell
=A2<A1 mag color red naman yung cell

the problem is I need to copy this to several cell but I need to change the formula every cell kasi di siya nag auauto change ng formula.. e ang dami ng cells.. paano po ang gagawin ko dito.. thanks po

 

[BurtKocaine]

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

Ganito ba yun.

tama po sir yan nga po. thanks!

 

[athenesia]

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

Mga master,

Pa help naman po.. I setup a conditional formatting sa excel as below

=A2>=A1 mag color green yung cell
=A2<A1 mag color red naman yung cell

the problem is I need to copy this to several cell but I need to change the formula every cell kasi di siya nag auauto change ng formula.. e ang dami ng cells.. paano po ang gagawin ko dito.. thanks po

Ganito gawin mu sir,
set ka ng conditional formatting sa A2 lang muna, then wag mu ilock sa A1 yung condition,
dapat ganito yung nasa condition mu $A1, then copy mu yung cell A2 mu, then select mu yung iba pang cell na lalagyan ng conditional formatting,
PasteSpecial as Format lang sir. susunod na yung mga cell na yun sa conditional format mu.

 

[technome]

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

pa bookmark ts salamat ^_^

 

[lordwoulfe]

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

wow... nice pasali naman po dito... kelangan ko gumawa ng maganda at informative na excel dashboard para sa isang restaurant

 

[RigiloDatu]

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

Ayos to thanks.