Microsoft Excel 2007 - Intermediate

Who Should Attend?

This workshop presumes that participants have a basic knowledge of Windows, and also presumes that participants have completed the Basic level of this course (or have equivalent knowledge) and are familiar with concepts such as working with rows and columns, and entering basic formulas.

What Will Be Covered?

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

Managing Tables

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

Enhancing your Workbook

• Customising 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

Format

Our training programs are practical with lots of interaction and discussion between the participants. During the one day workshop participants will cover concepts of the course, a step-by-step walkthrough followed by a skill sharpener. Participants are encouraged to interact and ask questions throughout the course.

Inclusions

A pre program questionnaire which is designed to assist you in receiving the best outcome and return on investment from your training. There is only a short amount of time to transfer the message so Sarden Learning will try to gain an insight into your company's background, processes, issues and culture so we are able to deliver an outstanding service for you.

Training Investment Price Quotes

• All needs assessment discussions
• All training development
• All training customization
• All training materials
• Training delivery
• All travel related costs and expenses
• You receive one invoice when the training is completed. No surprises.