MICROSOFT EXCEL

Course: MicroSoft Office Excel

(3 days)

Prerequisites: None.

Course Content

Improve the way you turn data into information using powerful tools to analyze, communicate, and share your results. Excel enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel can help you work better in teams, and help protect and control access to your work -- more than just spreadsheets.

• Take advantage of data wherever it exists
• Develop your own data solutions
• Analyze data better
• Customize functionality with enhanced smart tags
• Interact with business systems
• Work together better. Save Excel 2003 spreadsheets to shared workspaces

Course Outline

• Getting Started with Excel
• Modifying a Worksheet
• Performing Calculations
• Formatting a Worksheet
• Developing a Workbook
• Printing Workbook Contents
• Customizing Layout
• Creating and Applying Templates
• Creating and Modifying Charts
• Working with Graphic Objects
• Calculating with Advanced Formulas
• Sorting and Filtering Data
• Using Excel with the Web
• Streamlining Workflow
• Collaborating with Others
• Auditing Worksheets
• Analyzing Data
• Working with Multiple Workgroups
• Importing and Exporting Data
• Structuring XML Workbooks