Microsoft Excel 2003 – Advanced Level 1

Request info

Course duration: 1 Day

Cost: £195 + VAT

Outline

The topics covered are listed below.

Section 1

Revision of Basic Excel Techniques

Section 2

Using Logical Functions
Using IF Functions
Using ISERROR Functions
Using Multiple IF statements
Using Conditional Formatting
Using And Or Functions

Section 3

Using the Date and Time
Creating Formula with dates

Section 4

Working with Multiple Sheets
Moving between Sheets
Selecting single and Multiple Sheets
Renaming, Copying & Moving Sheets
Inserting and Deleting Sheets
Linking to Other Sheets
Three Dimensional Referencing

Section 5

Pivot Tables
Create Pivot Tables
Using the Pivot Table Wizard
Updating a Pivot Table
Changing the Layout of Pivot Tables

Section 6

Round Function
Round to Two Decimal Places
Round to A Whole Number
Round to Whole Hundreds
Round Up to Next Whole Number
Round Down to Next Whole Number

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-07-24' ) ) 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 (722) 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