Excel 2007 school training courses in Des Moines, IA (public, in-house or online)

In this course, students create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks. (Second Edition)

At Course Completion:
Upon successful completion of this course, students will be able to: - Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet. - Perform calculations. - Modify a worksheet. - Format a worksheet. - Print workbook contents. - Manage large workbooks.

Outline :
Lesson 1: Creating a Basic Worksheet
Explore ...

Full archival course description>>

1.Visual Basic Editor A.Visual Basic for Applications
B.Object programming
C.The Object Browser

2.Programming basics A.Data basics
B.Scope of variables
C.Scope of procedures

3.Control structures A.Decision structures
B.Loop structures

4.Custom dialog boxes A.User forms
B.Events

5.Debugging and error handling A.Errors
B.Debugging
C.Error handling

Microsoft Excel is an electronic spreadsheet which can be used to arrange data in rows and columns. Microsoft Excel includes features to use advanced filters, data validation and security features such as protection, digital signatures and passwords. This application helps to speed up the process of analysis of data using single or multiple variations or conditions.

Anyone who can use formulas and charts with ease will be comfortable with Microsoft Excel as well. This application is pop...

Full archival course description>>

Our trainers are industry and product experts that have mastered the use of each product in the field and enjoy teaching others how extract the maximum benefit from OEM product use at each students organization, big or small. Students learn from Industry experts with hands on product experience in multiple hardware and software environments and will benefit in the following ways.

Benefits of AMS Trainers
•The industries highest quality Computer Product Trainers for more than 4,000+ pro...

Full archival course description>>

Any proficient Microsoft Excel user will agree that MS Excel is a very powerful analytical tool. Wouldn’t it be great to learn how to effectively use all the advanced Excel features at your disposal? In this practical and information-packed course, you’ll see how to maximize Excel’s functions and capabilities.

Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these...

Full archival course description>>