Trainings are held at Lumity
29 East Madison
Suite 1005
Chicago, IL 60602-4529
Phone: 312.372.4872
Fax: 312.372.7962
Register for courses:: register@lumity.org

Home > Course Series > Numeric Analysis & Reporting

Numeric Analysis and Reporting Using Microsoft Excel

Microsoft Excel (2003): Basic Concepts

This course is suitable for beginners, but more experienced users will learn tips to manage tables that will give you quality results with improved readability. In this hands-on course you will learn how to:

• Understand Excel's tools.
• Navigate around a spreadsheet.
• Enter and edit information.
• Use basic formulas.

Tuesday, September 28, 2010, 8:30 am – 12:15 pm

Microsoft Excel (2003): Graphs, Lists, and Macros

In this course for intermediate users, you will learn how to:

• Create, edit, and use graphs to present your data.
• Create and use macros.
• Understand how to format information.
• Create visual effects.
• Format tables and manipulate lists.

Tuesday, September 28, 12:45 pm – 4:30 pm

 

Microsoft Excel (2007): Basic Concepts

The Fluent Ribbon menu system is significantly different and even experienced Excel users will find this course helpful before transitioning to Office 2007. This is a hands-on course where you will use a nonprofit budget case study to learn how to:

• Understand Excel's Fluent Ribbon menu and tools.
• Navigate around a spreadsheet.
• Enter and edit information.
• Use basic formulas.

Thursday, July 15, 2010, 8:30 am – 12:15 pm

 

Microsoft Excel (2007): Functions and Lookups

Students taking this course must have a solid working knowledge of MS Excel, including basic terms such as workbook, worksheets, cell and row naming, and formulas. In this class you will learn how to:

• Use advanced functions.
• Learn the IF, VLOOKUP, and HLOOKUP functions.
• Use macros.
• Customize formulas spanning multiple worksheets.

Thursday, July 15, 2010, 12:45 pm – 4:30 pm

 

REGISTER for any of these courses by email, or download a registration form.