[vip_students] Excel tutorials as requested
- From: "Edel Carey" <careyedel@xxxxxxxxxx>
- To: <vip_students@xxxxxxxxxxxxx>
- Date: Mon, 20 Aug 2007 20:06:20 +0100
Hi Petrina
Here are the tutorials. All sitting pretty in my very tidy filing system
waiting for my attention. If I could work through them as good as I can file
them I'd be very clever.
Hope you have a great holiday. Talk soon.
Edel..
--- Begin Message ---
- From: "Loretta Conaty" <conatyloretta@xxxxxxxxxx>
- To: <careyedel@xxxxxxxxxx>
- Date: Mon, 23 Apr 2007 08:57:06 +0100
_____
From: vip_students-bounce@xxxxxxxxxxxxx
[mailto:vip_students-bounce@xxxxxxxxxxxxx] On Behalf Of Lists
Sent: 09 March 2007 17:00
To: vip_students@xxxxxxxxxxxxx
Subject: [vip_students] Excel Tutorial: Lesson 4, reviewing the excel
window!
Hi All,
Ready for another couple of excel lessons?. Okay, go to your "start menu,
Programs menu" and down arrow till you come to Microsoft Excel then press
the enter key to open.
Topic: The Excel Program Window
Introduction. This topic describes the layout of the Excel program window
and defines the elements in the window. You will learn how to review the
Excel program window to find each of these elements.
You may find it helpful to review the program window when you open a program
that is new to you. Reviewing the window can help you learn what the program
can do and what commands are available.
Exercise Objective. In the following exercise, you will review the Excel
program window using the JAWS Cursor.
Exercise: Reviewing the Program Window
Complete the following thirteen steps to review the Excel program window.
Step 1: Press Insert-T to verify that Excel is the active program. JAWS
announces, "Title Equals Microsoft Excel - Book1."
Step 2: Press Insert-Minus route the JAWS Cursor to the PC Cursor.
Step 3: Press Page Up to move the JAWS Cursor to the top of the window.
Then, press Insert-Up Arrow. JAWS announces, "Microsoft Excel - Book1
Minimize Symbol Restore Symbol Close Symbol."
The focus is on the title bar.
The title bar is a horizontal bar appearing at the top edge of the program
window. The title bar lists the name of the active workbook. It also
contains the Minimize, Restore, and Close buttons. You can press Insert-T at
any time to read the workbook name in the title bar.
Minimize Button. When you activate the Minimize button, the program window
reduces to a button on the Taskbar. The Minimize button performs the same
function as the Minimize command on the Application Control menu.
Restore Button. The Restore button expands the program window to its
fullest possible size, or returns the window to its previous size after you
have maximized it. This button performs the same functions as the Restore
and Maximize commands on the Application Control menu.
Close Button. When you activate the program Close button, the program window
and Microsoft Excel program closes. The Close button performs the same
function as the Exit command on the File menu.
Step 4: Press the Down Arrow key to locate the menu bar. JAWS announces,
"Minimize Symbol Restore Symbol Close Symbol."
Step 5: Press the Down Arrow key. JAWS announces, "File Edit View
Insert Format Tools Data Window Help Type a question for help
Minimize Symbol Restore Symbol Close Symbol."
The focus is on the menu bar.
The menu bar appears below the title bar. The menu bar contains these menus:
File, Edit, View, Insert, Format, Tools, Data, Window, and Help. The Ask a
Question combo box and the document Minimize, Restore, and Close buttons
also appear on the menu bar.
Ask a Question Combo Box. You can use the Ask a Question combo box to obtain
information on the question or keyword you type in the combo box.
Minimize Button. When you activate the Minimize button on the menu bar, the
document window reduces to a button in the program window. The Minimize
button performs the same function as the Minimize command on the Document
Control menu.
Restore Button. The Restore button on the menu bar expands the document
window to its fullest possible size, or returns the window to its previous
size after you have maximized it. This button performs the same functions as
the Restore and Maximize commands on the Document Control menu.
Close Button. When you activate the program Close button on the menu bar,
the active workbook closes. The Close button performs the same function as
the Close command on the File menu.
Note: "left alt + f4" is also a close command.
Step 6: Press the Down Arrow key. JAWS reads all of the buttons on the
Standard toolbar.
The Standard toolbar appears below the menu bar. It contains buttons that
represent the most frequently used commands, such as open a file, print,
save, and cut and paste text. (You will learn how to review the Standard
toolbar with the selection cursor later in this lesson.)
Step 7: Press the Down Arrow key. JAWS reads all of the commands on the
Formatting toolbar.
The Formatting toolbar appears below the Standard toolbar. It contains
buttons that represent the most frequently used formatting commands, such as
font settings, bold, justification, and indent. (You will learn how to
review the Formatting toolbar with the selection cursor later in this
lesson.)
Step 8: Press the Down Arrow key. JAWS announces, "A1 Scroll Down
Symbol."
The focus is on the Name combo box on the Formula Bar.
The Formula Bar contains the Name combo box, Insert Function button, and an
edit field. The Name combo box lists the active cell's name or reference.
The edit field lists the contents of the active cell.
The document window appears below the Formula Bar. The document window
displays a single workbook. When you first open Excel, a new workbook opens
to a blank worksheet. The worksheet includes column and row heading bars,
cells, gridlines, and sheet tabs.
The Task Pane also appears to the right of the document window. The Task
Pane lists commands related to the current function. You will learn more
about the Task Pane later in this lesson.
Step 9: Press the Down Arrow key. JAWS announces, "A B C D E F G H I J K L
New Workbook."
The focus is on the line displaying the Column Heading Bar and the top of
the Task Pane.
The Column Heading Bar marks the top of the workbook in the document window.
It displays a column reference at the top of each column. Column references
run A through Z, then AA through AZ, BA through BZ, and continuing to IA
through IZ. The column reference is the first coordinate in a cell
reference.
The title "New Workbook" appears at the top of the Task Pane, indicating
commands related to creating a new workbook appear in the Task Pane.
Step 10: Press the Down Arrow key to locate the first row reference on the
Row Heading Bar. JAWS announces, "1." (Currently, 23 rows are displayed.)
The Row Heading Bar is a vertical bar that appears along the left side of
the workbook. It lists the row reference at the beginning of each row. The
row references number 1 through 65,536. The row reference is the second
coordinate in a cell reference.
Currently the worksheet grid for the first worksheet in the workbook is
displayed. The worksheet grid consists of row and column gridlines and
cells.
Below the worksheet grid are three Sheet Tabs.
Step 11: Press the Down Arrow key until JAWS announces, "Sheet1 Sheet2
Sheet3 Scroll Left Symbol Scroll Right Symbol." (As you press the Down
Arrow key JAWS will read the row reference numbers currently displayed and
the commands in the Task Pane.)
The Sheet Tabs list the name of each worksheet in the workbook. By default,
worksheets are named Sheet1, Sheet2, Sheet3, etc.
Step 12: Press the Down Arrow key to locate the status bar. JAWS
announces, "Ready."
The status bar provides information about some selected commands or
information about an operation in progress. The right side of the status bar
indicates whether keys such as the Caps Lock, Scroll Lock, or Num Lock are
active. When you are not performing a task, the status bar lists "Ready"
indicating you can enter new data or execute a command. To read the status
bar, press Insert-Page Down.
Step 13: When you are finished reviewing the window, press the Plus key to
activate the PC cursor.
What You Learned. In this topic, you learned:
You can review the Excel program window using the JAWS Cursor and the Up and
Down Arrow keys.
The Excel program window contains the following elements:
Title Bar
Program Resize and Close Buttons
Menu Bar
Document Resize and Close Buttons
Standard Toolbar
Formatting Toolbar
Formula Bar
Task Pane
Document Window that displays the workbook's Column Heading Bar, Row Heading
Bar, Worksheet Grid, and Sheet Tabs
Status Bar
You can press Insert-T to read the title bar. To read the status bar, press
Insert-Page Down.
(End of lesson)
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.463 / Virus Database: 269.5.7/771 - Release Date: 21/04/2007 11:56
--- End Message ---
--- Begin Message ---
- From: "Loretta Conaty" <conatyloretta@xxxxxxxxxx>
- To: <careyedel@xxxxxxxxxx>
- Date: Mon, 23 Apr 2007 08:57:21 +0100
_____
From: vip_students-bounce@xxxxxxxxxxxxx
[mailto:vip_students-bounce@xxxxxxxxxxxxx] On Behalf Of Lists
Sent: 09 March 2007 17:03
To: vip_students@xxxxxxxxxxxxx
Subject: [vip_students] Excel Tutorials: Lesson 5, Reviewing the toolbar!
Topic: Using Toolbars
Introduction. Excel uses buttons and combo boxes on toolbars to give you an
easy way to access frequently used commands. Most commands on the toolbars
are also found on the menus. However, commands that appear on special
feature toolbars, such as the Chart and Reviewing toolbars, do not appear on
the menus.
Excel has numerous toolbars. Each toolbar has buttons that represent
commands related to a specific feature. The number of toolbars that appear
on the screen depends on the feature you are using or the task you are
performing. For example, the Chart toolbar appears when you are working with
charts. When you are finished with a particular feature or task, the
corresponding toolbar closes. The Standard and Formatting toolbars always
appear on the screen by default.
The Toolbars command appears on the View menu. The Toolbars sub-menu lists
all of the Excel toolbars. Checked toolbars appear on the screen; unchecked
toolbars do not.
You can use keystrokes to work with the buttons and combo boxes on the
toolbars.
Exercise Objective. In the following exercise, you will review the buttons
and combo boxes on the Standard and Formatting toolbars.
Exercise: Reviewing the Standard and Formatting Toolbars
Complete the following six steps to review the buttons and combo boxes on
the Standard and Formatting toolbars.
Step 1: Press Alt to move the focus to the menu bar. JAWS announces, "Menu
File."
Step 2: Move the focus to the Standard toolbar by pressing Ctrl-Tab until
JAWS announces, "New Button."
You have selected the first button on the Standard toolbar.
Step 3: Press the Right Arrow key repeatedly to review each item on the
Standard toolbar.
The Standard toolbar contains the following buttons: New Document Button,
Open, Save, Mail Recipient (if e-mail is available), Search, Print, Print
Preview, Spelling, Cut, Copy, Paste, Format Painter, Undo, Redo, Insert
Hyperlink, AutoSum, Sort Ascending, Sort Descending, Chart Wizard, Drawing,
Zoom, Help and Toolbar Options.
To activate any of the buttons on the toolbar, select the appropriate
button. Then, use the Enter key.
Step 4: Press Ctrl-Tab to move the focus to the Formatting toolbar. JAWS
announces, "Font: Combo Box," followed by the active font for the active
workbook.
Step 5: Press the Right Arrow key repeatedly to review each item on the
Formatting toolbar.
The Formatting toolbar contains the following buttons and combo boxes: Font,
Font Size, Bold, Italic, Underline, Align Left, Center, Align Right, Merge
and Center, Currency, Percent, Comma, Increase Decimal, Decrease Decimal,
Decrease Indent, Increase Indent, Borders, Highlight, Font Color, and
Toolbar Options.
Step 6: Press Alt to move the focus off the Formatting toolbar.
The focus returns to the worksheet. JAWS announces, "Leaving Menu Bar Blank
A1."
What You Learned. In this topic, you learned:
Excel uses several types of toolbars to display frequently used commands or
commands related to a specific feature.
The Toolbars command appears on the View menu. The Toolbars sub-menu lists
all of the Excel toolbars. Checked toolbars appear on the screen; unchecked
toolbars do not.
If you want to use a button on a toolbar, press Alt to move the focus to the
menu bar. Press Ctrl-Tab until JAWS reads the first button on the
appropriate toolbar. Then, press the Left or Right Arrow key until JAWS
reads the button you want to activate. Finally, press Enter to activate the
selected button.
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.463 / Virus Database: 269.5.7/771 - Release Date: 21/04/2007 11:56
--- End Message ---
--- Begin Message ---
- From: "Loretta Conaty" <conatyloretta@xxxxxxxxxx>
- To: <careyedel@xxxxxxxxxx>
- Date: Mon, 23 Apr 2007 08:57:31 +0100
_____
From: vip_students-bounce@xxxxxxxxxxxxx
[mailto:vip_students-bounce@xxxxxxxxxxxxx] On Behalf Of Lists
Sent: 11 March 2007 12:52
To: vip_students@xxxxxxxxxxxxx
Subject: [vip_students] Excel Tutorial: Lesson 6, The Task Pain!
Topic: About the Task Pane
Introduction. The Task Pane is a new feature in Excel 2002 or later . The
Task Pane displays commands related to frequently used features. The
contents of the Task Pane change, depending on the task you are performing.
For instance, commands related to opening a workbook appear in the Task Pane
when you open Excel.
The Task Pane appears next to the document window. You can move the focus to
the Task Pane by pressing the Alt key and then Ctrl-Tab. Once in the Task
Pane you can select commands by pressing Tab or the Arrow keys.
Exercise Objective. In the following exercise, you will review the contents
of the Task Pane.
Exercise: Reviewing the Task Pane
Complete the following five steps to review the contents of the Task Pane.
Step 1: Press Insert-T to verify Excel is the active program. JAWS
announces, "Title Equals Microsoft Excel - Book1."
Step 2: Press the Alt key to move the focus to the menu bar. JAWS
announces, "Menu Bar File."
Step 3: Move to the Task Pane by pressing Ctrl-Tab until JAWS announces,
"Task Pane New Workbook Blank Workbook Link."
Step 4: Press Tab or the Down Arrow key repeatedly to review the commands
in the Task Pane.
Currently, the commands in the Task Pane relate to creating a new workbook
or opening an existing workbook.
Step 5: Press Escape to return the focus to the worksheet. JAWS announces,
"Leaving Task Pane Blank A1."
Hiding the Task Pane. If you are no longer using the Task Pane, you can
hide it by unchecking the Task Pane command on the View menu. The Task Pane
will remain hidden until you choose another feature that displays a command
in the Task Pane or until you exit the Excel program.
What You Learned. In this topic, you learned:
The Task Pane displays tasks related to frequently used features. The
contents of the Task Pane change, depending on the task you are performing.
The Task Pane replaces many dialog boxes that were used in previous versions
of Excel.
The Task Pane appears next to the document window.
You can move the focus to the Task Pane by pressing the Alt key and then
Ctrl-Tab. Once in the Task Pane you can select commands by pressing Tab or
the Arrow keys.
If you are no longer using the Task Pane, you can hide it by unchecking the
Task Pane command on the View menu.
Topic: About the Adjust JAWS Verbosity Dialog Box
Introduction. You can use the Adjust JAWS Verbosity dialog box to change
settings that affect the amount and type of information that JAWS reads.
When you open this dialog box from the Excel program, it will contain
settings you can adjust for the Excel program. For instance, you can change
the amount of information that JAWS reads for the selected cell. By
default, JAWS reads the cell's coordinates and content when you select it.
You can change this setting so that JAWS only reads the cell's contents.
JAWS will save the changes you make to the verbosity settings. It will
continue to use the verbosity settings you chose until you make another
change.
This tutorial uses the default settings in the Adjust JAWS Verbosity dialog
box. When you need to make a change, you will be directed to do so.
Exercise Objective. In the following exercise, you will open and review the
default settings in the Adjust JAWS Verbosity dialog box for the Microsoft
Excel program.
Exercise: Reviewing the Adjust JAWS Verbosity Dialog Box
Complete the following five steps to review the Adjust JAWS Verbosity dialog
box.
Step 1: Press Insert-T to verify Excel is the active program. JAWS
announces, "Title Equals Microsoft Excel - Book1."
Step 2: Press Insert-V to open the Adjust JAWS Verbosity dialog box. JAWS
announces, "List Box Cell Verbosity Contents plus Coordinates 1 of 25."
The focus is in the Adjust JAWS Verbosity list box.
This dialog box has a list box, Close button, and Execute button.
Step 3: Press Insert-Tab to read the current setting. JAWS announces, "List
Box Cell Verbosity Contents plus Coordinates 1 of 25."
Step 4: Press the Down Arrow key repeatedly to review the settings.
To change a setting, select the setting. Then, use the Spacebar or the
Execute button to cycle through the options. When you have selected the
setting you prefer, change another setting or activate the Close button.
Step 5: When you have finished reviewing the dialog box, press Tab until
the Close button is selected. Then, press Enter to activate the button.
JAWS accepts any changes you may have made and closes the dialog box. If
you made changes, JAWS will announce, "Application Settings Saved."
What You Learned. In this topic, you learned:
You can use the Adjust JAWS Verbosity dialog box to change settings that
affect the amount and type of information that JAWS reads.
When you open this dialog box from the Excel program, the Adjust JAWS
Verbosity dialog box will contain settings you can adjust for the Excel
program.
To open the Adjust JAWS Verbosity dialog box, press Insert-V.
To change a verbosity setting, select the setting. Then, use the Spacebar or
the Execute button to cycle through the options. When you have selected the
setting you prefer, change another setting or activate the Close button.
JAWS saves the verbosity settings you chose until you make another change.
Topic: Exiting Excel
Introduction. This topic explains how to exit Excel. If you made changes to
a workbook since the last time you saved it, a dialog box will prompt you to
save it before exiting Excel. To prevent mishaps, you should always save
your workbooks before you activate the Exit command. If you exit Excel
without saving your workbook, you will not be able to retrieve any changed
information in the workbook. If you created a new workbook and chose not to
save it, the workbook is not available for future use.
The Exit command appears on the File menu. This tutorial directs you to use
the keyboard shortcut Alt-F4 when exiting Excel.
Exercise Objective. In this exercise, you will exit Excel without saving
the
Book1 workbook.
Exercise: Exiting Excel
Complete the following two steps to exit Excel without saving Book1.
Step 1: Press Insert-T to verify Excel is the active program. JAWS
announces, "Title Equals Microsoft Excel - Book1."
Step 2: Press Alt-F4 to exit Excel.
When the Excel program closes, JAWS reads the current focus. Book1 has not
been saved.
What You Learned. In this topic, you learned:
You can press Alt-F4 to exit Excel.
If you made changes to a workbook since the last time you saved it, a
Microsoft Excel dialog box appears prompting you to save the workbook before
exiting Excel.
When the Excel program closes, JAWS reads the current focus.
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.463 / Virus Database: 269.5.7/771 - Release Date: 21/04/2007 11:56
--- End Message ---
--- Begin Message ---
- From: "Loretta Conaty" <conatyloretta@xxxxxxxxxx>
- To: <careyedel@xxxxxxxxxx>
- Date: Mon, 23 Apr 2007 08:57:41 +0100
-----Original Message-----
From: vip_students-bounce@xxxxxxxxxxxxx
[mailto:vip_students-bounce@xxxxxxxxxxxxx] On Behalf Of Lists
Sent: 19 March 2007 15:17
To: vip_students@xxxxxxxxxxxxx
Subject: [vip_students] Excel Tutorial: Lesson 7,Working with Worksheets
Introduction. This lesson provides you with information for getting started
working with Excel worksheets. In this lesson, you will learn how to
navigate through a worksheet, enter data, and check the cell reference. You
will also learn how to create a new workbook, and learn several methods for
saving workbooks and opening existing workbooks. Finally, you will close a
workbook without exiting Excel.
In This Lesson. This lesson contains exercises for the following topics:
Topic: About Worksheet and Workbook Design
Topic: Navigating Through and Reading Worksheet Data
Topic: Entering Data
Topic: Saving a Workbook
Topic: Closing a Workbook
Topic: Creating a New Workbook
Topic: Opening an Existing Workbook
Before You Begin. Before you begin this lesson, you should have Excel 2002
and 2003 and JAWS running.
Topic: About Workbook and Worksheet Design
Introduction. Before you begin recording your data, you should carefully
consider how your data should be organized. Think about the kind of data you
want to track. Can the data be divided into categories? Can one category of
data be further divided into sub-categories? Taking the time to organize
your data will ensure that your data analysis is accurate and you can
readily locate the information you need.
About Workbook Design. A workbook should be devoted to one category. For
instance, suppose you want to track product, client contact, and sales
information. In this scenario you should use three workbooks to track each
category of information. Remember, a workbook can have many worksheets. Use
the worksheets to hold sub-categories of information. In a workbook that
tracks products used in a spa, use one worksheet to track hair care
products, a worksheet for manicure products, and a worksheet for body care
products.
About Worksheet Design. The layout and formatting of data in a worksheet
can vary widely. Generally, however, the data in a worksheet is laid out
like data in a table. You should use text labels for the data to help the
reader understand the purpose of the worksheet data.
Usually, a descriptive text label for a row of data appears in one of the
first four columns in the row. Likewise, a text label for a column of data
appears in one of the first four rows of the column. However, text labels
can be placed anywhere on the worksheet.
About Regions. Regions are defined once you begin to enter data into a
worksheet. You learned that a single worksheet has 256 columns and 65,536
rows. This allows you to enter a lot of data on a single worksheet. Often, a
worksheet author will use blank rows and columns to visually divide
worksheets that contain lots of data, similar to using several tables in one
word processing document.
Excel refers to contiguous blocks of cells containing data surrounded by at
least one blank row and column as regions. If you have set JAWS's Regions
verbosity setting to Multiple JAWS will announce, "New Region," when you
move to a new region. (If the region has been assigned a name, JAWS will
read the region's name.)
What You Learned. In this topic, you learned:
Before you begin recording your data, you should carefully consider how your
data should be organized. Taking the time to organize your data will ensure
that your data analysis is accurate and you can readily locate the
information you need.
A workbook should be devoted to one category and each workbook's worksheet
should hold one sub-category of information.
The layout and formatting of data in a worksheet can vary widely. Generally,
however, the data in a worksheet is laid out like data in a table.
You should use text labels for the data to help the reader understand the
purpose of the worksheet data.
A descriptive text label for a row of data usually appears in one of the
first four columns in the row. Likewise, a text label for a column of data
appears in one of the first four rows of the column. However, text labels
can be placed anywhere on the worksheet.
Regions are defined once you begin to enter data into a worksheet. A region
is a contiguous block of cells containing data surrounded by at least one
blank row and column. (If you have set JAWS's Regions verbosity setting to
Multiple JAWS will announce, "New Region" when you move to a new region.)
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.463 / Virus Database: 269.5.7/771 - Release Date: 21/04/2007 11:56
--- End Message ---
Other related posts:
