In terms of popularity I'd say Python>R>Julia R might be closest in syntax to how excel works, especially with the ifelse functions. R also has dplyr, which is

In terms of popularity I'd say Python>R>Julia R might be closest in syntax to how excel works, especially with the ifelse functions. R also has dplyr, which is unmatched in how it makes data manipulation easy and streamlined