Compufield.net
Compufield.net
Compufield.net
Search for our Course
Send To a Friend
 

IT Corporate Training

Home
 
 
 
 

Microsoft Excel Level - I

    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:

    Creating and editing worksheets
    Formatting and printing of worksheets
    Commands for managing data such as sorting, filters, subtotals, pivot tables
    Working with charts
    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

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

     

    Module 2: Formatting a Spreadsheet


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

     

    Module 3: Formulas and Functions


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

     

    Module 4: Editing Features


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

     

    Module 5: Working with Large Worksheets


    Freezing and unfreezing panes
    Splitting windows
    Inserting page breaks for printing

     

    Module 6: Working with Charts


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

     

    Module 7: Previewing and Printing


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

     

    Module 8: Simple Database Operations


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

Solve your Queries Online related to our Courses

E_mail me E-mail me
khairaz@compufield.net

Yahoo MessengerYahoo Messenger
compufield@yahoo.com
MSN MessengerMSN Messenger
compufield@hotmail.com
ICQICQ No.
28444214

MSN MessengerMobile Number
+91-9820 134058

ICQFax Number
091-22-23673104

HEAD OFFICE : Chinoy Mansion, First Floor, Block # 2, Opposite St. Stephens Church, Warden Road,
Mumbai (Bombay) - 400 036. India.091-22-2
"aonlinetraining - distance learning school, institute, college, academy, multimedia, digital art, interior and fashion designing, jewellery, jewelry, jewelery design, internet technology, and software engineering courses" "institute of online internet e-learning, courses  in computer generated fashion designing, technology,free tutorials  haute couture using coreldraw and photoshop software-CAD" "jewelcad distance education courses,  computer based jewellery, jewelry, jewelry, jewelery designing in gold, platinum, diamonds, professional internet learning of necklaces, bracelets, rings, earrings designs"
 
"Compufield -computer Institute specialized in fast track courses-multimedia,web designing,software engineering,certification courses,fashion,jewellery,interior designing courses. India,Bombay(Mumbai)." "COMPUFIELD-Leader in Global IT Corporate training having more than 20yrs exp.Programs offered MS-Office, Advance Excel, Java, Oracle, Linux and many more." "Compufield : free e-greeting cards, animated, musical greetings, ecards, postcards for Christmas, xmas, new year, eid, diwali, valentine's day, birthday, friendship, anniversary, love, congratulations, Halloween."
     


3676218 (5 Lines), Fax: 091-22-23673104.Top
Send Free E-Greetings! Franchise Enquiry Solicited Designing Future's Since 1985