|
Home | Course
Info | Syllabus
| Calendar | Assignments
| Resources | Review |
WebCT
| FAQ Last Week's Lesson |
Next
Week's Lesson
| Week
11: At a Glance
|
|
What
We Did Last Week
In creating the Greenback Stock Club workbook, you learned
how to enter formulas, calculate an average, find the highest and lowest
numbers in a range, verify formulas using Range Finder, change fonts, draw
borders, format numbers, change column widths and row heights, and add
conditional formatting to a range of numbers.
You learned how to spell check a worksheet, preview a
worksheet, print a worksheet, print a section of a worksheet, and display
and print the formulas in the worksheet using the Fit to option. You
also learned how to complete a Web query to generate a worksheet using
external data obtained from the World Wide Web and rename sheet
tabs. The tab color can also be changed and the order of the sheet
tabs can be rearranged. Finally, you learned how to send an e-mail directly from within
Excel with the opened workbook attached.
You
should have submitted all your assignments up to assignment 7. The most
frequently made mistakes in Assignment 7 are:
-
Merge and Center: To center cell contents
across a series of columns, you need to first highlight the columns
and then click on the Merge and Center button.
-
Fixed dollar sign and Floating dollar
sign: The Fixed dollar sign can be inserted by clicking on the
$ style button on the formatting bar. However, you have to use
the Format/Cells/Currency command from the menu bar to insert a Floating
dollar sign.
-
Select the nonadjacent cells: To include the
data label for the bar chart, the column labels and the corresponding
data should be selected. Hold down the Ctrl key you can select
multiple nonadjacent cells.
Some of you had questions on assignment 8, Laser Fast
Technology Seven-Year Financial Projection. To display the years in the 3-D Column
Chart, you have to format the numbers (years) to text. To change the
number to text, simply type a single quotation before the digits, for
example, '2006, '2007, '2008... '2012. Redo the chart using the chart
wizard and you will see years displayed under the chart.
Microsoft Office 2003 Teacher and Student version does not come with
Access. If you have Teacher and Student version and need Access, you can
pick up a copy of Microsoft Office 2003 Professional 30-day trial CD from
me. Make sure to finish all your work within 30 days before it expires.
Top of the Page
What
You Will Learn This Week
In creating the Awesome Intranets workbook, you will learn
how to work with large worksheets that extend beyond the window and how to
use the fill handle to create a series. You will learn to display hidden
toolbars, dock a toolbar at the bottom of the screen, and hide an active
toolbar. You will learn about the difference between absolute cell
references and relative cell references and how to use the IF function.
You also will learn how to rotate text in a cell, generate a series,
freeze titles, change the magnification of the worksheet, display
different parts of the worksheet through panes, create a 3-D pie chart,
and improve the appearance of a 3-D Pie chart. Finally, project 3 will
introduce you to using Excel to do what-if analysis by changing values in
cells and goal seeking.
The Web feature will introduce you to previewing a Web
page, creating a new folder on disk, and publishing and viewing two types
of Web pages: static and dynamic. Whereas the static Web page is a
snapshot of the workbook, a dynamic Web page adds functionality and
interactivity to the Web page. Beside changing the data and generating new
results with a dynamic Web page, you also can add formulas and change the
formats in your browser to improve the appearance of the Web page.
Top of
the Page
After completing this lesson, you
will be able to:
-
Perform what-if analysis,
charting, and work with large worksheets
- Rotate text in a cell
- Create a series of month names
- Use the Format Painter button of format cells
- Copy and paste
- Insert and delete cells
- Format numbers using format symbols
- Freeze Titles
- Display and Format the System Date
- Use absolute cell references in a formula
- Use the IF function to perform a logical test
- Copy absolute cell references
- Display and dock toolbars
- Add a drop shadow to a range of cells
- Create 3-D Pie chart on a separate chart sheet
- Color Worksheet tabs
- Rearrange sheets in a workbook
- Preview and print multiple sheets
- Use the Zoom box to change the worksheet view
- View different parts of the worksheet through window panes
- Use Excel to answer what-if questions
- Goal seek
-
Create static and dynamic
Web pages
- Preview the workbook as a Web page
- Save an Excel chart as a dynamic Web page
- Save an Excel workbook as a static Web page to a newly created
folder
- View and manipulate the dynamic Web page ;using your browser
- View and manipulate the static Web page using your browser.
Top of the Page
Activities
for This Week
Email your completed assignment to your instructor at llemley@pjc.edu
as an attachment. Remember to type "Your Section #, Assignment 8,
Your Name" in the Subject.
Troubleshooting -
Pop-up
blocking software
The survey appears in a new browser window. If you have pop-up
blocking software installed on your computer, the survey may not appear.
To take the survey, you may have to disable the pop-up blocking
software.
Top of the Page
Conclusion
At the end of this lesson, you have learned:
 To
perform What-If analysis,
charting, and work with large worksheets
Assignments:
What we will do next
week: Microsoft Access 2003
Home | Course
Info | Syllabus
| Calendar | Assignments
| Resources | Review |
WebCT
| FAQ Last Week's Lesson |
Next
Week's Lesson
Last updated:
09/23/05
|
