Microsoft Excel Advanced

Microsoft Excel Advanced

About the course:
This course aims to develop participants' skills in spreadsheet techniques and terminology to an advanced level.

By the end of the course delegates will be able import and export data, use pivot tables and charts, audit and analyse worksheets, manage worksheets and customise Excel.

Course Content:
Using Templates

• Create and Edit Templates
• Create New Workbooks Based on User-defined Templates
• Modify Workbook Properties
• Change Default Templates and Modify Template Settings

Working with Ranges

• Create and Use Named Ranges in Formulas
• Use Lookup Functions
• Create and Modify List Ranges

Formatting Cells

• Create and Apply Custom Number Formats
• Apply Conditional Formatting
• Create and Modify List Ranges
• Importing and Exporting Data
• Import Data from Text Files
• Export Data to Other Applications
• Link to Web Page Data

Using PivotTables and PivotCharts

• Formatting Graphics
• Crop and Rotate Graphics
• Control Image Contrast and Brightness
• Scale and Resize Graphics
• Apply Formats to Data Series

Auditing and Analyzing Worksheets

• Explore Formula Auditing
• Trace Precedents and Dependents
• Locate Errors in Formulas
• Circle Invalid Data
• Evaluate a Nested Formula
• Watch all Cells with Formulas

Summarizing Data

• Group and Outline Structured Data
• Add Subtotals to Worksheets
• Create and Remove Custom Filters
• Use Database Functions
• Create Scenarios
• Use Solver

Managing Worksheets

• Consolidate Data from Several Worksheets
• Create Shared Workbooks
• Track Changes
• Merge Workbook Revisions
• Protect and Unprotect Cells and Worksheets
• Protect Workbooks

Customizing Excel

• Record Macros
• Run Macros
• Change Security Levels for Macros
• Understand Editing Macros
• Add and Remove Buttons from Toolbars
• Add Custom Menus
• Modify Default Font Settings
• Set the Default Number of Worksheets

Equipment Requirements:
All equipment will be supplied by City Business.

Assessment:
Due to the workshop nature of this one day course, there are no formal examinations or assessments.

Progression:
Delegates may wish to extend their knowledge by completing an ECDL qualification or improve their understanding other Microsoft Office packages.


Code : Time : Duration : Day : Tuition Fee : Admin Fee
B02173 001 09:30 - 16:30 27/10/2009 - 27/10/2009 Tuesday Fee Enquiry

B02173 003 09:30 - 16:30 03/06/2010 - 03/06/2010 Thursday Fee Enquiry