true power of MS excel. update: PowerBI

[Gatorade]

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

dload ko to tnx

 

[bhoc84]

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

salamat sa mga natutunan ko sa thread nato. hopefully my bagong matambayan na may mga ganitong topic

 

[slaprinoa]

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

sir kirby sana gawa po kau ng group sa fb pra d2. sayang nmn poh
mdami dn kme natutunan. mdami dn po ngsshare ng kni knilang alam
pra mas mapabilis at quality ang work.

magsasara na ang symbianize at nkakalungkot
mawawala ang mga ganitong bgay.

salamat po

 

[heinz12]

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

pa help po sa code dapat ung result katulad nang na sa picture.salamat
View attachment 351992

Sub ListRolling()
Dim X As Long, LastRow As Long, vArrIn As Variant, vArrOut As Variant
Dim ws As Worksheet
LastRow = Cells(Rows.Count, "f").End(xlUp).Row
vArrIn = Range("f1:f" & LastRow)

ReDim vArrOut(1 To 35, 1 To Int(LastRow / 35) + 1)
For X = 0 To LastRow - 1
vArrOut(1 + (X Mod 35), 1 + Int(X / 35)) = vArrIn(X + 1, 1)
Next

Range(Cells(6, 1), Cells(400, 3)) = ""
Range("a5").Resize(35, UBound(vArrOut, 2)) = vArrOut

End Sub

 

[myslickcaddz2k12]

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

pa subscibre ts..hehehe..wait ko to..

 

[machogwafito]

see 2nd reply for powerbi update​

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​

salamat dito ts will subscribe po

 

[kennethelcano]

Keep sharing mga Master.

 

[kirby21]

welcome back guys.

 

[BurtKocaine]

welcome back po sa lahat! buti na lang di nawala ang thread na to!

 

[meriam]

welcome back guys.

Tuloy ang lingaw sa mobilarian sir.

 

[loveshrink027]

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

sir baka pwedeng humingi ng format ng excel para magamit sa pagcoconsolidate ng mga purchase orders.. thanks

 

[kirby21]

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

sir baka pwedeng humingi ng format ng excel para magamit sa pagcoconsolidate ng mga purchase orders.. thanks

Ano ba mga PO nyo? Need sample.

 

[knives645]

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

sir baka pwedeng humingi ng format ng excel para magamit sa pagcoconsolidate ng mga purchase orders.. thanks

Send sample PO and if you have final output/summary, much better.

 

[opow]

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

Nice post sir. Dagdag kaalaman.

 

[markkho1990]

Hello pwede mag tanung. pano ba yung pag Lock ng Excell after Data Entry. tpus may warning sya.

Hal.
Pag enter ng Data hindi na pwede palitan. and may range lng ng cells yung ganun
And before i final enter yung data may Warning na Hindi na pwede palitan after data entry and may Yes or no kung i finalize yung entry.

Office 365 yung gamit ko.
Nakuha ko na kung saan yung Developer Mode and Visual Basic. yung codes lng yung hindi ko gets.

TIA

 

[chrizvexx2012]

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

patulong naman sir kung papano gamitin ang excel para sa monitoring ng documents ung para mabilis matrack ung date of receive or dispatched at may database
thanks po

 

[incubaby701]

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

ASK: possible ba e save sheet lng instead of workbook? excel file pa din.
now kc gamit ko save as pdf. Minsan kc meron mga edits.. kaya balik ulit sa simula :|

xoxo
Noobie

 

[Alexandrusse]

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

ASK: possible ba e save sheet lng instead of workbook? excel file pa din.
now kc gamit ko save as pdf. Minsan kc meron mga edits.. kaya balik ulit sa simula :|

xoxo
Noobie

Can't be. Pinaka container kasi yung work book. Ano bang gsto mong ma achieve? Kung dahil sa na eedit, pwede k naman mgsave muna ng back up bago mo baguhin yung laman. Or mas maigi if i explain mo muna. Medyo vague kasi ung statement mo.

 

[xSaichi]

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

sir @Kirby / TS pwede po ba ako magpaturo sainyo in Vlookup and Access sa actual po? hehe

 

[incubaby701]

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

bali isang workbook.. may 5 sheets.

sheet1 - client info
sheet2 - items
sheet3 - invoice
sheet4 - delivery receipt (dr)
sheet5 - purchase order (p.o)

gusto ko sana yun invoice ma save sa isang folder pra sa invoice. same as dr at p.o
gusto ko sana e save sila hiwalay na.

sa ngayon saves as PDF nlng ginagawa ko sa invoice. tas yun dr at p.o hiwalay ko muna ng workbook.
pero gusto ko save as .xls lng sana pra ma edit dn sya.