Microsoft Excel 2007 Essentials:

Formulas & Functions for Business Modeling and Financial Problem Solving

Monday, February 22, 2010 8:30 AM to 4:15 PM

Monday, March 29, 2010 8:30 AM to 4:15 PM 

Whether you’re modeling a business budget or managing your company’s inventory, you’re using (or need to be using) Excel formulas. This program covers nearly every aspect of Excel formulas, from the very simple to the extremely complex.

Lesson Objectives include:

• Use and interpret three-dimensional cell references, even across multiple workbooks.
• Produce and manage multiple business model situations using Scenario Manager, including the automatic and instant creation of a columnar summary report showing all situations side-by-side.
• Define range names and apply range names to formulas and workbook navigation.

Microsoft Excel 2007 Macro Programming–Level I

Wednesday, February 24, 2010 8:30 AM to 4:15 PM

Tuesday, March 30, 2010 8:30 AM to 4:15 PM 

Save time and increase productivity by automating mundane and repetitive tasks with Macros and VBA procedures.  Skills learned in this course are immediately transferable to Word, PowerPoint and Access!

Lesson Objectives include:

• Use the Macro recorder and understand the VBE interface
• Apply “Glen’s 4 Simple Rules for Understanding VBA” to quickly read, comprehend and ultimately edit and create powerful macros.
• Practice simple edits in VBA using messaging tools, simple branching statements and a looping construct

Use discount code “DAY1″ to register for 1st day only @ $295.00

---

Microsoft Excel 2007 Macro Programming–Level II

Automating Task and Eliminating Redundant Steps using Macros & VBA 

Thursday, February 25, 2010, 8:30 AM to 4:15 PM

Wednesday, January 13, 2010 8:30 AM to 4:15 PM 

• Describe how to create variables in VBA and identify three variable features.
• Learn how to distribute your VBA solutions by building Add-Ins for Excel
• Developing custom Function in VBA

Use discount code “DAY2″ to register for 2nd day only @ $295.00