Jewellery Designing Interrior Designing Fashion Designing Aonline Training Franchise Scheme Send Free E-Greetings "Compufield -computer Institute specialized in fast track courses-multimedia,web designing,software engineering,certification courses,fashion,jewellery,interior designing courses. India,Bombay(Mumbai)."
Franchise Scheme Latest Courses At Compufield
Compufield now in Bandr
Franchise enquiry welcome It corporate Training World wide

 

click here for photoshop Course content


  MS Office & Financial Application Courses :
   Certificate Course in Office Automation & Internet I Diploma In Office Automation & Internet I Computer Fundamentals + Windows O/S + Internet Tech I
    Certificate course in Financial Application (Tally) I Advance Excel I Tally 9.2 (15) + Advance Excel (30) I
Search For Our Courses

ISO 9001:2000 Certified Computer Institute
Why do
Foreign/Indian Students prefer to study at COMPUFIELD?

Home
Join our Newsletter


Enter your E-Mail

ABout Us
Courses
Registration
Our Students
Business Offer

 

Microsoft Excel Level 2

    Course Title: Microsoft Excel, Level 2 (2003, XP, 2000, 97) Duration : 1 day


    This program is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

     

    Program Objectives


    This Advanced Excel training program will empower the participants to be able to do the following:

    o Performing complex calculations more efficiently, using various Excel functions.
    o Organizing and analyzing large volumes of data.
    o Creating MIS reports.
    o Designing and using templates.
    o Consolidating and managing data from multiple workbooks.

    Audience


    Executives and managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.

    Prerequisites


    Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.

    Day-wise Break-up

    Day

    Module Topic
    Day 1 Module 1 Overview of the Basics
      Module 2 Working with Functions
      Module 3 Data Validation
      Module 4 Working with Templates
      Module 5 Sorting and Filtering Data
      Module 6 Working with Reports
      Module 7 More Functions
      Module 8 Formatting

    Courses Outline


    Module 1: Overview of the Basics

    o Customizing common options in Excel
    o Absolute and relative cells
    o Protecting and un-protecting worksheets and cells

     

    Module 2: Working with Functions


    o Writing conditional expressions (using IF)
    o Using logical functions (AND, OR, NOT)
    o Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)

     

    Module 3: Data Validations


    o Specifying a valid range of values for a cell
    o Specifying a list of valid values for a cell
    o Specifying custom validations based on formula for a cell

     

    Module 4: Working with Templates


    o Designing the structure of a template
    o Using templates for standardization of worksheets

     

    Module 5: Sorting and Filtering Data


    o Sorting tables
    o Using multiple-level sorting
    o Using custom sorting
    o Filtering data for selected view (AutoFilter)
    o Using advanced filter options

    Module 6: Working with Reports


    o Creating subtotals
    o Multiple-level subtotals
    o Creating Pivot tables
    o Formatting and customizing Pivot tables
    o Using advanced options of Pivot tables
    o Pivot charts
    o Consolidating data from multiple sheets and files using Pivot tables
    o Using external data sources
    o Using data consolidation feature to consolidate data

     

    Module 7: More Functions


    o Date and time functions
    o Text functions
    o Database functions

     

    Module 8: Formatting


    o Using auto formatting option for worksheets
    o Using conditional formatting option for rows, columns and cells

     

Lodging, boarding and travelling not included in the fees.
The above mentioned fees is for one course.
   
COMPUFIELD offers a unique style of learning -

One computer : One student : One Instructor
Maximum Instructor to Student Ratio 1:4
Sessions : Each session will be of 1 hour.
The timing can be fixed based on our mutual convenience,between 9.00 a.m. to 7.00 p.m.
Overseas Students take 5 to 10 hours per day to complete their courses.
Course duration in days = total sessions divide by number of sessions per day.
The Above Mentioned Tuition Fees Includes Service Tax
No extra charges/refund for more/less time taken to complete the course.


Top

Enquire About This Course
Classroom Training In Mumbai - India Only
*Name
Mobile
(Number-Coutry code & city code)
e.g. +91-22-23676218
*Email
*Course Of Interest
Enquiry
Anti-Spam
Type 12345 in the above box
 
(*) Signed fields are mandatory.
*** Data entered in the form
will be kept confidential..
 

Solve your Queries Online related to our Courses
Mobile Number
M.E. Khairaz (MD)
Gmail
Yahoo Messenger
Yahoo
Skype
Whats App
Connect With us@

Address (HO) : Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road, Mumbai - 400 036, India.
+91-22-23676218 / 23671772
Mobile: +91 9820134058
Bandra (W): 1st Floor. O'Priya Building, Peter Dias Road, Near Mehboob Studio , Bandra (West) Mumbai - 400 050, India compufield bandra address
+91 - 26551794 / +91 9322755916
Andheri (W): Office No R- 26, 1st Floor, RNA Complex Lokhandwala, 3rd Cross Lane, Next to High Point Restaurant, Andheri (West) Mumbai - 400 053, India
+91 9820494017