# data[].attributes.body
Bakit po minsan mabagal ang excel or hindi na nya ako mahal?

# data[].attributes.headline
ano po ang formula ng reverse concatenate?

# data[].attributes.subject
ano po ang formula ng reverse concatenate?

# data[].attributes.body
mayroon bang shortcut or formula na pwde gawin automatic ung middename to middle initial??

# data[].attributes.body
What is the difference of vlookup and hlookup. Thank you. 🫰🏻

# data[].attributes.body
pwede po pa install ng pentaho app sa aming laptop??

# data[].attributes.body
Ano po purporse nito? Huhu

# data[].attributes.headline
Let's go with CONCANTENATE. Very useful po kasi. 

# data[].attributes.subject
Let's go with CONCANTENATE. Very useful po kasi. 

# data[].attributes.body
Assalamu alaykum pwede po ba makahingi ng soft copy nyang sample data na gamit niyo ngayon para same content po nagagamit namin. Salamat

# data[].attributes.body
Salam. Good morning. Baka pwede po natin mapakita sa lahat ung terminology ng mga formula na gagamitin. For example,

=iferror(vlookup(" ") Function is _______

# data[].attributes.headline
I THINK WE SHOULD EXPLAINED THE FUMCTIONS OF EACH FORMULA PARA ALAM SAAN AT KAILAN GAGAMITN

# data[].attributes.subject
I THINK WE SHOULD EXPLAINED THE FUMCTIONS OF EACH FORMULA PARA ALAM SAAN AT KAILAN GAGAMITN

# data[].attributes.body
bk pwd kau mgbigay ng sample ng mga formula f anu ang function nila bawat isa...tapos specific sya atlis maintindhan ng lht..halimbawa f ginamit ko si =iferror at iba png formula may mkita kmi n sample n pwd nmin gayahin. visual/verbal vs actual

# data[].attributes.body
Di po kami makasabay kasi wala po kaming app ng PDI. Baka pwedeng pakifacilitate ang downloading nung app and pakibigay na rin po nung excel file na ginagamit nyo, to ensure na we are on the same page.

# data[].attributes.body
HELLO SIR KAMUSTAHIN NYO NAMAN PO KAME 🥺

# data[].attributes.attachment_link.readable_text
SUM: Adds up a range of numbers.
=SUM(A1:A10)

AVERAGE: Calculates the average of a range of numbers.
=AVERAGE(B1:B10)

VLOOKUP: Searches for a value in the first column of a range and returns a value in the same row from another column.
=VLOOKUP(C2, A2:B10, 2, FALSE)

IF: Returns one value if a condition is true and another if false.
=IF(D2>100, "Yes", "No")

CONCATENATE: Combines text from multiple cells into one.
=CONCATENATE(E2, " ", F2)

COUNTIF: Counts the number of cells that meet a condition.
=COUNTIF(G2:G10, ">50")

LEN: Returns the length of a text string.
=LEN(H2)

LEFT: Extracts a specific number of characters from the start of a text string.
=LEFT(I2, 5)

RIGHT: Extracts a specific number of characters from the end of a text string.
=RIGHT(J2, 3)

MAX: Returns the largest number in a range.
=MAX(K2:K10)

MIN: Returns the smallest number in a range.
=MIN(L2:L10)

ROUND: Rounds a number to a specified number of digits.
=ROUND(M2, 2)

SUMIF: Adds up cells that meet a specific condition.
=SUMIF(N2:N10, ">100")

INDEX: Returns the value of a cell in a specified row and column within a range.
=INDEX(O2:O10, 3)

MATCH: Returns the relative position of a specified value within a range.
=MATCH("Apple", P2:P10, 0)

MID: Extracts a specific number of characters from a text string, starting at a given position.
=MID(Q2, 3, 4)

NOW: Returns the current date and time.
=NOW()

TODAY: Returns the current date.
=TODAY()

SUBTOTAL: Performs a specified function (like SUM, AVERAGE) on a filtered list.
=SUBTOTAL(1, R2:R10)

TRIM: Removes extra spaces from a text string, leaving only single spaces between words.
=TRIM(S2)

COUNT: Counts the number of cells that contain numbers.
=COUNT(T2:T10)

COUNTA: Counts the number of non-empty cells.
=COUNTA(U2:U10)

COUNTBLANK: Counts the number of empty cells in a range.
=COUNTBLANK(V2:V10)

TEXT: Converts a value to text in a specified format.
=TEXT(W2, "MM/DD/YYYY")

IFERROR: Returns a specified value if a formula results in an error; otherwise, returns the formula's result.
=IFERROR(X2/Y2, "Error")

AND: Returns TRUE if all conditions are TRUE, otherwise FALSE.
=AND(Z2>50, AA2<100)

OR: Returns TRUE if any condition is TRUE, otherwise FALSE.
=OR(AB2="Yes", AC2="No")

PMT: Calculates the payment for a loan based on constant payments and a constant interest rate.
=PMT(AD2/12, AE2, -AF2)

RANK: Returns the rank of a number within a list of numbers.
=RANK(AG2, AH2:AH10)

PROPER: Capitalizes the first letter of each word in a text string.
=PROPER(AI2)

HLOOKUP: Searches for a value in the top row of a range and returns a value in the same column from another row.
=HLOOKUP("SearchValue", AJ2:AK10, 3, FALSE)

ABS: Returns the absolute value of a number (removes the sign).
=ABS(AL2)

POWER: Raises a number to the power of another number.
=POWER(AM2, 3)

CEILING: Rounds a number up to the nearest multiple of a specified value.
=CEILING(AN2, 5)

FLOOR: Rounds a number down to the nearest multiple of a specified value.
=FLOOR(AO2, 5)

LARGE: Returns the k-th largest value in a data set.
=LARGE(AP2:AP10, 2)

SMALL: Returns the k-th smallest value in a data set.
=SMALL(AQ2:AQ10, 3)

MOD: Returns the remainder after a number is divided by a divisor.
=MOD(AR2, 3)

CHOOSE: Returns a value from a list of values based on an index number.
=CHOOSE(2, "Apple", "Banana", "Cherry")

TEXTJOIN: Combines text from multiple ranges or strings, separating them with a specified delimiter.
=TEXTJOIN(", ", TRUE, AS2, AT2, AU2)

REPT: Repeats a text string a specified number of times.
=REPT("Hello", 3)

SEARCH: Finds the position of a substring within a text string (case-insensitive).
=SEARCH("find", AV2)

REPLACE: Replaces part of a text string with another text string.
=REPLACE(AW2, 1, 5, "NewText")

VALUE: Converts a text string that represents a number to a number.
=VALUE(AX2)

NETWORKDAYS: Returns the number of working days between two dates, excluding weekends and holidays.
=NETWORKDAYS(AY2, AZ2, Holidays)

EOMONTH: Returns the last day of the month, a specified number of months from a start date.
=EOMONTH(BA2, 1)

YEARFRAC: Calculates the fraction of the year between two dates.
=YEARFRAC(BB2, BC2)

OFFSET: Returns a reference to a range that is a specified number of rows and columns from a cell or range.
=OFFSET(BD2, 1, 2)

ISNUMBER: Checks if a value is a number and returns TRUE or FALSE.
=ISNUMBER(BE2)

INDIRECT: Returns the reference specified by a text string.
=INDIRECT("BF" & BG2)

# data[].attributes.body
Please familiarize the EXCEL functions. Marami sa atin ang nawawala hehehe. Thank you Sam sa pag share.

# data[].attributes.body
Sir, bilis nyo po mag discuss. 😭

# data[].attributes.headline
paano po hatiin into (first name, middle name, and last name)ang list ng names. Particulary sa two names, sample (Bai Nor-ain Salik Nakan).

# data[].attributes.subject
paano po hatiin into (first name, middle name, and last name)ang list ng names. Particulary sa two names, sample (Bai Nor-ain Salik Nakan).

# data[].attributes.body
Hello po, masingit din po san yung hlookup at xlookup formula

# data[].attributes.headline
Hello po sir harris. Baka pwede paassist kami sa mga poging ICT team😊

# data[].attributes.subject
Hello po sir harris. Baka pwede paassist kami sa mga poging ICT team😊

# data[].attributes.body
MOC aliuden will assist from the ICT

# data[].attributes.body
infareness dikoGETs...hehe

# data[].attributes.headline
Plss louder sir Hindi namin marinig masyado dito sa likod

# data[].attributes.subject
Plss louder sir Hindi namin marinig masyado dito sa likod

# data[].attributes.body
If pwede po, mabigyan kami ng hand outs with sample/formula

# data[].attributes.body
Every POO/MOO nlng meron isang turuan PRA s laptop..

# data[].attributes.body
Ang cute po ng haircut niyo sir Nas.

# data[].attributes.body
bk pwd lht ng formula i copy paste nlng dito pra ma practice nmin...

# data[].attributes.headline
paano i count ang remaining days ng CS15 bago ma tag as cs29

# data[].attributes.subject
paano i count ang remaining days ng CS15 bago ma tag as cs29

# data[].attributes.body
paano i count ang remaining days ng CS15 bago ma tag as cs29