Microsoft Excel Introductory Level Course

icon-it.png

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

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
  • 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 values

 

DURATION: One day

VENUE: Myrick House, Hendomen, Montgomery, Powys. SY15 6EZ

PLEASE NOTE THAT TRAINING COURSES CAN BE ARRANGED TO SUIT COMPANY OR INDIVIDUAL NEEDS AND CAN BE ARRANGED IN COMPANY IF REQUIRED

If you require further information please contact Sue Evans on 01686 668670 sevans@myrick.co.uk