Microsoft Excel Advanced
Vocational qualification
In Southampton
Description
-
Type
Vocational qualification
-
Location
Southampton
-
Class hours
8h
This course aims to develop participants' skills in spreadsheet techniques and terminology to an advanced level.
Facilities
Location
Start date
Start date
About this course
Delegates should have knowledge of Windows 2000, XP or 2003 and be able to use a keyboard and mouse.
Reviews
Course programme
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
Microsoft Excel Advanced