Microsoft Excel 2007: Intermediate

Request info

Course duration: 1 Day

Certification

Microsoft Certified Application Specialist: Excel 2007

Course Description

In Microsoft Excel 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Objective

You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Audience

The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Certified Application Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Prerequisites

Before starting this course, students are recommended to take the following course or possess equivalent knowledge: Microsoft Excel 2007: Level 1.

Delivery Method

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification

This course is one of a series of courses that addresses Microsoft Certified Application Specialist skill sets. The Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Application Specialist certification.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:
Enhance the workbook.
Automate workbook creation by using templates.
Organise data using tables.
Create and modify charts.
Analyse data using PivotTables and PivotCharts.
Work with graphic objects.
Calculate with advanced formulas.
Sort and filter data.

Course Content

Using multiple worksheets and workbooks
Using multiple workbooks
Linking worksheets with 3-D formulas
Linking workbooks
Managing workbooks

Advanced formatting
Using special number formats
Using functions to format text
Working with styles
Working with themes
Other advanced formatting

Outlining and subtotals
Outlining and consolidating data
Creating subtotals

Cell and range names
Creating and using names
Managing names

Lists and tables
Examining lists
Sorting and filtering lists
Advanced filtering
Working with tables

Web and Internet features
Saving workbooks as Web pages
Using hyperlinks
Distributing workbooks

Advanced charting
Chart formatting options
Combination charts
Graphic elements

Documenting and auditing
Auditing features
Comments in cells and workbooks
Protection
Workgroup collaboration

Templates and settings
Application settings
Built-in templates
Creating and managing templates

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-13' ) ) 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 (104) 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