Microsoft Excel 2003 Level 4Courses > Microsoft Office Training > Microsoft Office 2003 > Microsoft Excel 2003 Level 4

  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Declaration of views_handler_argument::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 917.
  • strict warning: Declaration of views_handler_argument::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 917.
  • strict warning: Declaration of views_handler_sort::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_sort::options_submit() should be compatible with views_handler::options_submit($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_sort::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_filter::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 587.
  • strict warning: Declaration of views_handler_filter::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 587.
  • strict warning: Declaration of views_handler_filter_node_status::operator_form() should be compatible with views_handler_filter::operator_form(&$form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/modules/node/views_handler_filter_node_status.inc on line 13.
  • strict warning: Declaration of views_plugin_argument_validate::options_submit() should be compatible with views_plugin::options_submit($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/plugins/views_plugin_argument_validate.inc on line 87.
  • strict warning: Declaration of views_plugin_argument_validate_taxonomy_term::options_submit() should be compatible with views_plugin_argument_validate::options_submit(&$form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/modules/taxonomy/views_plugin_argument_validate_taxonomy_term.inc on line 165.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
Duration: 
1 Day - £249
Course ID: 
n/a

This course is aimed at advanced users who have attended Microsoft Excel Level 1, 2 and 3, or for users wishing to clarify existing knowledge using various methods and techniques. This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

 

Microsoft Excel 2003 Level 4

 

 

Duration

 

1 day

 

 

Target Audience

 

This course is aimed at advanced users who have attended Microsoft Excel Level 1, 2 and 3, or for users wishing to clarify existing knowledge using various methods and techniques. This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

 

 

Course Objectives

 

Upon successful completion of this course, students will be able to:

·                Create Cell Comments and Text Boxes

·                Secure Sheets and Workbooks

·                Use the Advanced Features of Data Lists

·                Create, Edit, Insert, Delete and Save Templates

·                Create, Use and Assign Macros

·                Create Charts and Use Advanced Charting Features

 

 

Course Contents

 

Revision of Basic Excel Techniques

 

Naming Ranges

Adding Cell Comments

Inserting Text Boxes

Protecting Sheets and Workbooks

 

Working with Data Lists

What is a List?

Using a Form within a List

Sorting Data

Filtering Data in a List

Using an Advanced Filter

Summarising Data in a List

Sub Totals

 

Templates

Creating Templates

Editing Templates

Inserting Templates

Deleting Templates

Using Templates

Saving a Workspace File


Macros

Recording Macros

Using Shortcut Keys and Buttons

Creating Toolbars

Assigning Macros to Menu Items

Assigning Macros to Toolbars

 

VLook-Up and HLook -Up

Lookup Function

Horizontal Table Array

Row/Index Number - Horizontal

Vertical Table Array

Row/Index Number - Vertical

Range Lookup – Horizontal and Vertical

Insert Function Tool – Formula Bar

Multiple Lookup – Horizontal and Vertical

Lookup and the IF Statement

 

Data Validation

Data Validation

Data Validation – Field Types

Input Message - Data Validation

Error Alert - Data Validation

Find Cells with Data Validation

Data Validation - Lists

Data Validation – Paste Special

 

 

 

What did attendees think of the course?
 
"The instructor was excellent, one of the best courses I've attended" - C.K. Training Admin
 
"The trainer is very knowledgable and passes on the knowledge in an understandable way and a friendly manner.  Personal needs are taken into consideration - tailoring the course to user's needs and abilities.  An excellent trainer and I always look forward to these training sessions". - M.A. Product Support Investigations

Please call 0141 221 5676 for course information and available dates or email us at info@indiciatraining.com.

Please contact us and we will be happy to offer further assistance.