Enquiry Form

Duration: 1 Day

MICROSOFT EXCEL 2007 INTERMEDIATE

Objectives

Upon successful completion of the course, delegates will have an understanding of and be able to use Excel for charting, and utilise essential features to enable them to create more complex worksheets and workbooks and advanced formatting.

Designed for

Existing users of Microsoft Excel 2007.

MODULE 1: MULTIPLE WORKSHEETS AND WORKBOOKS

• Using Multiple Worksheets
• Inserting New Worksheets
• Renaming Worksheets
• Deleting Worksheets
• Creating Multiple Views
• Freezing Panes
• Viewing And Arranging Multiple Worksheet Windows
• Navigating In Multiple Workbooks
• Selecting And Viewing Multiple Workbooks
• Creating And Opening A Workspace
• Managing Multiple Worksheets And Workbooks
• Selecting Multiple Worksheets
• Moving And Copying Data Between Worksheets
• Linking Data Between Worksheets
• Creating A 3-D Formula

MODULE 2: CHARTING

• Using Charts
• Creating A Chart
• Moving A Chart
• Resizing A Chart
• Changing The Layout And Style
• Labelling Chart Elements
• Formatting Chart Text
• Formatting Chart Elements
• Changing The Chart Type
• Showing Or Hiding Gridlines
• To Modify Chart Gridlines
• Customizing Axes
• Creating A Pie Chart
• Changing, Adding And Deleting A Chart's Source Data
• Moving A Chart To A Different Worksheet
• Saving A Chart Template
• Printing Charts

MODULE 3: ADVANCED FUNCTIONS

• Creating And Using Functions
• Using Built-In Functions
• Use Formula Autocomplete
• Working With Arguments: The Pmt Function
• Using Dates And Times
• Using Dates In Calculations
• Using Nested Functions
• Auditing Worksheets
• Identifying The Auditing Commands
• The Watch Window
• The Formula Evaluator
• Tracing And Correcting Worksheet Errors

MODULE 4: ADVANCED FORMATTING

• Using Comments In A Worksheet
• Reviewing, Showing, And Hiding Comments
• Deleting A Comment
• Applying Or Customising Document Themes
• Working With Cell Styles
• Using Format Painter
• Applying Table Styles
• Excel Tables
• Filtering Data Using Autofilter
• Creating Custom Filters
• Advanced Filtering
• Using Templates
• Creating A Template
• Editing A Template
• Verifying Your Work
• Using Autocorrect