Our Training Courses
Course Subjects
Web Design
DTP / Graphics
Microsoft Office
Software Testing
Project Management
Financial Training
Internet Marketing
Commercial Training
Tutor Bios
Resources
Student Area
Articles
 

Contact Us

Need Help

  
Microsoft Excel: Introduction (Level 1)   

Microsoft Excel 2003 is the popular spreadsheet from Microsoft and part of the Microsoft Office XP suite. This training course is designed to let users get to grips with the main features of Microsoft Excel. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.
Scheduled Course Dates and Prices

Duration: 1 Day

Public Course Price: £99
1-to-1 price: £199

Scheduled Dates: spacer TBC

If you can't come to us we can come to you! All courses are available as individual 1:1 tuition or small groups at your office as well as at our centre. Please click here for more information.

Who Should Attend  

New or intending users of Microsoft Excel 2003 who wish to gain a good understanding of the software.

Prerequisites 

Because of the amount of material we cover in class, we do require students to be comfortable using a mouse, opening and saving files, and the general operations of computers. While we will make every reasonable effort to help, students with insufficient skills may be required to undertake a IT skills course as to not slow down the rest of the class.

Performance-Based objectives  

Course Outline

Introduction:
• Opening Excel 
• Exiting Excel 

Beginning Excel:
• The Standard Toolbar 
• The Formatting Toolbar 
• Working with Excel Menus 
• Exploring Task Panes 
• Excel Short-cut Keys 

The Basics of File Management:
• New Workbooks 
• How to Open Existing Workbooks 
• How to Save Workbooks 
• How to Close Workbooks 

Explore your Workbook:
• Switching Worksheets 
• The Active Cell 
• Selecting Cells 
• Exploring a Worksheet 
• The Zoom Feature 

Working with Excel:
• Columns, Rows, Cells, and Ranges 
• Creating Worksheet Labels 
• Entering and Deleting Data 
• Printing your Worksheet 

Basic Excel Features:
• What is AutoFill? 
• What is AutoSum? 
• What is AutoComplete? 
• Working with Basic Formulas 

Editing Tools:
• AutoCorrect 
• Spell Check 
• Find and Replace 
• Documenting a Worksheet with Comments 

Moving your Data:
• Dragging and Dropping Cells 
• How to Cut, Copy, and Paste Cells 
• How to Cut, Copy, and Paste Multiple Cells and Items 
• How to Use Paste Special 
• How to Insert and Delete Cells, Rows, and Columns 
• Undo, Redo, and Repeat 

Modifying Cells and Data:
• Changing the Size of Rows or Columns 
• Working with the Formatting Toolbar 
• Adjusting Cell Alignment 
• Rotating Text 
• Creating Custom Number and Date Formats 

Cell Formatting:
• Conditional Formatting 
• Cell Merging and AutoFit 
• Find and Replace Formatting 

Enhancing a Worksheet’s Appearance:
• Adding Patterns and Colours 
• Adding Borders 
• Adding Fill Effects 
• Working with Styles 

Modifying Excel’s Toolbars:
• Hiding Toolbars 
• Showing Toolbars 
• Moving Toolbars 
• Customizing Toolbars 

Working with Charts:
• Creating a Chart 
• Formatting a Chart 
• Manipulating a Chart 
• Changing the Type of Chart 
• Changing the Source Data 

Organizing your Workbook:
• Inserting and Removing Worksheets 
•  Renaming, Moving, and Colour-Coding Worksheets 
• How to Split and Freeze a Window 
• Using Multiple Workbooks

Formatting your Workbook:
• Headers and Footers 
• Inserting Page Numbers 
• Changing Margins and Orientation 
• Hiding Rows, Columns and Worksheets 

Printing a Workbook:
• Choosing a Print Area 
• Setting up Page Breaks 
• Choosing Paper Size and Changing Print Scale 

More Workbook Features:
• Linking Workbooks 
• Combining Worksheets 
• Protecting Worksheets 
• Templates 

Course Times
Class time is 10:00 a.m.- 4:30/5:00 p.m.
Breaks are scheduled throughout the day and lunch is typically scheduled between 1-2 pm. We provide you with Tea, Coffee, Biscuits and other refreshments on the house. We also have a fridge and a microwave available for you to store/warm up any food you wish to bring along for your lunch.

Related Courses

We recommend the following courses that relate to this class: Microsoft Excel Intermediate and Microsoft Access Introduction

Back to top

 

microsoft Excel Level 2 Training

Microsoft Word Training

Microsoft Access