Excel 2007 Advanced Training

Friday, Jul 29, 2022 at 9:00 AM to 5:00 PM AEST

Mount Skills, Toowoomba, SA, 4350, Australia

Register Now
Days
Hours
Minutes
Seconds

Registration

Sale ended

Early Bird Fee Partial Approval - $649.00

sales ended

Standard Fee Partial Approval - $799.00

Enter your discount code

  • Subtotal (excluding fees and discounts)
  • Fee
  • Total amount

Friday, Jul 29, 2022 at 9:00 AM to 5:00 PM AEST

Mount Skills, Toowoomba, , SA, 4350, Australia.

Knowing how to use the advanced features of Microsoft Excel 2007 opens a completely new experience in using this spreadsheet program. The novice user tends to use Excel 2007 as a holding place for report data. They may know how to insert data and move columns around, but rarely go into the deeper functions that Excel 2007 offers.

This workshop will teach the participants the most common advanced features of Microsoft Excel 2007. The goal of this course is to get them familiar with these functions in a safe learning environment. Once it is completed, their familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for everyone at work or at home.

Learning Objectives:

After completing this course, Individuals will be able to demonstrate their understanding of:

  • SmartArt
  • Inserting Objects
  • Creating Charts
  • Creating Pivot Tables
  • Working with Pivot Tables
  • Creating Pivot Charts
  • Solving Formula Errors
  • Using What-If Analysis
  • Managing Your Data
  • Grouping and Outlining Data

Agenda:

  • Module One: SmartArt
  • Module Two: Inserting Objects
  • Module Three: Creating Charts
  • Module Four: Creating Pivot Tables
  • Module Five: Working with Pivot Tables
  • Module Six: Creating Pivot Charts
  • Module Seven: Solving Formula Errors
  • Module Eight: Using What-If Analysis
  • Module Nine: Managing Your Data
  • Module Ten: Grouping and Outlining Data
  • Module Eleven: Wrapping Up

Prerequisites:

Basic Knowledge in Excel 2007

Course Materials:

Attendees will receive a course manual with presentation slides and reference materials.

Note: If you would need any assistance, let me help you to get registered. Reach us at: info@mountskills.com

Mountskills_inc

Mount Skills is known as one of the world's leading competency developers that brings a unique approach to building specialized training programs. Mount Skills training divisions offer the same level of expertise and experience, which makes us stand out from the competition. Through our training courses, we help transform your organization for the better. By adopting advanced Techniques and New Ways of Working, we empower your staff with the knowledge and guidance to understand, engage with, and influence change. In-Class training programs are designed for individuals, who seek more personalized training experience and hands-on training requirements wherein Virtual Live is immersive learning, guided by the subject matter experts. All our classroom training sessions can be conducted On-Site at your workplace or a location that you choose, for the convenience and peace of mind of your employees. We help you develop any skill you need for any role. Participants will greatly benefit from our skill-set.

Contact the Organizer View other events