Microsoft Excel - Intermediate

Description


This practical course allows the delegate to appreciate the full potential of Microsoft Excel. Participants will be encouraged to discuss their individual requirements relevant to their working environment.

What you will learn

By the end of the course the delegate should be able to:

 Use a Variety of Worksheet Views in Microsoft Excel
 Apply a Range of Advanced Formatting Techniques to Worksheet Cells
 Apply a Range of Advanced Editing Techniques to Worksheet Cells
 Create and Apply Formulas and Functions
 Create, Edit and Delete Cell Comments
 Create and Use Defined Names in a Workbook
 Link Workbooks Within Excel
 Use a Range of Elements and Features to Set Chart Parameters
 Select and Change the Format of Charts
 Protect Data in Worksheets and Workbooks
 Create, Edit and Delete Templates
 Print Using Advanced Techniques
 Create Custom Forms and Lists
 Filter Lists Using Auto, Custom and Advanced Filter Options
 Sort Using Multiple Column and Custom Sort Options
 Create, Construct and Operate a PivotChart
 Create and Work With Goal Seek, Solver and Scenarios

Further information

Appetite for Business
Provider:
Appetite for Business
Duration:
1 Day
Price:
POA
Availability:
Scheduled dates
Course type:
Classroom
Locations:
Aberdeen, Dundee, Edinburgh, Glasgow, Inverness, London, Perth

Contact Information

Appetite for Business

Davidson House, Innovation Park, Campus 1
Bridge of Don
Aberdeen
AB22 8GT

Credentials

Locations