Internet Search Results 

Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

RIGHT, RIGHTB functions - Microsoft Support
RIGHT returns the last character or characters in a text string, based on the number of characters you specify. RIGHTB returns the last character or characters in a text string, based on the number of bytes you specify. These functions may not be available in all languages.

Import data from a folder with multiple files (Power Query) - Microsoft ...
Use Power Query to combine multiple files with the same schema stored in a single folder into one table. For example, each month you want to combine budget workbooks from multiple departments, where the columns are the same, but the number of rows and values differ in each workbook.

RRI function - Microsoft Support
This article describes the formula syntax and usage of the RRI function in Microsoft Excel. Returns an equivalent interest rate for the growth of an investment. RRI (nper, pv, fv) The RRI function syntax has the following arguments. Nper Required. Nper is the number of periods for the investment. Pv Required.

Select data for a chart - Microsoft Support
Learn best ways to select a range of data to create a chart, and how that data needs to be arranged for specific charts.

Show or hide the ribbon in Office - Microsoft Support
Show the ribbon when hidden, and set options to shows tabs and commands, just tabs, or automatically hide the ribbon for the maximum document space.

Group or ungroup shapes, pictures, or other objects - Microsoft Support
Grouping lets you rotate, flip, move, or resize all shapes or objects at the same time as though they were a single shape or object. You can also change the attributes of all of the shapes in a group at one time, such as adding a shape fill or effect, or an effect to a picture.

Use the Selection pane to manage objects in documents
You can use the Selection pane to manage objects in your document: re-order them, show or hide them, and group or ungroup them. Tip: In Word, you might want to set the location of objects within a paragraph. When you move a paragraph, the corresponding anchored image (s) move with the paragraph.

Accessibility best practices with Excel spreadsheets
Use a simple table structure for data only, and specify column header information. To ensure that tables don’t contain split cells, merged cells, or nested tables, use the Accessibility Checker. Visually scan your tables to check that they don't have any completely blank rows or columns.

REPLACE, REPLACEB functions - Microsoft Support
REPLACEB replaces part of a text string, based on the number of bytes you specify, with a different text string. These functions may not be available in all languages.

Video: Add and delete table rows and columns - Microsoft Support
How to add rows and columns for more data, or delete cells you no longer need.