Microsoft Excel Intermediate Training Course

Our one day Online Microsoft Excel Intermediate training course will provide slightly more advanced knowledge of the use and functions of Microsoft Excel.

Many of us need to use Microsoft Excel in our jobs to produce a range of spreadsheets to show a wide range of business data.

Our Microsoft Excel Intermediate Training Course is designed to provide those that attend with slightly more advanced knowledge of how to use this very much used software.

Those who attend this Microsoft Excel Intermediate Training Course will be able to:

• Produce multiple sheet workbooks
• Use logical functions
• Sort, filter and subtotal data in the spread sheet
• Create graphs and charts to show data

Naming Cell Ranges

• Naming individual and ranges of cells
• Amending and deleting ranges
• Using named ranges in formula's as a navigation aid

Conditional Functions

Using a range of conditional functions such as:

• IF
• SUMIF
• SUMIFS
• AVERAGE
• AVERAGEIFS
• COUNTIF
• COUNTIFS
• IFFEROR
• ISERROR

Conditional Formatting

• Data bars
• Colour Scales
• Icon Sets

Linking Sheets and Files

• Linking different Excel sheets and sheets in the same file
• Viewing different files on one screen
• Windows split and freeze panes
• Watch window

List Management

• Sorting and filtering data using a range of values
• Multi-column sort and filter
• Advanced filter
• Adding sub-totals
• Freeze Panes
• Group and Outline
• Data Form
• Format As Table Feature
• Data Consolidation

Auditing Formula Review

• Tracing precedents and dependents
• Go to special
• Watch window

Advanced Charts and Graphs

• Creating Chart Using Shortcut Keys
• Saving custom chart as a template and as default
• Applying Trendlines
• Formatting and Editing Series, Plot Area, Data Points Chart Area, legends, etc...
• Using Sparklines