true power of MS excel. update: PowerBI

[aoshi62]

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

wala naman limit... ang problema lang syempre, habang dumadami arguments, nagiging mas kumplikado at mas mahirap i-trace ang errors or magdagdag ng argument pag kelangan mo... lalo na pag nakalimutan mo na yung logic

Maraming Salamat Sir
Napakalaking Tulong Nito Sakin

Next Question po..
Possible po ba sa excel kapag ang isang Cell eh hndi na update ng mga ilang araw ay.. Mag hahighlight xa? Salamat po

 

[themonyo]

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

Maraming Salamat Sir
Napakalaking Tulong Nito Sakin

Next Question po..
Possible po ba sa excel kapag ang isang Cell eh hndi na update ng mga ilang araw ay.. Mag hahighlight xa? Salamat po

I think conditional formatting kelangan dyan... Kaso hindi ko gamay yun
Hintay tayo sagot ng mga master dito

 

[kirby21]

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

wala naman limit... ang problema lang syempre, habang dumadami arguments, nagiging mas kumplikado at mas mahirap i-trace ang errors or magdagdag ng argument pag kelangan mo... lalo na pag nakalimutan mo na yung logic

tama to. hirap tignan pag super dami ng if. di pa naman pwede lagyan ng comment ang formula. di tulad ng vba.

- - - Updated - - -

Maraming Salamat Sir
Napakalaking Tulong Nito Sakin

Next Question po..
Possible po ba sa excel kapag ang isang Cell eh hndi na update ng mga ilang araw ay.. Mag hahighlight xa? Salamat po

you need column for date last update. or date entry. so ang formula sa conditional formatting dapat is =AND((TODAY()-$A2)>4,$A2<>"") then assign mo na color coding mo.

pacheck attachment

View attachment 299680

 

[hajievalleser]

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

TS, help nmn sa VBA code pra mgopen ng Internet explorer and search the given value.

Scenario:
magbbibigay si user ng case ID sa isang cell
then click the button it will directs you to the location of the case on their website.

kung may sample sheet po mas ok, ako n po bhla kalikutin. hehe
salamat po!

 

[edwardreborn]

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​

Super Thanks po dito

 

[maestrodos]

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

Nice thread sir. Halos eto lang din ginagawa ko sa company namin and elibs na sila, will try to contribute din for the sake of all.

 

[kirby21]

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

Nice thread sir. Halos eto lang din ginagawa ko sa company namin and elibs na sila, will try to contribute din for the sake of all.

tambay ka din dito boss

 

[themonyo]

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

Show your Tab name on a cell
Share ko 'tong formula na nahanap ko for future reference:

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1),1))

I use this formula on my Payroll and Billing forms instead na manually ko pa i-type everytime na gagawa ako ng bago. pag-rename ko ng tab name, palit na rin yung control number

 

[zairhiel]

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

salamat dito TS

 

[celsiuz19]

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

sir ask lang po newbie here? papano po gumawa ng barcode for storage warehouse po?? gsto ko talagang pag aralan un sir.. ty po sa makaka sagot

 

[kirby21]

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

sir ask lang po newbie here? papano po gumawa ng barcode for storage warehouse po?? gsto ko talagang pag aralan un sir.. ty po sa makaka sagot

if marunong ka sa macro you need to download barcode reference module.

 

[khalstrat]

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

maraming maraming salamat sa dito ts! dagdag kaalaman to

 

[tintasa]

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

Newbei po! Pwede po ba ma-input yung data sa excel papunta sa ibang application automatically e.g. powerpoint, etc? Kung oo pano po? Salamat...

 

[cyrus van]

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

Hi Sir,

Nsa baba po yng code ko, gusto ko po sanang mag reply sa current/active email message. binura ko nalang yung .reply na extension kasi ayaw din gumana.
ano po an kulang sa code? thanks po


Sub SEND()

Dim outlookapp As Object
Dim newmail As Object


Set outlookapp = CreateObject("outlook.application")

Set newmail = outlookapp.ActiveInspector.currentitem

With newmail
.to = "sample"
.Subject = "data"
.display

End With


Set newmail = Nothing
Set outlookapp = Nothing
End Sub

 

[themonyo]

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

Newbei po! Pwede po ba ma-input yung data sa excel papunta sa ibang application automatically e.g. powerpoint, etc? Kung oo pano po? Salamat...

try mo to:

open your excel spreadsheet
select the table you want to link to the other apps
copy the table
go to your other app
go to Edit menu or select Paste Special from the Toolbar
tapos may radio button dun sa bandang left side ng pagpipilian ng paste as link
then select Microsoft Excel Worksheet Object, then press Ok

that should be it... every time na edit mo yung excel source mo, magre-reflect na yan sa 3rd party document mo...
though there are restrictions... like kung open yung "other document" and you are working on your excel spreadsheet, you have to update manually or there would even be an error na open daw yung file.

 

[johnrob17k]

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

pa BM muna ako bossing maraming pong salamat po

 

[sekaraininku]

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

Good day mga excel masters! tanong ko lang kong pwede to. bale may tatlo akong criteria. tapos under sa isang criteria may mga pending. gusto ko sana na nka .vba xa. 1 click lang ng button at i fifilter na nya yung mga blank/pending cells. screenshot provided thanks!

View attachment 301953

 

[khevzsDgreat]

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

another update by our regular member from excel analytics.

http://www.symbianize.com/attachment.php?attachmentid=1053024&stc=1&d=1440139403


101 Ready-to-Use Excel Formulas (Mr. Spreadsheet's Bookshelf)
Michael Alexander | Wiley | August, 2014 | 240 pages | English |

This is the sort of book that is well worth its space on the bookshelf. I recall using several of the formulas in this guide, but it has been long enough that most of them have slipped my mind. There are many interesting formulas that are new to me as well. This thin book is filled with practical excel formulas, presented in a concise manner. Introductory notes of sorts will precede a formula, with an explanation of how it works to follow. There are several alternatives offered, where applicable. Early chapters provide formula fundamentals, and progressively move into more intricate formulas further in. There are basic formulas for totals, complex formulas that refer to other worksheets, lookup formulas, string concatenation formulas, conditional formulas, and all sorts of fun things to have within reach. I love this handy little reference, and if the rest of the Mr. Spreadsheet's Bookshelf series of books is anything like this, it would make for quite the collection of just the facts guides that minimize the need to rummage through pages. With 101 Ready-to-Use Excel Formulas, when you need it, you quickly find it, and then you're done.

kesa gumawa pa ko ng thread dito ko nalang post if ok lang sayo TS? Malaking tulong to satin mga excel users

Or you can download here for more tips ~ http://extratorrent.cc/search/?search=101+excel&new=1&x=0&y=0

may files po ba tayo nyan sir na pang idm?

 

[zebediah]

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​

ang galing

 

[schrismo]

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

Thank you po ng madami