Course Title Creating an Impact with Excel
Level: Other
Code BS40

Overview of the Course

About the Programme

The course provides you with the Basic, Intermediate and Advanced functions of MS Excel 2010. The Basic level will enable you to store, edit, manipulate, analyse and present numerical data within spreadsheets. Intermediate will provide you with an insight to the more advanced functions of MS Excel 2010, where you will present, organise, manipulate data within worksheets aswell as look at more advanced formulas to perform calculations across multiple worksheets. And Advanced provides you with an insight to the more complex calculations within MS Excel 2010. You will also look into 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 produce professional business documents, such as a sales report.

By booking onto this combined course candidates make a saving of £88 in comparison to booking onto each level separately.


Who is it aimed at?

This course is designed for those who wish to advance their skills with all aspects of MS Excel 2010 and 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 basic calculations within a single worksheet
  • Format and manage the content
  • Query data
  • Present data: Basic chart, Freeze cells, Insert pictures
  • Print the documents
  • Perform advanced calculations across multiple worksheets.
  • Use Conditional Formatting
  • Create Validation Rules
  • Produce Pivot Table
  • Apply Filters (slicers)
  • 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

Basic keyboard and mouse skills. You should be able to navigate to and save folders and files on a computer running Windows 7


Certificate of Development


Start Date(s) Day Time Cost Duration Subsidised? Location
03-05-2018 Thursday 18.15-20.15 £209 1 Session for 8 Weeks False Bury Town Centre

More information about Creating an Impact with Excel

Contact Us

We are here to help you.