PS Training Ltd

Printer-friendly document

Course Booking and enquiries: 01352 810443
enquiries@pstraining.co.uk

Prerequisites:
Attendees should be familiar with a PC and the Windows environment and posses basic keyboard skills.

Duration:
This course can be delivered as a full day course or as individual half day modules

Module 1 - Getting Started

• Starting up Excel & Basic uses of Worksheets
• The Excel Window, use of the Tabs & Ribbon
• The Microsoft Office button and Quick Access Toolbar
• Creating A New Workbook
• Entering, Editing and deleting data
• Using the Undo Feature
• Saving and Password Protecting Workbooks, using Save As and Save
• Sharing Spreadsheets with Previous versions of Microsoft Office
• Opening a Workbook
• Closing a Workbook
• Exiting Excel
• Using the different Workbook views
• Selecting Cells and Ranges of data
• Formatting the Workbook, including Changing Font/Font Size, Changing the Number Format, Alignment, Colours and Shading

Module 2 - Basic Skills

• Copy, Cut and Paste using Text between one or more Workbooks
• Entering Values as Text
• Moving Around the Worksheet
• Automatically inserting lists used on a regular basis, i.e. Jan, Feb, Mar using the AutoFill feature
• Sorting Data into Alphabetical or Numerical order
• Formatting Rows and Columns, including Sizing, Adding, Deleting and Hiding
• Inserting Cell Comments
• Inserting Symbols
• Naming Ranges to make worksheets easier to manipulate
• Using Find & Replace
• Printing and Print Preview
• Page Set-up including Headers and Footers, Page Orientation, Margins and Fit to Page
• Splitting and Freezing Cells
• Working with Multiple Workbooks
• Using the AutoSum feature to automatically add values