To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen ...
To manually crop a picture in Microsoft Word, Excel, or PowerPoint, select it, and in the Picture Format tab on the ribbon, click the top half of the split "Crop" button.