Microsoft Office Series:

Microsoft Office Excel 2007 (Excel07)

 

In ExcelŽ 2007 Introduction, 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 Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

 

 

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 Office 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 IDM course or possess equivalent knowledge:
Excel 2007 Introduction.

Students should have completed the following courses or possess equivalent knowledge before starting this course:
Windows 2000: Introduction
Windows XP: Introduction

 

Module

Managing Spreadsheets using Microsoft excel 2007.

 

16 Hours

Rs. 5,000.00

 

Topics

 

Getting started

 Database concepts

 Exploring the Access environment

 Getting help

Using forms

 Creating forms

 Using Design view

 Sorting and filtering records

 

Advanced form design

 Adding unbound controls

 Adding Graphics

 Adding calculated values

 Adding combo boxes

 Advanced form types

Databases and tables

 Planning and designing databases

 Exploring tables

 Creating tables

Working with reports

 Reports

 Modifying and printing reports

Reports and printing

 Customized headers and footers

 Adding calculated values

 Printing

 Labels

Fields and records

 Changing the design of a table

 Finding and editing records

 Organizing records

Relational databases

 Database normalization

 Relating tables

 Implementing referential integrity

Charts

 Charts in forms

 Charts in reports

 

Data entry rules

 Setting field properties

 Working with input masks

 Setting validation rules

Related tables

 Lookup fields

 Modifying lookup fields

 Subdatasheets

PivotTables and PivotCharts

 PivotTables

 Modifying PivotTables

 PivotCharts

 PivotTable forms

Basic queries

 Creating and using queries

 Modifying query results and queries

 Performing operations in queries

Complex queries

 Joining tables in queries

 Calculated fields

 Summarizing and grouping values