State ID:
K2049P
-- OR --
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!