AVERAGEA Function in Excel: Average Counting Text as Zero
AVERAGEA treats text as 0 and TRUE as 1. Use it when βabsentβ should drag the average down rather than be ignored.
Read article βExcel, SAP, Oracle & automation tips β plus wacky facts
AVERAGEA treats text as 0 and TRUE as 1. Use it when βabsentβ should drag the average down rather than be ignored.
Read article βINFO returns details like the Excel version, operating system or current folder.
Read article βSUMPRODUCT multiplies arrays and adds the result β which makes it a multi-condition counter, a weighted average, a case-sensitive lookup and more, in everyβ¦
Read article βSHEETS counts sheets in a reference or the whole workbook β including hidden ones.
Read article βSAP Modules can be categorized into Functional Modules and Technical Modules. Key modules include FI, CO, and many others for enterprise operations.
Read article βAPIs explained with a restaurant analogy, then a real example: fetch exchange rates with a URL, read the JSON, and pull it into Excelβ¦
Read article βRTD pulls live values from a real-time data server, e.g. stock prices from a broker's trading terminal add-in. You need the provider's RTD serverβ¦
Read article βUse k-means clustering to split customers into segments by orders, spend and recency β reading from and writing back to Excel with pandas andβ¦
Read article βREGISTER.ID returns the register ID of a DLL function for CALL. Same legacy, same security restrictions.
Read article βWEBSERVICE downloads text from a web address (Windows desktop only). Combined with FILTERXML or TEXTAFTER it can read simple APIs.
Read article βSWITCH compares one value with a list and returns the matching result β cleaner than nested IFs for exact matches.
Read article βAnalyse data with dplyr verbs: filter rows, mutate new columns, arrange, group_by and summarise β the R equivalent of filters, formulas and pivot tables.
Read article βYou blink around 15β20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.