Updating Results

MS Excel Intermediate

  • Non-Award

The MS Excel Intermediate one-day short course provides the skills and knowledge to be able to use and operate the software effectively..

Key details

Degree Type
Non-Award

About this course

The MS Excel Intermediate one-day short course provides the skills and knowledge to be able to use and operate the software effectively.

.

You will learn a range of techniques to work with worksheets and at the completion of this course you should be able to:

  • apply a variety of page setup techniques
  • apply borders to cells and ranges in a worksheet
  • understand and use formula cell referencing
  • use common worksheet functions and create more complex formulas and functions
  • create and use defined names in a workbook
  • apply a range of number formatting techniques to worksheet cells
  • apply conditional formatting to ranges in a worksheet
  • use goal seeking to determine the values required to reach a desired result
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart
  • sort data in a list in a worksheet
  • use the fill operations available to fill a data series
  • filter data in a table
  • understand points to consider to avoid problems in your worksheets

Improve your job prospects by completing the MS Excel Intermediate course today!

*Please note; Short Courses are non-accredited and result in a Certificate of Participation. A non-accredited training course does not count-towards a recognised qualification, but is specially designed to provide hands-on training in a new skill you can use in your personal or professional life, and is a great way to refresh your knowledge or give you a taste of a different industry.