Excel 2007, Intermediate
You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2007 to manage, edit, and print data.
Audience
Before taking this course, students should be comfortable using a personal computer and Microsoft Windows XP. Students should have some experience using Microsoft Excel. Students will get the most out of this course if their goal is to become proficient in such tasks as consolidating data, using advanced chart formatting options, sorting and filtering lists, using special formatting options, using templates, using error tracing features, protecting worksheets, and linking worksheets and workbooks.
Students taking this course should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that students have completed the Excel 2007: Basic course or have equivalent experience.
Upon successful completion of this course, students will be able to:
- Link worksheets by using 3-D formulas; add Watch windows; create and manage links between workbooks; and create a workplace.
- Apply special and custom number formats; control the display of zero values; use functions to format text; create, apply and modify styles; apply and modify themes; merge and split cells; change the orientation of data in cells; transpose data; and add background color and a watermark.
- Create an outline and consolidate data; create subtotals in a list; and use multiple subtotal functions.
- Define and apply cell and range names; use names in formulas; and define and apply 3-D names.
- Sort lists by columns; filter lists base on complex criteria and copy filtered results to another range; create and format a table and add rows and columns; apply structures referencing; name tables; and create functions with [#This row].
- Save and publish a worksheet as a Web page; insert and edit hyperlinks; publish a worksheet as a PDF file, and send a worksheet as an e-mail attachment.
- Format data points; create combination charts and trendlines; and add and format graphic elements.
- Use auditing features; add comments to cells and workbooks; protect a worksheet or part of a worksheet; share, merge, and track changes in a workbook; find and remove hidden and personal data from a workbook; and mark a workbook as final.
- Change Excel’s default application settings; work with Excel templates; and create and manage templates.
- CertBlaster preparation and materials also included
- Unit 1: Using multiple worksheets and workbooks
- Unit 2: Advanced formatting
- Unit 3: Outlining and subtotals
- Unit 4: Cell and range names
- Unit 5: Lists and tables
- Unit 6: Web and Internet features
- Unit 7: Advanced charting
- Unit 8: Documenting and auditing
- Unit 9: Templates and settings
In order for a class to be successful, all students should share the same general level
of knowledge and experience. If a participant does not demonstrate these, the instructor will take
the necessary steps either to prepare the participant or place him/her in a more appropriate course.
This policy is intended to maintain the high level of quality control that you have come to expect.