Excel 2003 Advanced

Level

Excel 2003 Advanced

Focus on Training
Logo Focus on Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Focus on Training offers this product as a default in the following regions: N/A

Description

Anyone wishing to consolidate and expand their knowledge, to include some of the more complex functionality of Excel.
Anyone who would like 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.

To be able to perform more advanced calculations and functions, report on data using pivot tables and 'advanced' data analysis tools, record macros and integrate with other office applications.

Skills Gained
* Streamline Workflow using Macros.
* Collaborate with others using Workbooks.
* Audit Worksheets.
* Analyse Data.
* Work with Multiple Workbooks.
* Import and Export Data.
* …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Anyone wishing to consolidate and expand their knowledge, to include some of the more complex functionality of Excel.
Anyone who would like 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.

To be able to perform more advanced calculations and functions, report on data using pivot tables and 'advanced' data analysis tools, record macros and integrate with other office applications.

Skills Gained
* Streamline Workflow using Macros.
* Collaborate with others using Workbooks.
* Audit Worksheets.
* Analyse Data.
* Work with Multiple Workbooks.
* Import and Export Data.
* Structure Workbooks with XML.

Excel 2003 gives professionals and everyday users the powerful tools necessary for getting the most out of their data. This Advanced course is designed for delegates who are proficient in the basic use of Excel and now need to create advanced spreadsheets using a wider range of Excel tools and features.

Course Outline
Streamlining Workflow
Create a Macro. Edit a Macro. Customize Access to Excel Commands. Apply Conditional Formatting. Add Data Validation Criteria. Update a Workbook's Properties. Modify Excel's Default Settings.

Collaborating with Others
Protect Files. Share a Workbook. Set Revision Tracking. Review Tracked Revisions. Merge Workbooks. Adjust Macro Settings. Administer Digital Signatures.

Auditing Worksheets
Trace Cell Precedents. Trace Cell Dependents. Locate Errors in Formulas. Locate Invalid Data and Formulas. Watch and Evaluate Formulas. Group and Outline Data.

Analysing Data
Create a Trendline. Create Scenarios. Perform What-If Analysis. Develop a PivotChart© Report. Develop a PivotTable© Report. Perform Statistical Analysis with the Analysis ToolPak.

Working with Multiple Workbooks
Create a Workspace. Link Cells in Different Workbooks. Consolidate Data. Edit Links.
Importing and Exporting Data

Export to Microsoft Word. Import a Word Table. Import Text Files.
Structuring XML Workbooks

Develop XML Maps. Import, Add, and Export XML Data. Manage XML Workbooks. Apply XML View Options.

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.