Microsoft Excel 2007

Intermediate

You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Course Details

In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

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

The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web

Pre-Requisites

Microsoft Office Excel 2007: Basic

Course Duration

1 Day

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

R 1,388.00 excl vat
R 1,582.32 incl vat

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

R 1,188.00 excl vat
R 1,354.32 incl vat

Note: information may change without notice.

Course Outline

Lesson 1: Calculating Data with Advanced Formulas
          Topic 1A: Manage Cell and Range Names
          Topic 1B: Calculate Data Across   Worksheets
          Topic 1C: Use Specialised Functions
          Topic 1D: Analyse Data with Logical and Lookup Functions
                                                       
Lesson 2: Organizing Worksheet and Table Data
        Topic 2A: Create and Modify Tables
        Topic 2B: Format Tables
        Topic 2C: Sort or Filter Worksheet or Table Data
        Topic 2D: Calculate Data in a Table or Worksheet

Lesson 3: Presenting Data Using Charts
        Topic 3A: Create a Chart
        Topic 3B: Modify Charts
        Topic 3C: Format Charts

Lesson 4: Analyzing Data Using PivotTables and PivotCharts
        Topic 4A: Create a PivotTable Report
        Topic 4B: Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects
        Topic 5A: Insert and Modify Pictures and ClipArt
        Topic 5B: Draw and Modify Shapes
        Topic 5C: Illustrate Workflow Using SmartArt Graphics
        Topic 5D: Layer and Group Graphic Objects

Lesson 6: Customising and Enhancing Workbooks and the Excel Environment
        Topic 6A: Customise the Excel Environment
        Topic 6B: Customise Workbooks
        Topic 6C: Manage Themes
        Topic 6D: Create and Use Templates

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
Tue 13 Mar 2012	Tue 13 Mar 2012	1 days	Kyalami	Book
Thu 10 May 2012	Thu 10 May 2012	1 days	Kyalami	Book
Tue 12 Jun 2012	Tue 12 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
Mon 27 Feb 2012	Mon 27 Feb 2012	1 days	Kyalami
Sat 10 Mar 2012	Sat 10 Mar 2012	1 days	Kyalami
Tue 17 Apr 2012	Tue 17 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