Q:

Case statement to add extra column with custom data

Need some help with building a case statement. My information brought back is telemetry based and need to adjust where a solution name is "Excel" I need it to rename it to "Microsoft Excel" (just an example). The coloumn with the data is called "Solution name". 
Something in the line of Where solution name is "excel" then "MS excel"
Any help will be useful, thanks
Code below
let
    Source = Sql.Database("xx.xxx.xx.xx\Telemetry", "TELEMETRY"),
    dbo_Lookup_solutions = Source{[Schema="dbo",Item="Lookup_solutions"]}[Data]
in
    dbo_Lookup_solutions

A:

Case when solution like ‘%excel%’ then ‘msexcel’ else solution end

