Microsoft Excel
Level 2


Outcomes

Participants will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel 2000. Participants will learn how to represent data graphically and maintain and manage lists.
The combined content of the Excel 2000: Level 1 and Excel 2000: Level 2 courses satisfies the requirements for the Certified Microsoft Office User for Excel 2000 at the Proficient level.


Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Excel 2000 Level 1, 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



          Creating charts
          Creating a chart sheet
          Creating an embedded chart
          Comparing chart sheets with embedded charts

          Modifying charts

          Chart types
          Modifying embedded charts
          Adding and deleting chart items
          Moving and sizing chart items

          Formatting a chart

          Formatting chart text
          Formatting labels
          Formatting the chart
          Printing a chart sheet

          Adding graphic objects
          Formatting graphic objects
          Using graphic objects to enhance worksheets and charts

          Sorting data

          Single-level sorting
          Multiple-level sorting
          Sorting options
          Design considerations

          Filtering data

          Filtering a list
          Custom criteria
          Multiple-condition criteria
          Managing a filtered list

          Appendix

          Querying data



Performance-based objectives
  • Create charts that graphically represent worksheet data.
  • Modify charts.
  • Customize charts by applying formatting.
  • Enhance worksheets and charts by using the drawing tools to add graphic objects.
  • Sort information in a list by using the Data, Sort command.
  • Locate information quickly in a list that meets specified conditions by using the Advanced filter feature.



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