|
Training Services
|
|
Click Consulting, Inc. provides quality training for you and your staff in such skills as basic comouter skills, understanding your network environment, and using common office applications.
|
|
|
 |
On-site Training |
|
We provide in-house training on Microsoft Access and Excel. In addition to standard course material, we can customize the material for your company's needs and include a workshop where we review and work on your existing workbooks and databases. Let us provide training so your employees can tap into the power of these applications. This investment pays substantial dividends.
|
|
|
|
Workshop |
|
Workshop is a hands-on experience where attendees may bring in their own workbooks. We analyze the workbooks and make suggestions and answer questions one-on-one.
|
|
|
|
Reviews |
|
The instructor is a CPA and published author. The Journal of Accountancy has published his articles about Excel and Access. He has also taught for the Gateway Country stores, Biola University and the California CPA Education Foundation. We have received overwhelming feedback from our attendees. After understanding how to apply Excel/Access to their jobs, they are more efficient and productive. The response has been incredible, and below are just 2 reviews out of many satisfied attendees.
Rating scale is 1-5, where 1 is Poor and 5 is Excellent:
3/19/01 training session held for Gateway computer employees:
Course material: 5 "Excellent"
Instructor: 5 "Excellent"
Overall: 5 "Excellent"
Comments: "Very effective - thank you - I enjoyed your class."
5/10/01 training session held for RREEF employees:
Course material: 5 "Excellent"
Instructor: 5 "Excellent"
Overall: 5 "Excellent"
Comments: "Jeff really knew his stuff. I learned a lot."
|
|
|
|
Pricing |
|
On-site training (at your location) is $99 per person for a 3 hour course, and $169 per person for a 6 hour course. [3 person minimum applies]
If you would like to schedule personal training, prices are billed out at the instructor's hourly rate.
|
|
Topics
|
|
Excel 1 (beginning) |
|
- Keyboard shortcuts - improve efficiency
- Formulas - learn the basic structure of formulas
- Best practices - fundamental principals of good worksheet design
- Subtotals - learn the smart way to add numbers
- Group command - this feature allows you to hide and unhide rows quickly
- Vlookup - this formula is the secret to looking up data in your workbooks
- Named ranges - named ranges make workbooks more readable and improve formulas
- Skinny row - learn this technique for totals and subtotals
|
|
|
Excel 2 (intermediate) |
|
- Conditional format - auto-format cells depending on the value of the cell
- Hyperlinks - quickly navigate from workbook to workbook
- Data validation - use data validation to create drop-down menus
- If formula - the "if" formula is powerful, and can be used to flag errors
- Auto-filters - auto-filters are a useful was to filter out data in lists
- Protection - learn how to protect your workbook and worksheets
- Formulas - learn how to nest formulas, and used advanced formulas
|
|
|
Excel 3 (advanced) |
|
- Macros - learn how to use macros to automate tasks
- External data - learn how to import data from other workbooks and applications
- Pivot tables - use this powerful feature to design interactive reports
|
|
|
Access 1 |
|
- Database fundamentals - Overview of database organization and abilities
- Tables - Review tables, table properties and relationships
- Queries - Review various types of queries and their purpose
- Forms - Review forms, how to set them up for user interface and data entry
- Reports - How to set up basic reports
|
|
|
Access 2 |
|
- Queries - Advanced criteria, expressions and explore make-table, update, append, union and delete queries
- Forms - Explore advanced form properties, and specify report criteria on a form
- Reports - Explore advanced reports, sub-reports and the "on no data" event
|
|
