f you use Microsoft Excel to create charts, but you feel that they are a bit ‘static’ – perhaps you’d like your charts to automatically pick out data from the current year – the OFFSET function can be a valuable tool.
We show you all the basics of the OFFSET function, showing you how to create dynamic ranges and charts, and use the scrollbar to select data. Learners are encouraged to participate in the session by asking questions, and we’ll be here to give you support via telephone, email or Twitter for 90 days after the programme finishes.
Is it right for me?
What will I get out of it?
By the end of the course you will be able to:
- Use the OFFSET function
- Apply the OFFSET function to create dynamic ranges
- Create a chart that automatically adds columns as data is entered into your table
- Select a rolling 12-month period of data
- Use scrollbars to select displayed data