at_logo  
.

Welcome to AutoTRAIN

  The Professionals Choice”

for all Training, Consultancy

and Support

.

Microsoft Product Courses

   

     

MS Excel

         

MS Excel Introduction
MS Excel Intermediate
MS Excel Advanced

 

 

Microsoft Excel Introductory Level

   
Course Duration: 1 Day

Pre-requisites:
Working knowledge of Microsoft
 Windows would be useful but not
 essential

Book This Course


 

  Course Contents
  • The Excel Screen
  • Getting Help
  • Entering Data and Text
  • Saving your Work
  • Selecting Cells
  • Entering Formulas
  • Using Autofil
  • The Sigma Button
  • Introducing Functions
  • Cut, Copy and Paste
  • Using Drag and Drop
  • Formatting the Worksheet
  • Using Page Set-up
  • Printing a Worksheet
     
  •              

    Microsoft Excel Intermediate Level

                 
    Course Duration: 1 Day

    Pre-requisites:
    Students should be familiar with
     Microsoft Excel and have a sound
    knowledge of the topics indicated
     the introductory course structure

    Book This Course
      Course Contents
  • Adding Headers and Footers
  • Advanced Printing Options
  • Working in 3D
  • 3D Ranges in Formulae and Functions
  • Using and Manipulating Named Ranges
  • Absolute and Relative Cell Referencing
  • Conditional Logic
  • The Excel Database
  • Using Filters and Subtotals
    Creating Charts
  • Creating your own Number Formats
  • Creating your own Character Styles
  •              

    Microsoft Excel Advanced Level

                 
    Course Duration: 1 Day

    Pre-requisites:
    Thorough knowledge and understanding of all introduction and
     intermediate course topics. The
     course is for users who require
     greater efficiency through use of
     more complex and advanced features
     and or who are required to produce
     spreadsheets for others users.

    Book This Course
     

    Course Content

  • Creating Nested Conditional Tables

  • Working with Look-Up Tables
  • Creating & Using Templates
  • Working with Advanced Functions
  • Managing Data using Groups & Outlines
  • Scenarios and What If Analysis
  • Advanced Charting
  • Using Database Functions
  • Macros using Visual Basic, with Form Controls
  • Error Trapping techniques, Worksheet Protection
  • Customising Menus
  • Dynamic Data Exchange and using Excel with other products
  •  
     

     

     
       
    home

    courses

    -      AutoCAD

    -      Other

    -      Microsoft

    -      Internet

    special offers
    e-booking
    enquiry
    consultancy

    drawing management

    portfolio
    free newsletter
    map
    contact us

      .

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     
     
         

    User Group Website

    © AutoTRAIN 2006. All rights reserved