Microsoft Office Series:
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 AudienceThe 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. |
PrerequisitesBefore
starting this course, students are recommended to take the following
IDM course or possess equivalent knowledge: Windows 2000: Introduction Windows XP: Introduction |
|
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 |