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

Computer Courses

Miscellaneous Courses

Excel 2007



MSExcel2007 Microsoft Excel 2007 is the newest version of Microsoft Office's worksheet program. Technically a worksheet is a single document inside a workbook but we often use the terms worksheet, spreadsheet and workbook interchangeably.

With Excel 2007 you can analyse, manage and share information quickly and easily to make more informed decisions.

Like Microsoft Word 2007, Excel 2007 takes advantage of a new, results-oriented user interface to make powerful productivity tools easily accessible. If you're worried about capacity, Excel 2007 now accommodates 1 million rows and 16,000 columns.
Office 2007 requires Windows XP with Service Pack 2 or higher, Windows Server 2003 with Service Pack 1 or higher, Windows Vista or Windows 7. Office 2007 is the last version of Microsoft Office available for Windows XP Professional .


Contents :-

  • Excel 2007

    What is Excel 2007?

    Introduction
    What’s New in Excel 2007?
    How to Start Excel 2007
    Application Window of Excel 2007
    Excel Help

    A First Look at Excel 2007

    Excel 2007 Buttons
    Quick Access Toolbar
    Ribbon in Excel 2007
    What is Worksheet?
    Formula Bar in Excel2007
    Status Bar in Excel2007

    Move around a worksheet

    Excel Rows,Columns,Cells

    Make a Start with Excel

    Starting a Work Book
    Create a Work Book
    Save a Work Book
    Open a Work Book
    Enter Text & Number in a Cell
    How to edit text in a cell
    How to Centre Text & Numbers

    Modifying a Worksheet

    Insert new Rows,Columns,Cells
    Delete existing Cells
    Find & Replace your Text

    Formatting Data in Excel-2007

    Change Font Style, Size & Color
    Align Cell Entries
    Create Borders
    Add Background Color
    Adding a comment to a cell

    Formulas in Excel 2007

    Formula for Addition
    Formula for Subtraction
    Formula for Multiplication
    Formula for Division
    Autosum
    Combining the Arithmetic Operators

    Functions in Excel 2007

    The Sum Function in Excel 2007
    The Average Function in Excel 2007
    The Date Function
    Time Functions in Excel 2007

    Charts in Excel 2007

    Create a Chart
    Move & Resize your Chart
    Modify a Chart
    Chart Styles & Layouts

    How to Use Graphics in Excel 2007

    Insert Image from File
    Edit your Pictures & Clipart
    Adding Shapes
    Insert Smart Art

    Sort & Filter

    Basic Sorts
    Custom Sorts
    Filter

    Macros in Excel 2007

    Recording a Macro?
    Running a macro?
    Deleting a Macro

    Page Properties

    Set Page Margins
    Page Orientation
    Page Header & Footer
    Set Page Breaks

    Printing a Worksheet

    Print Preview
    Print Properties
    Print worksheet

    Customize the Layout

    Split a Worksheet
    Freeze & Unfreeze Rows & Columns
    Hide & Unhide Worksheets

    Advance Features in excel 2007

    Drop Down List
    Error Message
    Hyperlink
    Data Validation

    Importing External Data

    From Access
    From Web
    From Text

    Keyboard Shortcuts for Excel-2007

    Know the Various Keyboard Shortcuts

Next Page.....

Tags- How do you do MS Excel? | What is basic Excel? | What are the main features of MS Excel? | What is Microsoft Office Excel 2007? | What is a simple formula in Excel? | What can excel be used for? | How do you use Excel in life? | What are formulas in Excel? | How do you excel at work? | How do you use Microsoft Excel to calculate? | How many rows and columns are there in Excel? | How do you use formulas in Excel? | What is Excel and what does it do? | How can I learn Excel? | Can you get Excel free? | What are the formulas in Excel? | What are the advantages of MS Excel? | How do I open Microsoft Excel? | What is spreadsheet in Excel? | What is worksheet in Excel? | Who created Excel? | What is MS Excel explain? | What is the work of Excel in computer? | What is an Excel spreadsheet? | Is a spreadsheet? | What is use of pivot table in Excel? | What is cell in Excel? | What is Vlookup in Excel? | What type of software program is Microsoft Office Access? | What does mean in Excel? | How do you use formulas in Microsoft Excel? | What is workbook in Excel? | What is the purpose of Microsoft Office? | What is Microsoft Office Outlook? | What is the Microsoft? | What is Microsoft Access used for? | How can I use the Excel? | What are the features of MS Excel? | What is Microsoft Office Power Point? | What are the uses of MS Excel? | What is excel in computer? | How do you do graphs on Excel? | What is Excel formula? | What is the power point? | What is MS Word in computer? | How many rows and columns are there in Excel? | What is the function of ribbon in computer? | What type of program is Microsoft Powerpoint? | What is Excel and what does it do? | How can I learn Excel? | Can you get Excel free? | What are the formulas in Excel? | What are the advantages of MS Excel? | How do I open Microsoft Excel? | What is spreadsheet in Excel? | What is worksheet in Excel? | Who created Excel? | What is MS Excel explain? | What is the work of Excel in computer? | How do I use Excel formulas? | What is an Excel spreadsheet? | Is a spreadsheet? | What is use of pivot table in Excel? | What is cell in Excel? | What is Vlookup in Excel? | What type of software program is Microsoft Office Access? | What does mean in Excel? | How do you use formulas in Microsoft Excel? | What is workbook in Excel? | What is the purpose of Microsoft Office? | What is Microsoft Office Outlook? | What is the Microsoft? | How can I use the Excel? | What are the features of MS Excel? | What is Microsoft Access used for? | What are the uses of MS Excel? | What is excel in computer? | What is Microsoft Office Power Point? | What is Excel formula? | How many rows and columns are there in Excel? | How do you do graphs on Excel? | What is the power point? | What is MS Word in computer? | What is the function of ribbon in computer? | What is Excel and what does it do? | How can I learn Excel? | Can you get Excel free? | What are the formulas in Excel? | What are the advantages of MS Excel? | What type of program is Microsoft Powerpoint? | How do I open Microsoft Excel? | What is spreadsheet in Excel? | What is worksheet in Excel? | Who created Excel? | What is MS Excel explain? | What is the work of Excel in computer? | How do I use Excel formulas? | What is an Excel spreadsheet? | Is a spreadsheet? | What is use of pivot table in Excel? | What is cell in Excel? | What is Vlookup in Excel? | What type of software program is Microsoft Office Access? | What does mean in Excel? | How do you use formulas in Microsoft Excel? | What is workbook in Excel? | What is the purpose of Microsoft Office? | What is Microsoft Office Outlook? | How can I use the Excel? | What are the features of MS Excel? | What is the Microsoft? | What are the uses of MS Excel? | What is excel in computer? | What is Microsoft Access used for? | What is Excel formula? | How many rows and columns are there in Excel? | What is Microsoft Office Power Point? | How do you do graphs on Excel? | What is the power point? | What is MS Word in computer? | What is Excel and what does it do? | How can I learn Excel? | Can you get Excel free? | What are the formulas in Excel? | What are the advantages of MS Excel? | What is the function of ribbon in computer? | How do I open Microsoft Excel? | What is spreadsheet in Excel? | What is worksheet in 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