true power of MS excel. update: PowerBI

[hardcorekid03]

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

mga master paturo naman po ng katulad ng ganito https://www.youtube.com/watch?v=I0GhG_51QF8

 

[caraphernelia]

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

may way po ba para i-protect yung worksheet tapos pwede pa rin mag run yung macro na mag aadd/delete ng row sa table?

 

[Qowin]

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

Gusto ko po sana magpatulong kung posible ito using Excel.
Bale sa office may excel file kami kung saan iniinput namin yung daily purchases ng mga accounts. Manually mo ichecheck kung inactive na yung account.

Ang gusto ko po sanang gawin ay kung pwede merong Summary ng purchases sa isang sheet and also parang may notification na inactive na yung account.
Also every month po meron kaming mga bagong accounts na dumadating, if possible kung pwede auto update na din kasama yung dun sa summary.

Idagdag ko pa po na yung ibang accounts ay umuutang via (Charge Invoice), posible po ba na pati ito ma record.

Pasensya na po kung medyo malabo yung pagkakaexplain ko.

 

[chester92]

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

Sirs, may tutorial po ba kayo sa pivoting at yung vlook-up at hlook-up? Yung tagalog version po.. Maraming salamat..

 

[hephooray]

Mga master paturo naman ako, regarding sa excel bording may file kasi ako pero separated sya ng mga blank cell per row.
my problem is pano siya mapapdali lagyan ng border na hindi malalagyan ng border yung mga blank cell(row).

Thanks here's my file.

 

[puuts]

Mga master paturo naman ako, regarding sa excel bording may file kasi ako pero separated sya ng mga blank cell per row.
my problem is pano siya mapapdali lagyan ng border na hindi malalagyan ng border yung mga blank cell(row).

Thanks here's my file.

[SIZE=3]1. Highlight Column B-O
2. Go to Conditional Formatting (Nasa Home Tab)
3. Select  New Rule
4. Select Format only cells that contain
5. Sa Format only cells with, piliin mo No Blanks
6. Click Format
7. Select Border Tab
8. Select Outline.
9. Click Ok.
10. Click Ok.
11. Salamat.[/SIZE]

 

[hephooray]

[SIZE=3]1. Highlight Column B-O
2. Go to Conditional Formatting (Nasa Home Tab)
3. Select  New Rule
4. Select Format only cells that contain
5. Sa Format only cells with, piliin mo No Blanks
6. Click Format
7. Select Border Tab
8. Select Outline.
9. Click Ok.
10. Click Ok.
11. Salamat.[/SIZE]

@puuts

Thank you very much sayo. up na up . god bless

 

[kirby21]

reopened the thread. sorry baka naclosed ko accidentally. thanks to themonyo.

 

[themonyo]

yung nakapag upgrade to ms office 2019 dyan, may mga bago tayong functions

CONCAT
This new function is like CONCATENATE, but better. First of all, it's shorter and easier to type. But it also supports range references, in addition to cell references.

IFS
Tired of typing complicated, nested IF functions? The IFS function is the solution. With this function, conditions are tested in the order that you specify. If passed, the result is returned. You can also specify an else "catch all" if none of the conditions are met.

MAXIFS
This function returns the largest number in a range, that meets a single or multiple criteria.

MINIFS
This function is similar to MAXIFS, but it returns the smallest number in a range, that meets a single or multiple criteria.

SWITCH
This function evaluates an expression against a list of values in order, and returns the first matching result. If no results match, the "else" is returned.

TEXTJOIN
This function combines text from multiple ranges, and each item is separated by a delimiter that you specify.

 

[themonyo]

mga master, hingi sana ako tulong

ang concern ko ay yung linked photos/images. pag nag-insert ako ng photo as link, nagiging absolute path ang nilalagay nya.
ex: "C:\Users\123456\Documents\saging.jpg"
so, kung nilipat ko yung files ng location or kung i-email ko, mapuputol yung link.
kelangan ko sana, relative or same path lang yung source images and spreadsheet.

may mga vba macros pa akong nakita pero di ko rin napagana sa sample ko.
any idea para maging portable to?

 

[bhoc84]

may way ba para mapalaki ang font ng text inside sa combo box

 

[Sang Real]

help! po sa code kung paano gumawa ng katulad mismo na nasa video.

patulong po sa code, kapag iclick yung pic lalabas sa cell at kung mapansin

nyo may checkbox option na pag nag-type ka sa cell lalabas ang pic sa cell.

Salamat in advance sana may matyaga na gawin ang code.

 

[johnine01]

create ka hiwalay na thread for power BI sir

 

[astaroth13]

Malaking tulong po ito sa amin boss...

 

[BurtKocaine]

need help mga master

pano ko po mafi filter yung latest version from column A ang result na gusto ko po yung sa column B.
naka attached po yung file ko.

thanks in advance po


Column A Column B

DDD-01050-00K
DDD-01050-01K DDD-01050-01K
DDD-01050-01
DDD-01050-02 DDD-01050-02
DDD-01410-01Z
DDD-01410-02Z
DDD-01410-03 DDD-01410-03
DDD-01412-01S
DDD-01412-02S
DDD-01412-03 DDD-01412-03
DDD-03000-01X
DDD-03000-02 DDD-03000-02
DDD-04594-00L
DDD-04594-01 DDD-04594-01
DDD-05188-01
DDD-05188-02 DDD-05188-02
DDD-05189PZ-00
DDD-05189PZ-01
DDD-05189PZ-02
DDD-05189PZ-03
DDD-05189PZ-04
DDD-05189PZ-05
DDD-05189PZ-06
DDD-05189PZ-07 DDD-05189PZ-07
DDD-05190CZ-00
DDD-05190CZ-01 DDD-05190CZ-01
DDD-05191CZ-00
DDD-05191CZ-01
DDD-05191PZ-02 DDD-05191PZ-02
DDD-05194-02
DDD-05194-03 DDD-05194-03
DDD-05196-00
DDD-05196-01
DDD-05196-02 DDD-05196-02

 

[-A7PHA-]

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

Thanks TS, applicable po ba sya sa lahat ng excel verstion?

 

[themonyo]

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

Thanks TS, applicable po ba sya sa lahat ng excel verstion?

mostly, yes... unless kasama yung formula mo mismo sa latest feature set ng bagong version ng excel

nga pala, we can actually use excel (or any other ms office app) for free via our browser. kelangan mo lang ng microsoft account
https://office.live.com/start/Excel.aspx

hiwalay pa yan sa MS Office 365 which always include the newest features and bug fixes. matagal ko ng pinagiisipang patulan yung mga office 365 account sa lazada

 

[BurtKocaine]

Gandang umaga po sa lahat...Up ko lang po sana may makatulong. thanks

 

[deadlysins21]

Thank you dito. Up up

 

[blanksky08]

wala po bang video tutorial sa conditional formatting??