MS Excel Course
 
Introduction - What is a spreadsheet?Starting MS ExcelThe Excel screenTitle, menu and toolbarsCreating a new workbookMoving around the sheetSelecting/deleting and modifying cellsEntering and editing data
Entering Data
    Entering text, dates, and numbers
    Using personalized menus 
    Moving to a specific cell
Editing a Cell
    Editing cell content
    Using Undo and Redo
    Clearing cell content
    Clearing cell formats
Editing Multiple Cells
    Inserting and deleting selected cells
    Copying and moving cells
Replacing Values and AutoFilling
    Using Find and Replace
    Working with series (AutoFill)
    AutoFill
    Freezing a frameSelecting/deleting/modifying and copying rows     and columns
    Using the 'Go To' feature
    Saving and closing a workbook, opening and deleting a    
    workbook
    AutoSum, entering formulae
    Statistical functions
    Relative and absolute addressing
    Formatting and enhancing the worksheet
    Printing a workbook - print preview
    Page set-up
    Autoformat
    Sorting
    Creating charts
    Using a chart Wizard
    Modifying a chart
    Protecting the worksheet
    Naming cells and cell ranges
    Linking

Creating Hyperlinks
    Inserting hyperlinks
    Other options for specifying a hyperlink
    Editing hyperlinks
Course duration : 8 Hours
9:00 - 17:00

Fees : Rs 3500 per paricipant
Minimum 5 participants.