Course Description

Delegates are introduced to more complicated formulae, including 'If' functions, and will be shown various time-saving features of Excel.

Suitable for

Those with some experience of designing spreadsheets.     

What experience you will need

Knowledge of basic formulae, ie addition, subtraction, percentages and the SUM
function.   

What the course will include

Hints & Tips
- AutoFill & Custom Lists
- Using the Go to Command
- Relative & Absolute Cell Addressing
- What is Relative Cell Addressing?
- What is Absolute Cell Addressing & when to use it

Working With Toolbars
- Customising the toolbars
- Creating your own toolbar
- Resetting toolbars

Using Protection
- Protect parts of the worksheet
- Removing protection
- Splitting a worksheet into Panes
- Freezing worksheet Titles
- Creating a split
- To remove split Panes

Working with Multiple Worksheets
- Creating worksheets, naming, moving between and deleting
- Moving and copying worksheets
- Naming cells and range names in calculations   

More on Formulae & Functions, eg 3D
- Using the ‘If’ function
- Using Dates and Time Function
- Linking cells in the same worksheet & to other worksheets

Charts
- Creating and inserting charts
- Using chart wizard to embed a chart
- Manipulating chart data
- Modifying the chart layout
- Previewing and printing charts

Custom Template
- Saving a spreadsheet with standard data

Outlining
- Group & Auto outline

Exercises to check Learning
      -      Formulas
      -      If’ Conditions
      -     Absolute
      -      Linking cells
 
CD Rom/Manual - Instructions on how to open the user manual

Next course - Monday 13th October

Course Duration  -   1 day

Course cost  -  £120

Follow on courses - Excel Advanced

Tags: excel, microsoft, office