Microsoft Excel 2003 – Advanced Level 2

Request info

Course duration: 1 Day

Cost: £195 + VAT

Overview

This course is aimed at users who have attended Microsoft Excel Fundamentals and Intermediate courses, or for users wishing to clarify existing knowledge using various methods and techniques.

The topics covered are listed below.

Section 1

Revision of Basic Excel Techniques

Section 2

Naming Ranges
Adding Cell Comments
Inserting Text Boxes
Protecting Sheets and Workbooks

Section 3

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

Section 4

Templates
Creating Templates
Editing Templates
Inserting Templates
Deleting Templates
Using Templates
Saving a Workspace File

Section 5

Macros
Recording Macros
Using Shortcut Keys and Buttons
Creating Toolbars
Assigning Macros to Menu Items
Assigning Macros to Toolbars

Section 6

Charting
Revising Chart Creation
Additional Chart Options

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2024-04-16' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN ( SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (721) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC