true power of MS excel. update: PowerBI

[profiters]

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

Thanks for sharing

 

[kirby21]

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

Hi po mga kuya expert sa excel, maaari nyo po ba akong tulungan? pwede po bang mag formula na hindi na copy and paste yung gagawin sa pagkuha ng previous data of employee para sa susunod na payroll... Thanks in advanced

View attachment 1123970
View attachment 1123971

you need referrence functions such as vlookup, hlookup, index and match you will need if functions too.

 

[PiriPitiw]

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

you need referrence functions such as vlookup, hlookup, index and match you will need if functions too.

ganun po ba sir? pwede nyo po ba akong gawan ng format? salamat po...

 

[Pupina]

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

pa BM muna ko TS magagamit ko to in the future hihi

 

[dannyps2]

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

ang layo na inabut sa page na ito, dami ko nang hinde na sundan ah. musta sir kirby21?

 

[kirby21]

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

ang layo na inabut sa page na ito, dami ko nang hinde na sundan ah. musta sir kirby21?

ok naman. medyo pissed off sa upwork. nagtaas kasi sila from 10% to 20% fee. which is malaking pera talaga. kaw pre musta?

 

[flashback]

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

astig niting thread n to.. hehe

 

[kahuynon712]

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

Good morning guys.

im currently working as logistic associate from a supply chain.

and we are looking for another data analyst. or an excel guru or expert. with business side analysis. (Merchandizing department to be specific). its a plus but not must have. willing to work from panay avenue quezon city.

please contact me at my skype name

sysubaesa_darell

Magkano pasahod tol?

 

[hehe13]

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

ganun po ba sir? pwede nyo po ba akong gawan ng format? salamat po...

Id like to suggest index match. Sana inattach mo na yung excel mo para mas madali kang natulungan.

=index(column ng result,match(yung name ng employee na reference,column ng name ng employee sa table or array,0))

sample
=index(B:B,match(D1,A:A,0))

check mo to, may index match ako dito - http://www.symbianize.com/attachment.php?attachmentid=1123090&d=1461533254

 

[lazerjet]

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

Merun po kayong tutorial ng Macro? aside sa recording? Especially yung may web kapang papasukan para magather yung data?
Salamat sa sasagot

 

[kirby21]

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

Magkano pasahod tol?

your salary will be base on how the interview went and depends also on your resume.

- - - Updated - - -

Merun po kayong tutorial ng Macro? aside sa recording? Especially yung may web kapang papasukan para magather yung data?
Salamat sa sasagot

i guess web scraper ang need mo. this would be done basta may knowledge ka din sa html. so its a tough task. and you must take note. hindi lahat ng web pages are pwede. lalu na ang mga java based page.

 

[1sttimer]

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

Good day mga kasymb!
I'm working on something sa excel, just want to compare my formula to yours if you have time.
Gusto ko pa palawakin ang knowledge ko as a newbie sa excel.
ito po yung Scenario
View attachment 270785

 

[hehe13]

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

Good day mga kasymb!
I'm working on something sa excel, just want to compare my formula to yours if you have time.
Gusto ko pa palawakin ang knowledge ko as a newbie sa excel.
ito po yung Scenario
View attachment 1125686

 

[bhabyqoueh]

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

wow, thanks sa chart with controls..nagustohan ng boss ko,
gusto ko po sana matutunan yong dash broad sample 1 mo san po kaya ako magandang mag simula?

sorry dami nang edit tong post ko
pero di ko talga mapigilan na maexcite, im tryng to create other version.. thanks dito sa post mo
sir nainspired ako...

 

[kirby21]

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

wow, thanks sa chart with controls..nagustohan ng boss ko,
gusto ko po sana matutunan yong dash broad sample 1 mo san po kaya ako magandang mag simula?

sorry dami nang edit tong post ko
pero di ko talga mapigilan na maexcite, im tryng to create other version.. thanks dito sa post mo
sir nainspired ako...

naku pasensya ka na. medyo di ko na napuntahan tong thread, kumonte na kasi ang nagtatanong. siguro magagaling na din sila. hehehe. PM siguro mas madali.

 

[jocno1212]

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

Guys patulong naman, may dalawang table kasi ako, ang objective ko kasi e mapagsama sa iisang query yung lahat ng collection within the day galing sa dalawang tables ko,

example

Table1
ClientID........BillAmt.....DateRec
1..................50...........01/01/2016
2..................100.........01/01/2016
3..................150.........01/02/2016
4..................200.........01/03/2016
5..................250.........01/04/2016

Table2
ClientID........InstallationFee.....DatePaid
6..................1,000..................01/01/2016

Gusto ko sana maging ganito output ng QUERY ko

Query1
ClientID........BillAmt........InstallationFee....DateRec..................DatePaid
1..................50..............0........................01/01/2016............-
2..................100............0........................01/01/2016............-
6..................0................1,000................................................01/01/2016

Paano ba yung tamang SQL code nito,

Ano po ba mali dito?

SELECT
Table1.ClientID,
Table1.BillAmnt,
Table1.DateRec,
Table2.InstallationFee,
Table2.DatePaid,
FROM Table1 INNER JOIN Table2 ON Table1.ClientID = Table2.ClientID
WHERE Table1.DateRec=#01/01/2016# and Table2.DatePaid=#01/01/2016#

Patulong naman guys... any workaround? di na kaya ng utak ko eh, hehehe... Thanks in advance sa tutulong!

 

[lordwoulfe]

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

Halo TS Bossing, wow... sana may live tutorial ka, im a newbie but not totally, basic lang lahat sa excel. Nanaginip maging data analyst with focus sa Food & Beverage industry kasi yan ang work ko ngayon den may matagal na rin akong work experience, yun lang gusto ko sana na ma apply yung mga principles ng data analyst with data visualization.

nag try din akong mag browse sa net ng mga local schools na nag offer ng courses about data visualization, wala eh puro online.

sana maging active ulit etong thread mo TS.

 

[jocno1212]

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

Guys patulong naman, may dalawang table kasi ako, ang objective ko kasi e mapagsama sa iisang query yung lahat ng collection within the day galing sa dalawang tables ko,

example





Gusto ko sana maging ganito output ng QUERY ko



Paano ba yung tamang SQL code nito,

Ano po ba mali dito?



Patulong naman guys... any workaround? di na kaya ng utak ko eh, hehehe... Thanks in advance sa tutulong!

Up ko lang ito...

 

[kirby21]

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

Guys patulong naman, may dalawang table kasi ako, ang objective ko kasi e mapagsama sa iisang query yung lahat ng collection within the day galing sa dalawang tables ko,

example





Gusto ko sana maging ganito output ng QUERY ko



Paano ba yung tamang SQL code nito,

Ano po ba mali dito?



Patulong naman guys... any workaround? di na kaya ng utak ko eh, hehehe... Thanks in advance sa tutulong!

SQL gamit mo boss? naku di ako marunong sa SQL eh. macro po gamit namin dito mostly.

- - - Updated - - -

Halo TS Bossing, wow... sana may live tutorial ka, im a newbie but not totally, basic lang lahat sa excel. Nanaginip maging data analyst with focus sa Food & Beverage industry kasi yan ang work ko ngayon den may matagal na rin akong work experience, yun lang gusto ko sana na ma apply yung mga principles ng data analyst with data visualization.

nag try din akong mag browse sa net ng mga local schools na nag offer ng courses about data visualization, wala eh puro online.

sana maging active ulit etong thread mo TS.

ano bang target mo? mag-aral sa school or tutor?

 

[jeffanton]

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

pasensya po busy sa work this past days. anyways I'll try to solve this.

cheers

pa join lang mga Sir,

Sir pasimplify ung query mo.
Etry mo nalang gumamit ng table para sa database mo para madali Sheet1 -> Main_Menu (nan dyan na ang search at output mo)
Sheet 2 --> Database gamit ka ng Table