Subscribe
Tutorial search

Offset Function - Excel tutorial


The OFFSET function in Excel has a wide variety of capabilities. It can be thought of as similar to the VLOOKUP and HLOOKUP functions, but with additional flexibility.
Category: Excel > Functions - Difficulty:


More cool Excel tutorials:



Chart Printing
Chart Printing
Depends on the type of chart you've created. You can print embedded charts either with worksheet data or on their own. Standalone charts, which occupy separate worksheets, always print on separate pages.
Difficulty:
Track and Report Changes in Excel
Track and Report Changes in Excel
To overcome the limitations of the Track Changes feature, you can employ some help from Excel VBA and Excel's Change Events feature.
Difficulty:
Prevent Users from Performing Certain Actions
Prevent Users from Performing Certain Actions
You can manage user interactions with your spreadsheets by monitoring and responding to events. Events, as the term suggests, are actions that occur as you work with your workbooks and worksheets.
Difficulty:
Select a random sample of rows in Excel
Select a random sample of rows in Excel
Use the excel random number generator to get random sample data from a spreadsheet.
Difficulty:
Multiple Scenarios
Multiple Scenarios
The scenario feature allows you to quickly change a number of input cells based on some predefined situations e.g. Low case, High Case, Realistic Case. You can then switch between the various scenarios easily
Difficulty: