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 1

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


    This program introduces participants to working with Microsoft Excel, covering the basics such as creating and editing worksheets, formatting them for a professional look, working with formulas to manage routine tasks, etc.

     

    Program Objectives


    This introductory Excel training course will provide you with a working understanding of the basic features of MS Excel as follows:

    o Creating and editing worksheets
    o Formatting and printing of worksheets
    o Commands for managing data such as sorting, filters, subtotals, pivot tables
    o Working with charts
    o Working with in-built functions of Excel

     

    Audience


    Executives and managers from various functions (such as Finance, Sales, HR, etc.) who need to work with lots of calculations and analyze data for their day-to-day operations.

     

    Course Summary

    Day

    Module Topic
    Day 1 Module 1 Getting Started
      Module 2 Formatting a Spreadsheet
      Module 3 Formulas and Functions
      Module 4 Editing Features
      Module 5 Working with Large Worksheets
      Module 6 Working with Charts
      Module 7 Previewing and Printing
      Module 8 Simple Database Operations

     

    Courses Details


    Module 1: Getting Started

    o Understanding the Excel screen
    o Navigating in a spreadsheet
    o Understanding worksheets, columns, rows and cells
    o Saving, opening, and closing workbooks

     

    Module 2: Formatting a Spreadsheet


    o Changing column widths and row heights
    o Changing alignment of cells
    o Undoing and redoing actions
    o Formatting numbers
    o Clearing formats
    o Applying borders to cells
    o Merging cells

     

    Module 3: Formulas and Functions


    o Entering formulas
    o Copying data and formulas
    o Using AutoSum
    o Understanding functions
    o Using simple aggregate functions (Sum, Count, Average, Min, Max)
    o Copying formulas
    o Types of cell referencing: relative and absolute
    o Applying conditions in a formula (The IF function)
    o Working with ranges

     

    Module 4: Editing Features


    o Using cut , copy, and paste operations
    o Using paste special with values
    o Selection techniques
    o Navigation techniques

     

    Module 5: Working with Large Worksheets


    o Freezing and unfreezing panes
    o Splitting windows
    o Inserting page breaks for printing

     

    Module 6: Working with Charts


    o Creating charts using Chart Wizard
    o Creating different types of charts
    o Including titles and values in charts
    o Formatting of charts

     

    Module 7: Previewing and Printing


    o Previewing worksheets
    o Page setup
    o Printing of worksheets in multiple pages
    o Repeating rows and columns for multiple pages
    o Printing multiple worksheets

     

    Module 8: Simple Database Operations


    o Sorting tables
    o Filtering data with auto filter
    o Generating subtotal reports
    o Creating pivot tables
    o Referring data from other worksheets

     

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