Intermediate Excel training

This course aims to give delegates a greater understanding of MS Excel.

On completion of the course delegates will have improved their skills in using Microsoft Excel . They will be able to:

• Manipulate worksheets
• Use templates
• Apply conditional formatting
• Use various functions, including logical and date/time functions
• Manage Excel tables
• Customise charts
• Use Excel in conjunction with other applications

The course is of one day’s duration.

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Familiarity with the Windows environment, and a basic knowledge of Excel.

• Revision of basic formulas
• Using absolute cell references

• Renaming worksheets
• Inserting worksheets
• Deleting worksheets
• Freezing row and/or column titles
• Splitting worksheet window into panes
• Hiding/unhiding rows and columns
• Grouping and ungrouping worksheets
• Copying data between worksheets
• Formatting multiple worksheets in one operation
• Entering a formula to link related worksheets

• Applying templates
• Editing templates
• Creating templates

• Applying number formats
• Creating conditional number formats
• Using conditional formatting
• Flash Fill

• The IF function
• Nested IF functions
• SUMIF, COUNTIF
• The TODAY function
• NOW function
• COUNT functions

• Creating an Excel list
• Editing an Excel list
• Creating an Excel table
• Sorting
• AutoFilter
• Filtering data
• Totalling and manipulating filtered data
• Grouping and outlining
• Creating subtotals
• Data validation

• Plotting non-contiguous data ranges
• Pie charts
• Adding new data to an existing chart
• Chart formatting techniques

• Paste special options
• Linking vs Embedding
• Linking data from other worksheets
• Linking data from other applications
• Exporting to other applications