Courses

Excel Essential Skills

= Scheduled class    = Guaranteed to run    = Fully booked

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.

About this Course

This course is designed to provide the fundamental concepts of creating spreadsheets with an emphasis on creating formulas and managing your spreadsheet.

Our aim is to provide the foundation for immediate spreadsheet use and future development. We will introduce many timesaving features using quick keys and short cuts.

Excel is a tool for generating spreadsheets, which makes tasks like storing and manipulating numeric data easy and efficient. In this course we cover the basic features such as:

• Changing the appearance of a spreadsheet.
• Creating simple formulae (calculations).
• Copying and moving text and formulae to save time.
• Working effectively with multiple worksheets within a workbook.
• Printing a spreadsheet.
• Creating charts to display your data in a more interesting and effective way.

It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review this Course Guide once you are back at your workplace.

This course in conjunction with Excel Timesaving Features covers the material examined in the MOS Excel Examination.

Prerequisites

It is essential that attendees are familiar with the Windows environment, as covered in our Windows Getting Started course and have a very good knowledge of file handling, as covered in our Windows Managing Files course.

At Course Completion

This course is designed to provide the fundamental concepts for using a spreadsheet application with an emphasis on creating formulas and managing your spreadsheet. It provides the foundation for immediate spreadsheet use and future development.

Course Outline

• The Excel Window
• Office 2013 Backstage
• Entering and Editing Data
• Navigating around the Workbook
• Using Find and Replace
• Working with Worksheets
• Selecting Ranges
• Using Formulae
• Using Functions
• Inserting & Deleting Rows & Columns
• Cut, Copy and Paste
• Using Drag and Drop, Fill and AutoFill
• Using Absolute References
• Sorting
• Changing the Worksheet Appearance
• Using Charts
• Page Layout View and Printing
• Distribution

 Print this page