Excel 2003: Advanced

Learning Outcomes:

• Apply conditional formatting, add data validation criteria, customize menus and toolbars, create, edit, and run macros with 80% accuracy during course assignments.

• Given a list of procedures demonstrate ability to protect your worksheet/workbook and add and remove file passwords, share workbooks, set revision tracking, merge workbooks, and track changes with 100% proficiency.

• Demonstrate mastery during class exercises in the time allotted to apply the techniques presented to trace cell precedents and dependents, locate errors in formulas, locate invalid data and Formulas, group and outline data.

• Using the Analysis ToolPak, create a Trendline, Scenarios, perform What-If Analysis, develop a PivotTable Report/PivotChart Report during exercises with 80% accuracy.

During this one-day class, students will learn how to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

· Streamlining Workflow
· Applying Conditional Formatting
· Adding Data Validation Criteria
· Creating and Editing Macros
· Working with Multiple Workbooks
· Importing and Exporting Data
· Structuring XML Workbooks

Excel 2003: Advanced

Upon successful completion of this course, students will be able to: Apply conditional formatting, add data validation criteria, customize menus and toolbars, create, edit, and run macros. The student will also view data using the outline. Create a workspace, consolidate data, view the consolidated data and link cells. Protect your worksheet and workbook and add and remove file passwords, share workbooks, set revision tracking, merge workbooks, and track changes. Trace cell precedents and dependents, locate errors in formulas, locate invalid data and Formulas, group and outline data. Create a Trendline, Scenarios, perform What-If Analysis, Develop a PivotTable Report and PivotChart Report and Perform Statistical Analysis with the Analysis ToolPak.

Class targeted to:

Students who need to learn various advanced techniques for manipulating data and who are preparing for the Microsoft Office Specialist Exam.

Prerequisites:

Windows: Introduction, Excel 2003: Introduction and Excel 2003: Intermediate.