हिंदी में देखें |

Computer Courses

Miscellaneous Courses

MS Excel



MSExcel Microsoft Excel is a Spreadsheet software developed by Microsoft. Spreadsheets are a great tool for doing math related jobs. Excel is widely used for small scale accounting related work.

Spreadsheet software is used to store information in columns and rows which can then be organized and/or processed. Spreadsheets are designed to work well with numbers but often include text. Sometimes text in a spreadsheet is called a label, because it is labeling columns and rows of numbers.

Numbers are called values sometimes, and can include numbers for counts or measurements, dates, times, and calculations from numbers. Spreadsheets can help organize information, like alphabetizing a list of names or other text or reordering records according to a numeric field.
It is impossible to give a complete listing of applications that can be done in spreadsheets, but they include budgeting displays, checkbook registers, enrollment records, inventories, coded surveys, field and laboratory research data, and financial and accounting applications.


Contents :-

  • MS Excel

    Introduction to MS-Excel

    Introduction
    Features of MS-Excel
    Starting MS-Excel
    MS-Excel Application Window

    Excel Basics

    Creating & saving a Workbook
    Rows, Columns and Cells
    Entering Data
    Creating List using Auto-fill
    Custom Lists
    Using Formula in Excel
    Moving & Copying Text
    Using Cell Reference in Formula
    Types of Cell Referencing

    Navigating & Searching a Worksheet

    Navigation using Keyboard
    Using Go To for Navigation
    Searching a Worksheet
    Using Find & Replace

    Editing a Worksheet

    Inserting a Worksheet
    Renaming a Worksheet
    Removing a Worksheet
    Inserting Row and Column
    Resizing Rows and Columns

    Inserting Graphics

    Insert Picture from Clipart
    Insert Picture from File
    Insert WordArt
    Insert Auto Shape

    Printing a Worksheet

    Using Page Setup
    Setting Print Area
    Adding Header & Footer
    Print Previewing a Worksheet
    Print a Worksheet

    Cell Formatting

    Formatting Toolbar
    Number Formatting
    Text Alignment
    Font
    Border & Shading
    Auto Formatting a Worksheet
    Using Conditional Formatting
    Format Painter

    Formula & Functions

    Mathematical Functions
    Financial Functions
    Date & Time Functions
    Text Functions
    Statistical Functions

    Pivot Table and Chart

    What is Pivot Table?
    Creating a Pivot Table Report
    What is Chart?
    Creating a Chart in MS-Excel

    MACRO

    What is Macro?
    Recording a Macro
    Running a Macro
    Deleting a Macro

    Forms

    Creating and using Forms

    Validation

    What is Validation?
    How to Use Data Validation in Excel?

    Importing External Data

    Data Source
    Importing External Data

    Must Read

    Keyboard Shortcut

Next Page.....

Tags- What about MS Excel? | What is basic Excel? | What are the main features of MS Excel? | How do I use Excel spreadsheet? | What are the uses of MS Excel? | What are the advantages of MS Excel? | What is the function of MS Excel? | What is MS Excel explain? | How many rows and columns in MS Excel? | What is meant by MS Excel? | What is cell in MS Excel? | Who invented MS Excel? | What is Excel and what does it do? | How can I learn Excel? | How do you excel at work? | What jobs are most likely to require Excel? | Why is Excel so important? | Why do teachers use Excel? | How do you use Excel? | What is the use of MS Office? | What are the main uses of a spreadsheet? | What is MS Excel used for in business? | What are the uses of power point? | What is MS Word and its uses? | What are the functions in Excel? | What are the uses of MS Access? | How do I open Microsoft Excel? | What is the use of MS Access? | What is spreadsheet and its applications? | What is a spreadsheet used for? | What is an Excel spreadsheet? | What is Microsoft Publisher used for? | What is Microsoft Office Word used for? | What is the use of Microsoft Powerpoint? | What is word used for? | What is the purpose of Microsoft Access? | What are the features of MS Excel? | What is the purpose of Microsoft Powerpoint? | What is the purpose of Microsoft Word? | What are the uses of MS Excel? | What are the advantages of MS Excel? | What is the function of the MS Excel? | What is MS Excel explain? | What is meant by MS Excel? | Can you get Excel free? | What is Excel and what does it do? | What is cell in MS Excel? | Who invented MS Excel?



UpImage
Home|Indian Doctors|Indian Hospitals|Utility|Career|Electronics|Family|General|Health|PC Tips|Technology|About Us|About Admin|Feedback|Apply For Job Computer Courses|Login| Created by - Er. Sanjay Singh