Microsoft Excel 2007

Advanced

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Details

In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets,collaborating on worksheets with others, and sharing Excel data with other applications.

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Kyalami, Midrand - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Light finger meals are supplied for part time courses.

Audience

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data.

Pre-Requisites

To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft Office Excel 2007 Basic and Microsoft Office Excel 2007 Intermediate

Course Duration

1 Day

Cost using our PC's as from 1st of March 2012

R 1,820.00 excl vat
R 2,074.80 incl vat

Cost using your own PC's as from 1st of March 2012

R 1,620.00 excl vat
R 1,846.80 incl vat

Note: information may change without notice.

Course Outline

Lesson 1: Streamlining Work flow
          Topic 1A: Create a Macro
          Topic 1B: Edit a Macro
          Topic 1C: Apply Conditional Formatting
          Topic 1D: Add Data Validation Criteria
          Topic 1E: Update a Workbook's Properties
          Topic 1F: Modify Excel's Default Settings

Lesson 2: Collaborating with Others
        Topic 2A: Protect Files
        Topic 2B: Share a Workbook
        Topic 2C: Set Revision Tracking
        Topic 2D: Review Tracked Revisions
        Topic 2E: Merge Workbooks
        Topic 2F: Administer Digital Signatures
        Topic 2G: Restrict Document Access

Lesson 3: Auditing Worksheets
        Topic 3A: Trace Cells
        Topic 3B: Troubleshoot Errors in Formulas
        Topic 3C: Troubleshoot Invalid Data and Formulas
        Topic 3D: Watch and Evaluate Formulas
        Topic 3E: Create a Data List Outline

Lesson 4: Analyzing Data
        Topic 4A: Create a Trendline
        Topic 4B: Create Scenarios
        Topic 4C: Perform WhatIf Analysis
        Topic 4D: Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks
        Topic 5A: Create a Workspace
        Topic 5B: Consolidate Data
        Topic 5C: Link Cells in Different Workbooks
        Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data
        Topic 6A: Export Excel Data
        Topic 6B: Import a Delimited Text File

Lesson 7: Using Excel with the Web
        Topic 7A: Publish a Worksheet to the Web
        Topic 7B: Import Data from the Web
        Topic 7C: Create a Web Query

Lesson 8: Structuring Workbooks with XML
        Topic 8A: Develop XML Maps
        Topic 8B: Import and Export XML Data

Scheduled Dates

To apply for a booking, click on the relevant "Book" link below.
Note: places are only fully secured once payment has been made.

From Date	To Date	Duration	Venue
Wed 14 Mar 2012	Wed 14 Mar 2012	1 days	Kyalami	Book
Fri 11 May 2012	Fri 11 May 2012	1 days	Kyalami	Book
Wed 13 Jun 2012	Wed 13 Jun 2012	1 days	Kyalami	Book

Provisional Dates

These dates have not yet been confirmed. If you are interested in attending please enquire below.

From Date	To Date	Duration	Venue
Tue 28 Feb 2012	Tue 28 Feb 2012	1 days	Kyalami
Sat 17 Mar 2012	Sat 17 Mar 2012	1 days	Kyalami
Wed 18 Apr 2012	Wed 18 Apr 2012	1 days	Kyalami

Course Enquiry

If you have a query relating to this course, please complete the form below.

Name
Email
Contact Number
Query
Security Code
Verify Code

Advanced Project Management   Advanced Skills for the Practical Trainer   Advanced Writing Skills   Building Better Teams   Building Relationships for Success in Sales   Building Your Self Esteem and Assertiveness Skills   Business Etiquette: Gaining That Extra Edge   Business Leadership: Improving Management Performance   Business Succession Planning: Developing and Maintaining a Su   Business Writing that Works   Call Center Training: Sales and Customer Service Training for   Change and How to Deal with It   Communication Strategies   Conflict Resolution: Dealing with Difficult People   Conflict Resolution: Getting Along in the Workplace   Conquering Your Fear of Speaking in Public   Creating a Dynamite Job Portfolio   Creating and Managing Your Corporate Brand   Critical Thinking   CRM: An Introduction to Customer Relationship Management   Customer Service Training: Critical Elements of Customer Serv   Customer Service Training: Managing Customer Service   Delegation - The Art of Delegating Effectively   Dynamite Sales Presentations   Effective Planning and Scheduling   Employee Dispute Resolution: Mediation through Peer Review   Facilitation Skills   Generation Gap: Closing the Generation Gap in the Workplace   Getting Your Job Search Started   Hiring for Success: Behavioral Interviewing Techniques   Human Resources Training: HR for the Non-HR Manager   Intermediate Project Management   Introduction to Neuro Linguistic Programming   Inventory Management - The Nuts and Bolts   Leadership Skills for Supervisors:Communication, Coaching, an   Marketing and Sales   Mastering the Interview   Meeting Management - The Art of Making Meetings Work   Motivation Training: Motivating Your Workforce   Negotiating For Results   NLP Tools for Real Life   Onboarding: The Essential Rules for Successful Onboarding   Orientation Handbook: Getting Employees Off to a Good Start   Overcoming Objections to Nail the Sale   Performance Management: Managing Employee Performance   Problem Solving & Decision Making   Project Management Fundamentals   Prospecting for Leads Like a Pro   Public Speaking: Presentation Survival School   Public Speaking: Speaking Under Pressure   Risk Management   Skills for the Administrative Assistant   Stress Management   Survival Skills for the New Trainer   Team Building:Developing High Performance Teams   Telemarketing - Using the Telephone as a Sales Tool   The ABCs of Supervising Others   The Minute-Taker's Workshop   The Practical Trainer   The Professional Supervisor   Tough Topics: Talking to Employees about Personal Hygiene   Using Activities to Make Training Fun   Working Smarter:Using Technology to Your Advantage   Writing Reports and Proposals   Accounting Skills for New Supervisors   Administrator Bootcamp   Adobe Captivate   Advanced PHP   Anger Management: Understanding Anger   Assertiveness as a Business Tool   Basic Computer Skills   Budgets and Managing Money   Business and Report Writing   Change Management   Coaching for Growth and Performance   Coaching In The Call Centre Environment   Coaching: A Leadership Skill   Communicating Across Cultures   Concepts of Information Technology   Conducting Effective Performance Reviews   Conflict Resolution   Creating a Top Notch Talent Management Program   Customer Service   Developing Your Training Program   Dreamweaver CS5   Drupal Administration   Effective Business Writing   Emotional Intelligence: Its Not What You Think   Finance for Non Financial Managers   Flash CS5   Fundamentals of Selling   Getting Stuff Done: Personal Development Boot Camp   Graphic Design Practicals   High Performance PA and Management Skills for the Administrator   HTML and CSS   HTML5 upgrade   Human Resources Training for the Non HR Manager   Illustrator CS4   Illustrator CS5   InDesign CS5   Interpersonal Skills   Introduction to PC   Introduction to Programming   Java   Javascript   Joomla Basic   Joomla Intermediate   jQuery   Linux Essentials   Linux Master Bundle   Linux Networking   Linux Point&Click Admin   Linux Security   Linux Single Sign On   Linux System Administration 1   Linux System Administration 2   Linux Ubuntu 199   Management and Supervisory Skills   Microsoft Access 2007   Microsoft Excel 2007: Advanced   Microsoft Excel 2007: Basic   Microsoft Excel 2007: Intermediate   Microsoft Outlook 2007   Microsoft PowerPoint 2007   Microsoft Project 2007   Microsoft Visio   Microsoft Word 2007   Motivating Your Employees   MySQL   MySQL Administration   Negotiation Skills   Office Administration   Open ICDL Module 1   OpenOffice   PC Networking   Perl Fundamentals   Photoshop CS5   PHP   PostgreSQL Administration   Practical Leadership   Presentation Skills (US 13925)   Presentations Skills   Project Management   Project Management   Protecting Intellectual Property   Python   Search Engine Optimization   Selling Smarter   Sexual Harassment Awareness for Employees   Sexual Harassment Awareness for Supervisors   SQL (Database)   TCP/IP Networking   Team Leadership   Telephone Etiquette   Telephone Skills for Call Centres   Time, Performance and People Management   Train the Trainer   Web Design Practicals   Web Developer   Webmaster   Windows 7   WordPress   Writer   XML