Price protection. The price to attend Excel 2007 - Level 3
is set by the training provider. There is no added
charge for our services.
We honor most training
provider coupons*.
Call a representative to see if your discount coupon
applies.
Privacy. Your personal information
won't be shared with anyone but the training provider New Horizons.
Security. When you register for this
seminar on FindaSeminar.com your personal data and payment
information is safely collected and processed using secure SSL
encryption technology.
Flexibility. FindaSeminar.com offers
you three ways to register for Excel 2007 - Level 3
seminar by New Horizons. Register online, by
phone (800) 349-1935,or fax (800) 712-5569
Who should attend Excel 2007 - Level 3
This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, auditing and analyzing worksheet data, working with multiple workbooks, importing and exporting data, structuring XML workbooks, and using Excel with the web. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2007 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, auditing and analyzing worksheet data, working with multiple workbooks, importing and exporting data, structuring XML workbooks, and using Excel with the web. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2007 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. (see
full course description)
At Course Completion: Upon successful completion of this course, students will be able to: - increase productivity and improve efficiency by streamlining your workflow. - collaborate with others using workbooks. - audit worksheets. - analyze data. - work with multiple workbooks. - import and export data. - use Excel with the Web. - structure workbooks with XML.
Outline: Lesson 1: Streamlining Workflow Create a Macro Edit a Macro Apply Conditional Formatting Add Data Validation Criteria Update Workbook Properties Modify Excel´s Default Settings
Lesson 2: Collaborating with Others Protect Files Share a Workbook Set Revision Tracking Review Tracked Revisions Merge Workbooks Adjust Macro Settings Administer Digital Signatures Mark a Workbook as Final
Lesson 3: Auditing Worksheets Trace Cell Precedents Trace Cell Dependents Troubleshoot Errors in Formulas Troubleshoot Invalid Data and Formulas Watch and Evaluate Formulas Create a Data List Outline
Lesson 4: Analyzing Data Create a Trendline Create Scenarios Perform What-If Analysis Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks Create a Workspace Consolidate Data Link Cells in Different Workbooks Edit Links
Lesson 6: Importing and Exporting Data Export an Excel Worksheet to Microsoft Word Import a Word Table Import a Delimited Text File
Lesson 7: Using Excel with the Web Publish a Worksheet to the Web Import Data from the Web Create a Web Query
Lesson 8: Structuring XML Workbooks Develop XML Maps Import and Export XML Data Manage XML Workbooks
Registration Deadline: 3:00 PM CST day before scheduled class date
Seminar Summary:
In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. (see
full course description)