Power Tools sidebar offers a smart toolbar at the top for the most common operations. Each operation is available at a single click, with optional drop-down lists next to the default action. The only exceptions are Advanced Find and Replace, Function by Color and Sheets Manager: the tools take the entire sidebar with their settings. Sort by Color offers both the options in the drop-down as well as sidebar with advanced settings.
Go to Extenstions > Power Tools > Start to open the add-on in Google Sheets:
You will see the Power Tools sidebar with the toolbar options right at its top.
This two-step add-on performs a comprehensive search in the selected sheets, shows the list with the results, and allows you to browse, export, or replace the found entries:
Learn how to find and replace data in your sheets.
Function by Color allows you to calculate records formatted in a certain way in any range.
Learn how to calculate cells by their colors.
Sheets Manager is the most convenient and friendly-user way to see, select & handle sheets in bulk: hide sheets, lock, color, reorder, etc.
Learn how to easily manage several sheets.
Though Google Sheets has its tool to sort by color, this utility offers sorting by colors from another angle. It sorts either your selected range or the entire sheet by the fill or font colors they contain.
Learn how to sort by color in Google Sheets.
This one is the shortcut to changing cases in all cells of interest.
First, tick off the Ignore formulas option if you want to prevent all formulas you may have from turning into values. The tool won't process such cells at all.
Then, select the necessary data in your spreadsheet, click on the tool's icon, and choose one of 6 cases:
Select any cell in your table, click the tool icon and hit whatever you want to get rid of:
The utility lets you get the formulas for the most common functions in a click. Even if you have multiple columns with numbers, simply select empty cells under those columns. The add-on will quickly process the data in each column and paste the correct result to each corresponding empty cell.
Use this tool to normalize a pivot table and get a flat list instead.
Select the range with your crosstab table, click the icon with three dots on the Power Tools smart toolbar, then on the Unpivot Table icon itself, and have the resulting database list pasted to a new spreadsheet:
Supposedly a simple task of flipping two adjacent cells involves a lot of copying and pasting. The Flip tool allows you to do this in just two clicks:
Last but not least is the little assistant that helps you unmerge cells. You'll find it if you click the icon with three dots on the toolbar: