| Home > Calendar > Lesson 4 | |||||
|
Home | Course Info | Syllabus | Calendar | Assignments | Resources | Review | WebCT | FAQ Last Week's Lesson | Next Week's Lesson
In creating the Extreme Blading 2nd Quarter Sales worksheet and chart in Project 1 of your Excel book, you gained a broad knowledge of Excel. First, you were introduced to starting Excel. You learned about the Excel window and how to enter text and numbers to create a worksheet. You learned how to select a range and how to use the AutoSum button to sum numbers in a column or row. Using the fill handle, you learned how to copy a cell to adjacent cells. Once the worksheet is built, you learned how to change the font size of the title, bold the title, and center the title across a range using buttons on the Formatting toolbar. Using the steps and techniques presented in the project, you formatted the body of the worksheet using the AutoFormat command, and you used the Chart wizard to add a 3-D Column chart. After completing the worksheet, you saved the workbook on disk, printed the worksheet and chart, and then quit Excel. You learned how to start Excel by opening an Excel document, used the AutoCalculate area, and edited data in cells. Finally, you learned how to use the Excel Help system to answer your questions. In creating the Blue Chip 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. In creating the Awesome Intranets workbook, you learned how to work with large worksheets that extend beyond the window and how to use the fill handle to create a series. You learned to display hidden toolbars, dock a toolbar at the bottom of the screen, and hide an active toolbar. You learned about the difference between absolute cell references and relative cell references and how to use the IF function. You also learned 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 introduced you to using Excel to do what-if analysis by changing values in cells and goal seeking. Some of you had questions on assignment 6, 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. The most frequently made mistakes in Assignments 5 and 6 are:
We are going to work on Access this week. Microsoft Office 2003 Teacher and Student version does not come with Access. If you have Teacher and Student version and need Access, You can use the computer in the computer lab to work on your assignments. Please do not hesitate to call or email me if you have any questions.
After completing this lesson, you will be able to:
Home | Course Info | Syllabus | Calendar | Assignments | Resources | Review | WebCT | FAQ Last Week's Lesson | Next Week's Lesson
Last updated: 06/26/06 |
|||||
At the end of this lesson, you have learned:
To create a
database using design and datasheet views.
