Microsoft Excel OFFSET Function and Dynamic Charting – Online Excel Training Course

Book this course

Course description

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?

If you’re an Excel user who regularly creates charts, this online Excel training course will enhance your current skill level and make your charting more efficient.

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

Excellent. The trainer was relaxed, assured and extremely knowledgeable. Probably the best external training I've had.  Would thoroughly recommend this training to others, it was superb!

Business Performance Manager, Scotia Gas Networks

What does it cover?

  • Syntax of the OFFSET function
  • Using OFFSET to create a dynamic range
  • Adding columns to charts only when data is added
  • Selecting data from a rolling period
  • Combining OFFSET with a scrollbar to display data

Book this course

Course leader

Richard Harker

L&D Consultant, IT Solutions

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Tweets
Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine