1. Training Room 1

INF2080

Project 3: Spreadsheet Skills

 

Training Room 1: Creating and Manipulating Data

 

A photograph shows a boy and girl at a computer.

© Dmitrijs Dmitrijevs/shutterstock

Much of the information contained in this training room will be review for you. You will be introduced to templates and management of your workbooks. You may discover alternate ways to perform tasks or learn shortcuts to speed up your work. Feel free to repeat the training rooms until you are comfortable with the skills covered. When you are comfortable with the skills in the training room, proceed to the Time to Practise exercise.

 

In this training room you will

  • review the help features in Microsoft Excel 2007
  • learn more about the fill handle
  • review formatting data
  • split and freeze panes
  • review hiding and unhiding worksheets in workbooks
  • review changing worksheets
  • review inserting, deleting, moving, and copying worksheets
  • create a workbook from a template
How to Do It

 

This course is unique in that you will be working in Microsoft Excel 2007 throughout all of the training rooms. To successfully complete this training room, do the following:

  • Read and watch instructional videos to discover some of the main features of Excel 2007.

  • Use help and online references whenever you require additional instruction or software assistance.

  • Complete the Time to Practise 1 exercise.
Key Features of Excel 2007

 

Study the Microsoft Excel 2007 screen to see how the user interface has changed and learn about some of the new features. Open Key Features of Excel 2007 to familiarize yourself with some of the features, functions, and buttons in Excel 2007.

 

Using Help Functions and Online References

 

Resourceful, adaptable, lifelong learners know where to look for information. There are several ways to find information about how to use your spreadsheet software. You can

  • use the built-in and online Help function
  • access online resources and demonstrations through the Internet

 

Watch the demonstration “Accessing Help in Excel 2007.”


Microsoft Online can be a wealth of information. Microsoft has developed a variety of how-to resources to support the users of Microsoft products. You can access training, demonstrations, webcasts, podcasts, and information on how to become Microsoft Office Certified. Microsoft Online can be a place where you go to refresh your memory or to learn a new skill.

 

 

Watch the demonstration “Accessing Microsoft Online” for more information.

 

From this point on, you will be doing the bulk of your work in training rooms. Each training room is set up in Microsoft Excel 2007 as a workbook. Once you have opened the training room, you will see a number of worksheet tabs at the bottom. Complete all readings and instructions contained within the worksheet before moving on to the next worksheet tab. Ensure that you have completed each worksheet tab and that you have saved your training room in your INF2080 SS2 folder before exiting the training room.

 

 

You are now ready to start working in Microsoft Excel 2007 to learn more of its features and use them effectively. Open Training Room 1: Creating and Manipulating Data, and follow the instructions, starting with the Help features.