true power of MS excel. update: PowerBI

[iduyanrosielyn]

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

panong drop down list?

may example kaba? if meron, paki-post.

Bali po. Imbes na button droplist po siya.

 

[puuts]

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

Bali po. Imbes na button droplist po siya.

Pacheck neto.

 

[ramlei]

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

Hi sir/ma'am,
Help po, pwede po ba makahingi ng installer ng Unviewable+ for excel. Ginagamit po sya para masecure ang vba codes. Just really need it.
Thanks.

 

[raydhumble]

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

Saan nakkabili ng ganitong book boss?

 

[Mar Lon]

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

Deadlink na po

 

[LIANN0220]

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

gagana po ba to sa ms excel 2016?

 

[Mar Lon]

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

may active pa po ba na contributor dito? sayang po tong thread marami pa sana tong matutulungan.

 

[puuts]

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

may active pa po ba na contributor dito? sayang po tong thread marami pa sana tong matutulungan.

meron naman. post ka lng ng question brader. try ka namin tulungan

 

[Mar Lon]

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

meron naman. post ka lng ng question brader. try ka namin tulungan

Mga Boss, may tatanong lang po sana ako if possible pong gumawa ng program sa vba excel 2007 na galeng csv files tapos iimport po sya pag ka import po naka graph na sya together with other details na nasa csv? eto po yung link https://drive.google.com/open?id=0B1...jRiMDUtZ0tpb0E maraming pong salamt.

 

[Derckmix]

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

Malaking tulong to TS more power sa inyo at maraming salamat...!!!

 

[puuts]

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

Mga Boss, may tatanong lang po sana ako if possible pong gumawa ng program sa vba excel 2007 na galeng csv files tapos iimport po sya pag ka import po naka graph na sya together with other details na nasa csv? eto po yung link https://drive.google.com/open?id=0B1...jRiMDUtZ0tpb0E maraming pong salamt.

not found ung link mo brader. pa attached na lang dito.

 

[Mar Lon]

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

not found ung link mo brader. pa attached na lang dito.

boss pano po mag attached dito ng file. sorry.

- - - Updated - - -

not found ung link mo brader. pa attached na lang dito.

https://drive.google.com/open?id=0B1A-10nhBFwuajRiMDUtZ0tpb0E

Boss eto yung link hindi ko po mai-attached yung file e.

 

[puuts]

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

boss pano po mag attached dito ng file. sorry.

- - - Updated - - -




https://drive.google.com/open?id=0B1A-10nhBFwuajRiMDUtZ0tpb0E

Boss eto yung link hindi ko po mai-attached yung file e.

pwede mo ba ako bigyan ng sample graph with details na sinasabi mo?

 

[Mar Lon]

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

pwede mo ba ako bigyan ng sample graph with details na sinasabi mo?

actually sir galeng sya sa platform namen. since hndi po kame ang developer nun. may binigay syang download guide yung nga yung CSV file. ang balak sana namen sir kahit anong graph na lang, basta maipakita yung progress ng student kung sino yung mga nag basa ng libro at nakatapos. pero ang kailangan sana namin yung nakaprogram na i mean yung mag iimport lang kame ng csv file na galeng sa platform namen then pag ka click ng button lalabas yung report together with graphs and other details, possible po kaya ito sir?

- - - Updated - - -

pwede mo ba ako bigyan ng sample graph with details na sinasabi mo?

https://drive.google.com/open?id=0B1A-10nhBFwuUkhSaW5HM2FTelE eto po yung nasa platform namen na graph.

 

[puuts]

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

actually sir galeng sya sa platform namen. since hndi po kame ang developer nun. may binigay syang download guide yung nga yung CSV file. ang balak sana namen sir kahit anong graph na lang, basta maipakita yung progress ng student kung sino yung mga nag basa ng libro at nakatapos. pero ang kailangan sana namin yung nakaprogram na i mean yung mag iimport lang kame ng csv file na galeng sa platform namen then pag ka click ng button lalabas yung report together with graphs and other details, possible po kaya ito sir?

- - - Updated - - -



https://drive.google.com/open?id=0B1A-10nhBFwuUkhSaW5HM2FTelE eto po yung nasa platform namen na graph.

posible yan brader. ang gusto ko lang sana is mag-attached ka dito ng sample na graph and other details na sinasabi mo galing dun sa csv, para ma-replicate ko. mas maganda sana kung excel file ung graph at hindi picture para makita ko yung source.

 

[Mar Lon]

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

posible yan brader. ang gusto ko lang sana is mag-attached ka dito ng sample na graph and other details na sinasabi mo galing dun sa csv, para ma-replicate ko. mas maganda sana kung excel file ung graph at hindi picture para makita ko yung source.

Hi, sir ganyan sana gusto kong mangyare sa graph at inattached ko na din po yung CSV files na pinag kuhaan ko, actually gnawa ko pong reference yung gawa na sir kirby. then gusto ko sana 3D yung graph if possible? tapos yun nga sir yung magkakaron lang po sya ng button na kung saan iimport ko yung csv files then pagka import download yung inimport ko after ko i-download lalabas na po syang naka graph. salamat sa pag response sir.

 

[puuts]

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

Hi, sir ganyan sana gusto kong mangyare sa graph at inattached ko na din po yung CSV files na pinag kuhaan ko, actually gnawa ko pong reference yung gawa na sir kirby. then gusto ko sana 3D yung graph if possible? tapos yun nga sir yung magkakaron lang po sya ng button na kung saan iimport ko yung csv files then pagka import download yung inimport ko after ko i-download lalabas na po syang naka graph. salamat sa pag response sir.

yung Brands (row F4) sa Graph na file is magiging Student Id from csv file? tama ba pagkaka intindi ko? If yes, 2046 rows ung student id mo, so kelangan ipakita to ng detailed sa graph file? yung example mo sa graph file is yung student mo is hanggang student 10 lng, kung ggmitin naten tong student id from csv, hahaba ung rows kasi 2046 ung student id mo. san ko ilalagay ung graph? sa bandang kanan ng Lexile para nasa taas din?

 

[Mar Lon]

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

yung Brands (row F4) sa Graph na file is magiging Student Id from csv file? tama ba pagkaka intindi ko? If yes, 2046 rows ung student id mo, so kelangan ipakita to ng detailed sa graph file? yung example mo sa graph file is yung student mo is hanggang student 10 lng, kung ggmitin naten tong student id from csv, hahaba ung rows kasi 2046 ung student id mo. san ko ilalagay ung graph? sa bandang kanan ng Lexile para nasa taas din?

yung (row F4) po is Student name po sir. Yes sir tama po pag kakaintindi nyo. pwede naman po sa gilid na lang ng lexile. Thanks in advance sir.

 

[puuts]

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

yung (row F4) po is Student name po sir. Yes sir tama po pag kakaintindi nyo. pwede naman po sa gilid na lang ng lexile. Thanks in advance sir.

eto brader

 

[mistysparkles]

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

hi mga sir, please help me. i want to do a program using vba/macro (not sure if ano ba talaga dapat since i only know advanced excel pero wala pa kong idea sa vba and macro and programming).

i am doing weekly sales report and the raw data is coming from a data warehouse (in excel din) and i am doing vlookup for each day which is tedious kasi i need to do it everyday. now, i want my file to automatically get the data from another excel file and hindi ko na i-vlookup yung everyday sales from another excel.

is it possible na i-refresh ko lang yung file ko and it would automatically get the data from another file? kindly take note na dapat everyday siya mag-update then may mga formulas like sum of specific cells sa baba.

thank you so much in advance!!