Trainer: Jan Momchilovich
Qualifications: 27 years software training experience
Adjunct Professor, Central Wyoming College, 13 years
Size: Maximum 6 participants; Minimum 2 participants
Scheduling: JEM wants to work with your schedule! We will coordinate schedules of interested people as much as possible. If you have a friend or co-worker who is interested in the same software, have them sign up too!
Type: Hands-on Training
Manual: Step-by-step instruction manual included with all workshops except digital cameras.
Price: $75 - $499, see the individual workshop for pricing
Call 307-733-7527 to register!
NOTE: Depending on the individual class, some topics may not be covered or topics may be rearranged. Call for information on other Software Versions.
| Length | Workshop | Topics | |||
|
Excel XP or 2007, Basic Student Prerequisites: This course will benefit new or recent users of Excel. No previous experience of the application is required, but student should be confident using Windows, and ideally have basic word processing skills. |
|||||
|
2.5 hours |
Excel XP or 2007, Basic $99 |
What is a Worksheet When to Use Excel
Software Entering & Editing Data Saving Documents Opening Documents Moving Around in a Worksheet AutoFill On-Line Help Organizing Your Workbooks Formulas Working with Pointing & Ranges Copying Formulas Stylizing Printing Formatting Data with the Formatting Toolbar |
|||
| Excel XP or 2007, Intermediate Student Prerequisites: This course will benefit users of Excel with basic experience. Student should be confident using Windows, and have basic Excel skills. | |||||
|
2.5 hours |
Excel XP or 2007, Intermediate $99 |
Formula Review |
|||
|
Excel XP or 2007, Advanced Student Prerequisites: This course will benefit users of Excel with intermediate experience. Student should be confident using Windows, and have the intermediate and basic skills listed above. |
|||||
|
2.5 hours |
Excel XP or 2007, Advanced $99 |
Linking Data Working with Lists Filtering Data Creating Reports Working with Summary Report Outlining Functions Paste Function Wizard |
|||
| Excel XP or 2007, Charting Student Prerequisites: This course will benefit users of Excel who need to create charts. Student should be confident using Windows, and have intermediate Excel skills. | |||||
| 2.5 hours | Excel XP or 2007, Charting $99 |
Chart Types Pie Charts Column & Bar Charts Area & Line Charts 3-D Charts Presentation Concepts Embedded Charts & Chart Sheets Activating the Chart Sizing & Moving the Chart Selecting Chart Elements Changing Labels & Fonts Adding a Trend Line Deleting & Adding Data to Column Charts Rearranging the Series in Chart Data Changing the Chart Type Printing Charts |
|||
| Computer Utilities Windows XP Student Prerequisites: This course will benefit all basic level Windows users who want to safeguard their data, keep their computer running efficiently and Windows running optimally. | |||||
|
2.5 hours |
Windows XP, Computer Utilities $99 |
Backing Up Removing Programs Temp Files Recycle Bin Virus Check Scandisk Update Windows Defrag Scheduling |
|||
| PowerPoint XP or 2007, Student Prerequisites: This course will benefit users new to PowerPoint or with basic PowerPoint experience who want to take it further. Student should be confident using Windows and have basic word processing skills. | |||||
| 3 hours | PowerPoint XP or 2007 $110 |
Creating Successful Presentations Views Toolbars Using AutoContent Wizard (XP only) Working with Presentations Printing Presentations Adding & Modifying Text Adding & Modifying Templates Using Color Schemes Drawing & Modifying Objects Adding Clip Art, Pictures, Charts Creating & Editing Charts Producing a Slide Show Tips |
|||
| Access XP or 2007, Student Prerequisites: This course will benefit users new to Access or with basic Access experience who want to take it further. Student should be confident using Windows and have basic word processing skills. | |||||
| 2 - two hour sessions | Access, XP or 2007 $175 for 2-two hour sessions |
What is a Database Why is a Database Useful Database Planning Designing Database Structure Creating a Database Primary Keys Data Entry Creating a Form Add/Remove a Field Customizing Field Entry Help Sorting and Indexing Accessing Data (find, filter, query) Performing Calculations Customizing Forms Reports Calculations in Reports Exporting Information into Word (XP only) Attaching Word Files to Records (XP only) Copying, Compacting, & Backing Up |
|||
| Word XP or 2007, Intermediate Student Prerequisites: This course will benefit Word users with basic experience who want to take it further. Student should be confident using Windows and have basic word processing skills. | |||||
| 2.5 hours
|
Word XP or 2007, Intermediate $99 |
Selecting Text Center Text Soft Page/Hard Page Find/Replace Cut/Copy/Paste Combining Documents Undo Page Numbering/Headers & Footers Indents Hanging Indents Thesaurus Tabs Lists |
|||
| Word XP or 2007, Advanced I Student Prerequisites: This course will benefit Word users with intermediate experience who want to take it further. Student should be confident using Windows and have intermediate word processing skills. | |||||
| 2.5 hours | Word XP or 2007, Advanced I $99 |
Tables Sorting in Tables Complex Formatting File Management Using Word Advanced Time Savers & Tips Desktop Publishing |
|||
| Word XP, Advanced II Student Prerequisites: This course will benefit Word users with intermediate experience who want to learn these specific features. Student should be confident using Windows and have intermediate word processing skills. | |||||
| 2.5 hours | Word XP, Advanced II $99 |
Macros Mail Merge Forms |
|||
| Windows XP Intermediate Student Prerequisites: This course will benefit recent Windows users. Some previous experience is required. Student should be comfortable using basic Windows features. | |||||
| 2 hours
|
Windows XP, Intermediate $75 |
Ergonomics & Comfort Application Usage Desktop Accessories File Organization & Windows Explorer Creating Desktop Shortcuts Control Panel Search Menu |
|||
| Digital Camera Student Prerequisites: This course will benefit users with digital cameras that are at the beginner stage. Student should be comfortable using basic Windows features. | |||||
| 2 hours | Digital Cameras $75 |
Using a Digital Camera Emailing Photos Manipulating Pictures |
|||
|
4 - two hour sessions |
QuickBooks 2007 $375 |
Getting Started Setting Up a Company Working with Lists Setting up Inventory Selling Your Product Invoicing for Services Processing Payments Working with Bank Accounts Entering & Paying Bills Customizing Forms Creating Reports Tracking & Paying Sales Tax Doing Payroll Estimating |
|||
| 4 - two hour sessions | Project 2003 or 2007 $499 for 4 - two hour sessions |
What is Project? The Role of the Project Manager What Project Will Do for You Templates & Views Creating a New Project Tasks, Milestones, Constraints, Priorities Summary Tasks & Subtasks Dependencies, Lead & Lag Time Resources Reports Baselines |
|||
Go to top of page JEM Home Page
Call 307-733-7527 to register!