JCD Consulting, Inc.

  XING Community     Company Profile   Anuncios Inteligentes

Microsoft Excel

 

Course Objectives:

. Create a basic worksheet.

. Modify a worksheet.

. Perform calculations.

. Format a worksheet.

. Develop a workbook.

. Print the contents of a workbook.

. Customize the layout of the Excel window.

. Create and apply templates.

. Create and modify charts.

. Work with graphic objects.

. Calculate with advanced formulas.

. sort and filter data.

. Use Excel with the Web.

. Customize workbooks.

. Collaborate with others using workbooks.

. Audit worksheets.

. Analyze data.

. Work with multiple workbooks.

. Import and export data.

. Structure workbooks with XML.

Microsoft Access

Course Objectives:

. Examine the Microsoft? Office Access 2003 database application.

. Manage the data in a database.

. Examine existing table relationships.

. Query the database.

. Design simple forms.

. Create and modify Access reports.

. Follow the steps required to properly design a simple database.

. Create a new database with related tables.

. Control data entry by modifying the design of a table to streamline   data entry and maintain data integrity.

. Find and retrieve desired data by using filters and joins between tables   and within a single table.

. Create flexible queries to display specified records; allow for   user-determined query criteria; and add, update, and delete data with   queries.

. Enhance the appearance, data entry, and data access capabilities of   your forms.

. Customize reports to better organize the displayed information and   produce specific print layouts such as mailing labels.

. Use Access data in other applications, including Microsoft Word and Excel.

. Restructure an existing set of data to improve the design of a database.

. Use a variety of techniques to summarize and present data with queries.

. Create and revise basic Access macros.

. Create macros that improve data entry efficiency and integrity.

. Improve the effectiveness of data entry in forms.

. Improve the effectiveness of data displayed in reports.

. Maintain an Access database by using various utility tools.

Microsoft Word

 

Course Objectives:

. Create a basic document.

. Edit documents by locating and modifying text.

. Format text.

. Format paragraphs.

. Use Word tools to make your documents more accurate.

. Add tables to a document.

. Add graphic elements to a document.

. Control a document's page setup and its overall appearance.

. Manage data in lists.

. Customize tables and charts.

. Customize formatting.

. Work with custom styles.

. Modify pictures in a document.

. Create customized graphic elements.

. Control text flow.

. Automate common tasks.

. automate document creation.

. Perform mail merges.

Microsoft PowerPoint

 

Course Objectives:

. Manipulate an existing PowerPoint presentation.

. Begin creating a presentation.

. Format text slides.

. Add tables to a presentation.

. Chart data in a presentation.

. Modify objects on slides.

. Add images to a presentation.

. Prepare to deliver a presentation.

. Create a design template.

. Create organization charts and diagrams.

. Add special effects to a Microsoft? Office PowerPoint?   2003 slide.

. Create a Web-based Microsoft? Office PowerPoint?   2003 presentation.

. Use a Microsoft? Office PowerPoint? 2003 presentation   for collaborative workgroup review.

. Use functionality that will enable you to deliver live,   self-service, and online presentations.

 

Crystal Report

 

Course Objectives:

. You will build basic list and group reports that work with almost any database.

. Create a report by using data from an existing database.

. Locate and present data in a specified order.

. Build formulas to add non-database data to a report and display data differently.

. Format reports.

. Enhance reports by adding and modifying elements in a report.

. Create single data series charts.

. Distribute report data to other users.

. create running totals in a report.

. build cross-tabs in your report.

. add subreports to a report.

. design a report that uses a drill-down.

. improve processing speed in your reports.

. chart single and multiple data series.

. report from Excel data.

[ Home ] [ QuickBook Pro ] [ ASP.NET ] [ Internet ] [ Computer  Fund. ] [ Windows XP Pro ] [ Word ] [ Excel ] [ PowerPoint ] [ FrontPage 2003 ] [ OutLook 2003 ] [ Access ] [ MOUS ] [ Data Analysis ] [ Autoestima ] [ Vista - Office 2007 ] [ OTHERS ]

Send mail to carballox@comcast.net with questions or comments about this web site.
Copyright © 2007 JCD Consulting, Inc.
Last modified: 02/04/09