Course Title Creating an Impact with Excel - Advanced
Level: Level 3
Code BS41

Overview of the Course

About the Programme

The course provides you with an insight to the more complex calculations within MS Excel 2010. You will also looking at working with external data, as well as using techniques to present and secure data within the document.

Training and support is delivered face to face by an experienced instructor.

During the course you will have the opportunity to work with professional financial type documents.

Who is it aimed at?

This course is designed for those who wish to advance their skills within MS Excel 2010 to deal with complex calculations, work with external financial data as well as manage document security.

Course content

At the end of the course you will be able to:

  • Perform complex calculations across multiple worksheets.
  • Use macros.
  • Deal with formula errors.
  • Import and Export Data.
  • Consolidate Data
  • What If Analysis
  • Use Sparklines and Trendlines

Secure the document.

Entry requirements

Completion of Level 2 is required, Basic keyboard and mouse skills. You should be able to navigate to folders and files on a computer running Windows 7.

 

 

Qualification

Certificate of Development

Details

Start Date(s) Day Time Cost Duration Subsidised? Location
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-03-2018 Wednesday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
14-06-2018 Thursday 18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre
18.15-20.15 £109 1 Session for 3 weeks False Bury Town Centre

More information about Creating an Impact with Excel - Advanced

Contact Us

We are here to help you.