Introductory Microsoft Excel Short Course

This Microsoft Excel Short Course trains participants in the basic concept of spreadsheets. Participants will understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet. Microsoft Excel 2013 will be used in this short course.

1. Introduction to Spreadsheets

2. Starting Excel

3. Exploring the Parts of the Workbook

4. Opening an Existing Workbook

5. Saving a Workbook

6. Moving the Active Cell in a Worksheet

7. Selecting a Group of Cells

8. Entering Data in a Cell

9. Changing Data in a Cell

10. Searching for Data

11. Zooming a Worksheet

12. Previewing and Printing a Worksheet

13. Closing a Workbook and Exiting Excel

14. Resizing Columns and Rows

15. Positioning Data Within a Cell

16. Changing the Appearance of Cells

17. Using Styles to Format Cells

18. Copying and Moving Cells

19. Inserting and Deleting Rows, Columns and Cells

20. Freezing Panes in a Worksheet

21. Splitting a Worksheet Window

22. Checking Spelling in a Worksheet

23. Preparing a Worksheet for Printing

24. Inserting Headers and Footers

Course Objectives

On completion of this course, the participant will have the basic knowledge and application skills in using a spreadsheet application.

Note: Participants can proceed to learn the full Microsoft Excel Training Course that offers opportunities to be placed in office admin jobs upon successful completion of the full course.

Who Should Attend This Course

This course is intended for participants with little or no knowledge of using a spreadsheet application.

Pre-requisite

The participant must be able to:

• operate a Personal Computer, use keyboard and mouse
• read, write, speak and understand the English language. An understanding of Microsoft Windows / Excel 2007/2010 will be an added advantage.