Microsoft Excel

Internal

• Windows
• Quip

Subjects

• General Functions in Excel
• Time and Date Functions in Excel
• Conditional Sum in Excel
• Counting Cells in Excel
• Financial Functions in Excel
• Get a Column Value Corresponding to a Value Match in Another Column
• Python Support in Excel
• Last Non-Empty Cell in a Column in Excel
• nth Root of a Number in Excel

Operations

Freeze Rows

Select a cell below the rows and to the right of the columns you want to freeze. Then go to View → Freeze Panes → Freeze Panes.

Link to a Specific Tab and Cell in Another Excel Document

Ctrl -K → Web Page or File → Navigate to the Excel file and use its name in the Address field → Append #'Tab name even if includes spaces'!Cell.

Example:

Investments.xlsx#'FENY (M)'!A1