The Knowledge Academy - Contact Form

Who Should Attend the course?

Users with a basic understanding of Microsoft Excel 2007 who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Course Outline

Advanced File Tasks

• Using My Computer within Excel • Saving Your Files • Using Templates

Working with Functions and Formulas

• Using Formulas in Excel • Exploring Excel Functions • Using Functions in Excel • Working with Names and Ranges • Working with Array Formulas • Text Functions: CONCATENATE, LEFT/RIGHT, UPPER/LOWER/PROPER

Managing Tables

• Working with Tables • Working with Records and Fields • Working with Tables and Filters • Using Excel as a Database

Enhancing your Workbook

• Customizing your Workbook • Working with Text Boxes • WordArt • ClipArt • Using Objects

Finalising your Workbook

• Protecting your Workbook • Finishing your Workbook • Using Excel in Word • Using Excel and Access • Using Excel with other Programs and Files

Using Charts

• Working with Charts: Basics • More about Working with Charts