Microsoft Excel
Level 3


Outcomes

Participants will learn how to work with advanced features of Excel 2000. Participants will learn various advanced techniques for analyzing and manipulating data in Excel.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Excel 2000 Level 1 and 2, or equivalent knowledge


What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session



          Customizing the work area
          Working with built-in toolbars
          Using custom toolbars
          Creating and using styles
          Using templates

          Advanced formula construction

          Using names
          Using the IF function
          Using the VLOOKUP function
          Using IS functions and the Auditing features

          Using pivot tables

          Creating pivot tables
          Modifying pivot tables
          Grouping and summarizing data in a pivot table

          Working with multiple worksheets

          Working with workbooks
          Linking cells in different workbooks
          Workbook versus links and workspaces
          Consolidating data from more than one worksheet
          Using the Goal Seek and Solver utilities
          Using Scenario Manager to view a worksheet with different input values

          Using protection and display options

          Using comments
          Protecting workbooks
          Using custom views

          Introduction to macros

          Running macros
          Recording a macro
          Viewing and editing VBA code

          Working with interactive Excel Web documents

          Saving Excel worksheets as Web documents
          Spreadsheet Web Components



Performance-based objectives
  • Customize toolbars and create styles and templates.
  • Create decision-making functions.
  • Analyze worksheet data by creating pivot tables.
  • Compare and contrast workbook files and file links.
  • Outline and consolidate worksheets and analyze worksheet data by using the Scenario Manager.
  • Display and protect worksheet data by locking cells.
  • Record and modify macros by using the Visual Basic Editor.
  • Create and work with interactive Web documents.



This course is not available on our public schedule, call us on 1800 456 002 or EMAIL to book this course


 
About our courses About Us Contact Us Education Outlines Schedule By Course© iTeam 2017