Intermediate Microsoft Excel

This Course Covers:

Formulae and Functions

• Using Absolute Cell References
• ‘Insert’ Function
• The ‘Average’ Function
• ‘Minimum’ and ‘Maximum’ Functions
• ‘Count’ and ‘Count If’ Functions

Range Names

• Creating Range Names
• Using Range Names

Protection

• Protecting Your Work
• Customising Excel

Working with Sheets and Workbooks

• Adding, Renaming and Deleting a Worksheet
• Moving and Copying Worksheets
• Using More Than One Workbook
• Linking Sheets and Workbooks
• Importing From and Exporting To Word

Sorting and Filters

• Creating and Using Lists
• Sorting Cells
• Filters and AutoFilters

Advanced Formatting

• Changing Text Wrapping and Orientation
• Using AutoFormat and Format Painter
• Creating a Custom Format
• Using Page Break Preview

Moving and Copying

• Moving and Copying Data
• Paste Special

Changing the View

• Freezing Rows and Columns
• Hiding Workbooks, Sheets, Rows and Columns
• Using The Zoom Control
• Showing and Hiding Toolbars
• Shortcuts
• Using Undo and Redo
• Find and Replace Data on a Spreadsheet

Progression:
After successfully completing this course students should enrol on the Advanced Microsoft Excel course offered by Strathclyde Training Services.