Microsoft Excel 2007

Basic

You will create and edit basic Microsoft Office Excel 2007 worksheets and workbooks.

Course Details

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper based systems to store data that you run calculations on. You now want to migrate that data to an electronic format.

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 is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.

Pre-Requisites

Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.

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: Creating a Basic Worksheet
          Topic 1A: Explore the User Interface and the Ribbon
          Topic 1B: Navigate and Select in Excel
          Topic 1C: Obtain Help
          Topic 1D: Enter Data and Save a Workbook
          Topic 1E: Customize the Quick Access Toolbar
                                                      
  
Lesson 2: Performing Calculations
        Topic 2A: Create Basic Formulas
        Topic 2B: Calculate with Functions
        Topic 2C: Copy Formulas and Functions

Lesson 3: Modifying a Worksheet
        Topic 3A: Manipulate Data
        Topic 3B: Insert and Delete Cells, Columns, and Rows
        Topic 3C: Search for Data in a Worksheet
        Topic 3D: Spell Check a Worksheet

Lesson 4: Formatting a Worksheet
        Topic 4A: Modify Fonts
        Topic 4B: Add Borders and Color to Cells
        Topic 4C: Change Column Width and Row Height
        Topic 4D: Apply Number Formats
        Topic 4E: Position Cell Contents
        Topic 4F: Apply Cell Styles

Lesson 5: Printing Workbook Contents
        Topic 5A: Print Workbook Contents Using Default Print Options
        Topic 5B: Set Print Options
        Topic 5C: Set Page Breaks

Lesson 6: Managing Large Workbooks
        Topic 6A: Format Worksheet Tabs
        Topic 6B: Manage Worksheets in a Workbook
        Topic 6C: Manage the View of Large Worksheets

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
Mon 12 Mar 2012	Mon 12 Mar 2012	1 days	Kyalami	Book
Wed 9 May 2012	Wed 9 May 2012	1 days	Kyalami	Book
Mon 11 Jun 2012	Mon 11 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
Sat 3 Mar 2012	Sat 3 Mar 2012	1 days	Kyalami
Mon 16 Apr 2012	Mon 16 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