Microsoft Excel 2007 - Advanced

Who Should Attend?

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

What Will Be Covered?

Getting the most from your data

• Getting the most from your data
• Pivot Tables
• More about Pivot Tables
• Exploring scenarios
• What If analysis

Excel and the Internet

• Excel and Hyperlinks
• Saving Workbooks as Web Pages
• Getting Data from the Internet
• Excel and Office Servers

Advanced Excel Tasks

• Creating and using shared workbooks
• Using custom AutoFill lists
• Using the VLOOKUP function
• Linking, consolidating and combining workbooks

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.