true power of MS excel. update: PowerBI

[DxtR112591]

Re: MS excel we give solutions. formula, codes and tutorials.

Sir Kirby.. pahelp naman po sa macro.. gusto ko po kc idelete lahat ng my gender na M sa worksheet.. in just 1 click... salamat po!!!

 

[ohohOrmhel]

Re: MS excel we give solutions. formula, codes and tutorials.

Dami ko na din natutunan sa excel actually puro dashboard nalang ang ginagawa ko para mas madali

eto pala mga ss na ginawa ko


Eto Sales ng P&G
View attachment 219794

Eto naman attendance Monitoring nila.
View attachment 219795

 

[biogenic123]

Re: MS excel we give solutions. formula, codes and tutorials.

sir sa sample number 1 panu po ba magdagdag ng brand thanks

 

[kaytoy]

Re: MS excel we give solutions. formula, codes and tutorials.

Dami ko na din natutunan sa excel actually puro dashboard nalang ang ginagawa ko para mas madali

eto pala mga ss na ginawa ko


Eto Sales ng P&G
View attachment 1040709

Eto naman attendance Monitoring nila.
View attachment 1040710

Nice... i learned and still lurking in Excel 2003... maybe i will try to explore on this pag may time

 

[nash0260]

Re: MS excel we give solutions. formula, codes and tutorials.

Sir Kirby.. pahelp naman po sa macro.. gusto ko po kc idelete lahat ng my gender na M sa worksheet.. in just 1 click... salamat po!!!

ano po ba ung column or ung cell lang po?

kung cell lang Replace na lng gamitin mo

replace M to blank

- - - Updated - - -

bro kaktoy pa help nmn pano mag paste sa table ung data ko nasa sheet 1 to table nasa sheet 2?

- - - Updated - - -

Dami ko na din natutunan sa excel actually puro dashboard nalang ang ginagawa ko para mas madali

eto pala mga ss na ginawa ko


Eto Sales ng P&G
View attachment 1040709

Eto naman attendance Monitoring nila.
View attachment 1040710

bro baka pde mo upload ung excel file pra mapag aralan nmn ^^

 

[Prinsipe828]

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

Thanks po ts dito. Malaking tulong.

 

[darkerthanjordan]

Re: MS excel we give solutions. formula, codes and tutorials.

thanks dito! pag-aralan ko to

 

[kaytoy]

Re: MS excel we give solutions. formula, codes and tutorials.

bro kaktoy pa help nmn pano mag paste sa table ung data ko nasa sheet 1 to table nasa sheet 2?

@Nash

i saw question pero nasa isip ko ksi na solution is ang ROWS ang moving hindi ung COLUMN.

Tables ideally should have data from top to buttom.. -(In my own opinion lang po )

 

[ph_scener]

Re: MS excel we give solutions. formula, codes and tutorials.

thanks for sharing

 

[akosidereck]

Re: MS excel we give solutions. formula, codes and tutorials.

nice TS.. paturo din po aku... dami ku reports na gagamitan ng excel e.. newbie lang po aku d2.. .plssss need HELP

 

[growgrid]

Re: MS excel we give solutions. formula, codes and tutorials.

Sir thank's po

 

[nash0260]

Re: MS excel we give solutions. formula, codes and tutorials.

@Nash

i saw question pero nasa isip ko ksi na solution is ang ROWS ang moving hindi ung COLUMN.

Tables ideally should have data from top to buttom.. -(In my own opinion lang po )

yes bro need ko ung row pa baba

 

[99newbreed]

Re: MS excel we give solutions. formula, codes and tutorials.

Dami ko na din natutunan sa excel actually puro dashboard nalang ang ginagawa ko para mas madali

eto pala mga ss na ginawa ko


Eto Sales ng P&G
View attachment 1040709

Eto naman attendance Monitoring nila.
View attachment 1040710

sir pa upload naman o ng file para po mapag aralan namin salamat po in advance

 

[marko0313]

Re: MS excel we give solutions. formula, codes and tutorials.

Sir 99newbreed

Pahingi naman ako ng excel file ng Eto Sales ng P&G

kailangan ko ito sa report ko eh..

Thank you

 

[nash0260]

Re: MS excel we give solutions. formula, codes and tutorials.

mga boss pde po bang pa help pano po kaya ito maayos gusto ko po kase na dapt kahit papano may data sia ipapakita or pop up message na mag sasabi na wlang data or d tugma ung na filter ng user po pa help po im using pivot table

View attachment 219951

 

[akosidereck]

Re: MS excel we give solutions. formula, codes and tutorials.

mga boss ask ku lang panu mga pagsamasamahin ang maraming worksheet sa iisang worksheet... parang executive report pero di po graphs or numbers yung makikita.. text pa din po.. possible po ba na lookup ku na lang sya o pa pivot pa din..?



need HELP po plsssss

 

[kaytoy]

Re: MS excel we give solutions. formula, codes and tutorials.

mga boss ask ku lang panu mga pagsamasamahin ang maraming worksheet sa iisang worksheet... parang executive report pero di po graphs or numbers yung makikita.. text pa din po.. possible po ba na lookup ku na lang sya o pa pivot pa din..?



need HELP po plsssss

@akosiderek

medyo mahirap po ito. (as per my own opinion)
Options

1. Link2x ka mo na lang lahat ng mga worksheets into one worksheet.

2. Develop a table na lahat ng mga data dun mga worksheets mo ay nasa isang table na. after that you may use vlookup or better yet pivot table.

my answer is based only on what i understand... sowi kung palpak hehe...

- - - Updated - - -

@nash

Nice One Bro

pero as what i have stated earlier nag-record ako ng macro and inserted
the Loop Function para mag-copy sya until sa wala ng ma-kopya.

Created a button then assigned this macro to that button for your convenience in executing the macro.

I hope from here you can edit the code according to your specifications.

Sub Nash()
    Range("A2").Select
    Selection.Copy
    ActiveSheet.Next.Select
    Range("A2").Select
    ActiveSheet.Paste
    ActiveSheet.Previous.Select
    
Do Until IsEmpty(ActiveCell)
    ActiveCell.Offset(1, 0).Range("A1").Select
    Application.CutCopyMode = False
    Selection.Copy
    ActiveSheet.Next.Select
    ActiveCell.Offset(1, 0).Range("A1").Select
    ActiveSheet.Paste
    ActiveSheet.Previous.Select
Loop
    
End Sub

Pls. See Attached File

I hope it helps™


"To God be the Glory"

@nash

Eto pa rin yung gamitin mo na code kaya lang edit mo konti depending on the design of your table...

BTW - ang table ay automatic na naga-baba ang coverage kung may i-fill-in sa baba so no need to worry.

 

[akosidereck]

Re: MS excel we give solutions. formula, codes and tutorials.

boss yung gawa nyo ba e simpleng pivot chart lang ba yan o may coding na kasama..?


ask pa sir gamit lang ba ku hyperlink para malink ko as one yung worksheet..

 

[kaytoy]

Re: MS excel we give solutions. formula, codes and tutorials.

boss yung gawa nyo ba e simpleng pivot chart lang ba yan o may coding na kasama..?


ask pa sir gamit lang ba ku hyperlink para malink ko as one yung worksheet..

@Derek

Pivot Table and Pivot Chart doesn't need formula and any other complicated code... its just simple drag n drop.

di po hyperlink - just simple link. Just use the equal function or vlookup.

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials.

Dami ko na din natutunan sa excel actually puro dashboard nalang ang ginagawa ko para mas madali

eto pala mga ss na ginawa ko


Eto Sales ng P&G
View attachment 1040709

Eto naman attendance Monitoring nila.
View attachment 1040710

ganda ng dashboard mo boss.

both files has database sheet and this preview calculates the database depends on what reports you need.

eto ang sakin.
this dashboard doesnt have vba code. purely formulas lang.

this dashboard has macro i need to put macro because i need to automate some few things see those buttons? actually yun lang naman ang ginamitan ko ng vba mas user friendly kasi para sa gagamit.

pero actually madami na ko ginawang dashboard.


para sa lahat. if your going to create a dashboard, create a plan first before doing it. see the first page for tips. and you must think this is dashboard. dashboard report is to display the story behind the data and to show whats going on to the company or business etc..etc.. maging sa mga report analyst dito. think of the reports, why are you creating this. just imagine you are the boss of your own company. think why are you doing this. there are many answers,
which field need some attention?
which fields need some actions?
which fields needs to improve?

and its the best way to show the plain data into story telling number effectively.

thanks po sa inyo.