Excel
-
Basic Excel Functions
EXCEL FUNCTIONS_Basic AND Returns “TRUE” or “FALSE” based on two or more conditions. =AND(B2=”Fire”;C2>70) =IF(AND(B10=”Fire”;C10>70);”Yes”;”No”) AVERAGE Calculates the average =AVERAGE(B2:E2) AVERAGEIF Calculates the average of a range based on a true or false condition. =AVERAGEIF(range, criteria, [average_range]) AVERAGEIFS The average of a range based on one or more true or false condition. =AVERAGEIFS(average_range, criteria_range1, criteria1, …) CONCAT To link something together. =CONCAT(A2,” “,A3) =CONCAT(A2,”and”,A3) …
-
Excel, CSV, Data Table activities with RPA(UiPath)
Excel, Data Table with Uipath Excel Application Scope Used for working with the specified Excel file Making Data Table Activities Build Data Table Read Range Read CSV Data Scraping (Web) Generate Data Table (Text) Editing Data Table Activities Add Data Column Add Data Row Clear Data Table Filter Data Table For Each…