AppTech Business Solutions

             Contact US

Microsoft Excel - Level 1 (1 Day) Excel is the best spreadsheet program on the market. After only one day, the student will be able to create basic workable spreadsheets that convey concise, up-to-the-minute date and look good doing it.

• Typing equations vs. Autosum
• Formatting
• Copy
• Move
• The amazing Fill button
• Inserting/deleting columns/rows
• Adjusting column widths
• Proper spreadsheet layout
• Creating custom fill lists
• Understanding and using absolute cell addresses
• Print preview
• Printing
• Introduction to =IF equations

Cost: $175/person (Courseware Material Included)

Excel - Level 2 (1 Day) This is where you start to use Excel’s power tools and see how you can get this multi-talented program to work for you – with little effort. An interesting and challenging course for average EXCEL user who wants to move beyond average user status.

• =IF equation use (continued from level 1)
• Multiple-condition =IF equations
• Nested =IF equations
• Three-dimensional spreadsheets
• Linking sheets with equations
• Linking files with equations
• Creating and Editing Graphs
• Sorting data
• AutoFilter
• Data sub-total function (group reporting)

Cost: $175/person (Courseware Material Included)

Excel - Level 3 (1 Day) An exciting and challenging course for the intermediate Excel user. Learn to create macros that manipulate forms. Include input control like spinners, scroll bars and drop-down lists in your input forms. A busy day.

• Range names
• Vertical and horizontal lookup tables
• Audit functions (tracing precedents, dependants, and errors)
• Creating input forms
• Adding controls (drop-down lists, spinners, option buttons)
• Basic macros
• Adding macros to the toolbar
• Adding macros to forms
• Adding dialog boxes to macros
• Pivot tables (if time)

Cost: $175/person (Courseware Material Included)

Send mail to Wayne@TheAppTech.com with questions or comments about this web site.
Copyright © 2006 AppTech,LLC.