Microsoft Excel Intermediate Level Course
1 Day Course
£90 per delegate - Member Company
£95 per delegate - Non Member Company
PREREQUISITES: Attendees should be familiar with a PC and the Windows environment and have basic keyboard skills.
Module 1 - Getting Started
Starting up Excel & Basic uses of Worksheets
The Excel Window, use of Menus and Toolbars
Creating A New Workbook
Saving and Password Protecting Workbooks, using Save As and Save
Opening a Workbook
Closing a Workbook
Exiting Excel
Entering, Editing and deleting data
Using the Undo Feature
Selecting Cells and Ranges of data
Formatting the Workbook, including Changing Font/Font Size, Changing the Number Format, Alignment, Colours and Shading
Automatically inserting lists used on a regular basis, i.e. Jan, Feb, Mar using the AutoFill feature
Copy, Cut and Paste using Text between one or more Workbooks
Naming Ranges to make worksheets easier to manipulate
Entering Values as Text
Inserting Cell Comments
Splitting and Freezing Cells
Using the AutoSum feature to automatically add value
Module 2 - Basic Skills
Formatting Rows and Columns, including Sizing, Adding, Deleting and Hiding
Moving Around the Worksheet
Sorting Data into Alphabetical or Numerical order
Printing and Print Preview
Page Set-up including Headers and Footers, Page Orientation, Margins and Fit to Page