Instructor Led Data Entry Training Classes

Dive Into Microsoft Excel Spreadsheets and Workbooks Keeping track of sales figures, statistics or mortgage payments has never been easier, or more difficult. Microsoft Excel gives you the power to develop formulas using built-in functions, Use charts and graphs to predict trends and understand relationships, Consolidate data from several worksheets into one, Find and organize information by filtering, sorting, and grouping, Summarize and analyze  more...

Microsoft Excel Advanced ...ist data; and use data forms and validation to facilitate data entry in lists; and use data tables to project values. Create and use PivotTables to analyse and compare large amounts of data. Import data from and export data to external databases. Use Goal Seek and Solver to perform what-if analysis; and use custom scenarios, advance custom views and pivot tables to manage large worksheets. Run  more...

Excel VBA Training ...ting user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.   What you will learn To work with Object Properties and Methods Attach code to events and buttons Using Variables, Procedures and Functions in VBA Control Structures to execute code Add User Forms and Controls Validate User entries  more...

Project Management Using Microsoft Project 2003 ...es, Filters, Groups and Reports that will both facilitate data entry and enhance their report generation and presentation capability. The student materials will contain examples of Microsoft Project screens as well as explanatory material and directions for completing the exercises. These materials are also designed to serve as both a reference and a self paced tutorial for the student after  more...

Access 2003 Level II ...e. 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  more...

Access 2003 Level III ... 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. What you will learn: Lesson 1: Structuring Existing Data Topic 1A: Import Data Topic 1B: Analyze Tables Topic 1C: Create  more...

Access PowerUser Level Your training in and use of Access has provided you with a solid foundation in the basic and intermediate skills for working in Access. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities. You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks,  more...

Access Expert Level ...with other applications, modify a table design to control data entry, find data with filters and queries, customize forms and reports, and create data access pages. Upon successful completion of this course, students will be able to: modify the design of a table to streamline data entry and maintain data integrity. use a filter to show you records in a datasheet or a form that match  more...