Academic Tutorials



English | French | Portugese | German | Italian
Home Advertise Payments Recommended Websites Interview Questions FAQs
News Source Codes E-Books Downloads Jobs Web Hosting
Chats

Microsoft Excel
MS Excel Introduction
MS Excel Exploring
MS Excel Copy & Paste
MS Excel Toolbar
MS Excel Formula
MS Excel Chart
MS Excel Template
MS Excel Worksheet
MS Excel Formatting
MS Excel IF Function
MS Excel CHOOSE Fun
MS Excel Pie Chart
MS Excel AND Function
MS Excel MIN Function
MS Excel MAX Function
MS Excel COUNT Fun
MS Excel AVERAGE Fun
MS Excel OR Function
MS Excel RAND function
MS Excel Drop Down List

HTML Tutorials
HTML Tutorial
XHTML Tutorial
CSS Tutorial
TCP/IP Tutorial
CSS 1.0
CSS 2.0
HLML
XML Tutorials
XML Tutorial
XSL Tutorial
XSLT Tutorial
DTD Tutorial
Schema Tutorial
XForms Tutorial
XSL-FO Tutorial
XML DOM Tutorial
XLink Tutorial
XQuery Tutorial
XPath Tutorial
XPointer Tutorial
RDF Tutorial
SOAP Tutorial
WSDL Tutorial
RSS Tutorial
WAP Tutorial
Web Services Tutorial
Browser Scripting
JavaScript Tutorial
VBScript Tutorial
DHTML Tutorial
HTML DOM Tutorial
WMLScript Tutorial
E4X Tutorial
Server Scripting
ASP Tutorial
PERL Tutorial
SQL Tutorial
ADO Tutorial
CVS
Python
Apple Script
PL/SQL Tutorial
SQL Server
PHP
.NET (dotnet)
Microsoft.Net
ASP.Net
.Net Mobile
C# : C Sharp
ADO.NET
VB.NET
VC++
Multimedia
SVG Tutorial
Flash Tutorial
Media Tutorial
SMIL Tutorial
Photoshop Tutorial
Gimp Tutorial
Matlab
Gnuplot Programming
GIF Animation Tutorial
Scientific Visualization Tutorial
Graphics
Web Building
Web Browsers
Web Hosting
W3C Tutorial
Web Building
Web Quality
Web Semantic
Web Careers
Weblogic Tutorial
SEO
Web Site Hosting
Domain Name
Java Tutorials
Java Tutorial
JSP Tutorial
Servlets Tutorial
Struts Tutorial
EJB Tutorial
JMS Tutorial
JMX Tutorial
Eclipse
J2ME
JBOSS
Programming Langauges
C Tutorial
C++ Tutorial
Visual Basic Tutorial
Data Structures Using C
Cobol
Assembly Language
Mainframe
Forth Programming
Lisp Programming
Pascal
Delphi
Fortran
OOPs
Data Warehousing
CGI Programming
Emacs Tutorial
Gnome
ILU
Soft Skills
Communication Skills
Time Management
Project Management
Team Work
Leadership Skills
Corporate Communication
Negotiation Skills
Database Tutorials
Oracle
MySQL
Operating System
BSD
Symbian
Unix
Internet
IP-Masquerading
IPC
MIDI
Software Testing
Testing
Firewalls
SAP Module
ERP
ABAP
Business Warehousing
SAP Basis
Material Management
Sales & Distribution
Human Resource
Netweaver
Customer Relationship Management
Production and Planning
Networking Programming
Corba Tutorial
Networking Tutorial
Microsoft Office
Microsoft Word
Microsoft Outlook
Microsoft PowerPoint
Microsoft Publisher
Microsoft Excel
Microsoft Front Page
Microsoft InfoPath
Microsoft Access
Accounting
Financial Accounting
Managerial Accounting
Network Sites


ms-excel


Previoushome Next






Exploring Microsoft Excel 2003

A D V E R T I S E M E N T

Once the Microsoft Excel is launch, you can directly use it by entering data or you can choose to open the existing Excel file. Below are the step-by-step guides:
To start using Microsoft Excel, you can start with a new blank workbook or open the existing Excel file.
To create a new default workbook

  • Click on the New icon located on the Standard toolbar
    OR press Ctrl+N


    To open a file
  • From the File menu, click Open.
  • From the Open dialog box as displayed, use the Look in: drop down menu to select the drive or folder that contains the file you want.
  • To open the file you can either double-click on the file name
    OR select the file name by clicking on it, and then click on the Open button.

    Microsoft Excel - Data Entry Techniques

    Here is the guide that shows the easy ways that you can use to enter data into the worksheet.

    To fill a range of cells with the same data

  • Highlight the cells you wish to fill.
  • Enter the information that you wish to fill the selected range with.
  • Press Ctrl+Shift+Enter and the range will be filled.

    To fill a range of cells with the 'automatic' data
  • Highlight the cells you wish to fill.
  • Enter the data into the cells as follow: A1: 1; A2: 2
  • Use the mouse to drag from cell A1 to A2.
  • Place your mouse in the bottom right corner of the selected cells until you see the “+” sign appear as follow:

    Fill range selection
  • Click and drag the mouse down the cells as you wish. You will see the selected range will fill with continuous numbers 3, 4, 5, 6,…
    Note: You also can replace the above A1 and A2 cells with days of week such as Monday, Tuesday,... and months like January, February,...

    Microsoft Excel - Navigating in the Worksheet

    How you can move from one place to another in Microsoft Excel? Here is the ways:
    To move to a particular cell (quick way)

  • Enter the cell that you wish to jump to into the Name Box (at the top, left of the screen). In the example shown the cell reference J50 has been entered. When you press the Enter key you will jump to the cell you entered.

    Name box

    To move from cell to cell using the keyboard
  • To move from cell to cell, use one of the following key or combination keys:
    Icon Function
    One cell to the right.
    One cell to the left.
    One cell down.
    One cell up.
    Ctrl + → To the right-hand edge of the current region.
    Ctrl + ← To the left-hand edge of the current region.
    Ctrl + ↓ To the bottom edge of the current region.
    Ctrl + ↑ To the top edge of the current region.
    Home To the first cell in the row.
    Ctrl + Home To the first cell in the worksheet.
    Ctrl + End To the lowest right-hand cell in the worksheet that contains a data entry.
    Page Down One screen down.
    Page Up One screen up.
    Alt + Page Down One screen to the right.
    Alt + Page Up One screen to the left.


    Microsoft Excel - Selection Techniques

    The selection techniques in Microsoft Excel allow you to select or highlight the cell(s) quickly so that you can perform the tasks such as deleting, copying, etc.
    To select a cell

  • Click on the cell you wish to select.
    To select a range of cells by dragging the mouse
  • Click on the first cell in the range.
  • Hold down the left-hand mouse button and drag over the cells you wish to include in the selection.
    To select a range of cells (making up a rectangular block)
  • Click on the first cell of the rectangular block that you wish to select (i.e. the left top-left hand corner)
  • Move down to the cell that marks the bottom-right corner of the rectangular block.
  • Depress the Shift key (and keep it depress).
  • Click once on the last cell of the required block and release the Shift key.

    To select a non-contiguous range
  • Select the first cell or range.
  • While holding down the Ctrl key, select the next range of cells.

    To select a row
  • Click on the row heading number.

    To select a column
  • Click on the column heading letter.

    To select an entire worksheet
  • Press Ctrl+A

    Microsoft Excel - Inserting and Deleting

    Microsoft Excel offers a convenient way for you to either insert or delete cell(s), column(s), row(s), or entire worksheet.
    To insert a row(s) into a worksheet

  • Select the row you want to move down when the new row is inserted above it.
  • To select more than one row, drag the mouse pointer across the required row headings.
  • Right-click on the selected row(s) to display a pop-up menu.
  • Select Insert. Any existing data will move down to accommodate the new cells.

    Insert pop-up


    To insert column(s) into a worksheet

  • Select the column you want to move to the right when the new column is inserted.
  • To select more than one column, drag the mouse pointer across the required column headings.
  • Right-click on the selected column(s) to display a pop-up menu.
  • Select Insert. Any existing data will move down to accommodate the new cells.

    To delete a row or column
  • Use the same techniques outlined above, but select the Delete command from the pop-up menu.

    To insert cells or range of cells
  • Select the cell where you want to insert a new cell.
  • From the Insert menu, click Cells.
  • From the Insert dialog box, select one of the following options:
    Entire column Moves all cells in the column to the right and inserts a new column.
    Entire row Moves all cells in the row down and inserts a new row.
    Shift cells down Moves existing cells down and inserts one cell.
    Shift cells right Moves existing cells to the right and inserts one cell.
  • Click on the OK.

    To delete cells or ranges of cells
  • Select the cell(s) you want to delete.
  • From the Edit menu, click Delete.
  • From the Delete dialog box displayed, select one of the options.
  • Click on the OK button.

    To insert a worksheet
  • Click the sheet tab to select the worksheet where you want to insert a new one. The new worksheet will be inserted before this worksheet.
  • From the Insert menu, click Worksheet.

    To delete a worksheet
  • Click on the sheet tab to select the worksheet you wish to delete.
  • From the Edit menu, click Delete Sheet.
  • Select OK to permanently delete the selected sheet.


  • Be the first one to comment on this page.




      Microsoft Excel eBooks

    No eBooks on Microsoft Excel could be found as of now.

     
     Microsoft Excel FAQs
    More Links » »
     
     Microsoft Excel Interview Questions
    More Links » »
     
     Microsoft Excel Articles

    No Microsoft Excel Articles could be found as of now.

     
     Microsoft Excel News

    No News on Microsoft Excel could be found as of now.

     
     Microsoft Excel Jobs

    No Microsoft Excel Articles could be found as of now.


    Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.
    • blinkbits
    • BlinkList
    • blogmarks
    • co.mments
    • connotea
    • del.icio.us
    • De.lirio.us
    • digg
    • Fark
    • feedmelinks
    • Furl
    • LinkaGoGo
    • Ma.gnolia
    • NewsVine
    • Netvouz
    • RawSugar
    • Reddit
    • scuttle
    • Shadows
    • Simpy
    • Smarking
    • Spurl
    • TailRank
    • Wists
    • YahooMyWeb

    Previoushome Next

    Keywords:

    HTML Quizzes
    HTML Quiz
    XHTML Quiz
    CSS Quiz
    TCP/IP Quiz
    CSS 1.0 Quiz
    CSS 2.0 Quiz
    HLML Quiz
    XML Quizzes
    XML Quiz
    XSL Quiz
    XSLT Quiz
    DTD Quiz
    Schema Quiz
    XForms Quiz
    XSL-FO Quiz
    XML DOM Quiz
    XLink Quiz
    XQuery Quiz
    XPath Quiz
    XPointer Quiz
    RDF Quiz
    SOAP Quiz
    WSDL Quiz
    RSS Quiz
    WAP Quiz
    Web Services Quiz
    Browser Scripting Quizzes
    JavaScript Quiz
    VBScript Quiz
    DHTML Quiz
    HTML DOM Quiz
    WMLScript Quiz
    E4X Quiz
    Server Scripting Quizzes
    ASP Quiz
    PERL Quiz
    SQL Quiz
    ADO Quiz
    CVS Quiz
    Python Quiz
    Apple Script Quiz
    PL/SQL Quiz
    SQL Server Quiz
    PHP Quiz
    .NET (dotnet) Quizzes
    Microsoft.Net Quiz
    ASP.Net Quiz
    .Net Mobile Quiz
    C# : C Sharp Quiz
    ADO.NET Quiz
    VB.NET Quiz
    VC++ Quiz
    Multimedia Quizzes
    SVG Quiz
    Flash Quiz
    Media Quiz
    SMIL Quiz
    Photoshop Quiz
    Gimp Quiz
    Matlab Quiz
    Gnuplot Programming Quiz
    GIF Animation Quiz
    Scientific Visualization Quiz
    Graphics Quiz
    Web Building Quizzes
    Web Browsers Quiz
    Web Hosting Quiz
    W3C Quiz
    Web Building Quiz
    Web Quality Quiz
    Web Semantic Quiz
    Web Careers Quiz
    Weblogic Quiz
    SEO Quiz
    Web Site Hosting Quiz
    Domain Name Quiz
    Java Quizzes
    Java Quiz
    JSP Quiz
    Servlets Quiz
    Struts Quiz
    EJB Quiz
    JMS Quiz
    JMX Quiz
    Eclipse Quiz
    J2ME Quiz
    JBOSS Quiz
    Programming Langauges Quizzes
    C Quiz
    C++ Quiz
    Visual Basic Quiz
    Data Structures Using C Quiz
    Cobol Quiz
    Assembly Language Quiz
    Mainframe Quiz
    Forth Programming Quiz
    Lisp Programming Quiz
    Pascal Quiz
    Delphi Quiz
    Fortran Quiz
    OOPs Quiz
    Data Warehousing Quiz
    CGI Programming Quiz
    Emacs Quiz
    Gnome Quiz
    ILU Quiz
    Soft Skills Quizzes
    Communication Skills Quiz
    Time Management Quiz
    Project Management Quiz
    Team Work Quiz
    Leadership Skills Quiz
    Corporate Communication Quiz
    Negotiation Skills Quiz
    Database Quizzes
    Oracle Quiz
    MySQL Quiz
    Operating System Quizzes
    BSD Quiz
    Symbian Quiz
    Unix Quiz
    Internet Quiz
    IP-Masquerading Quiz
    IPC Quiz
    MIDI Quiz
    Software Testing Quizzes
    Testing Quiz
    Firewalls Quiz
    SAP Module Quizzes
    ERP Quiz
    ABAP Quiz
    Business Warehousing Quiz
    SAP Basis Quiz
    Material Management Quiz
    Sales & Distribution Quiz
    Human Resource Quiz
    Netweaver Quiz
    Customer Relationship Management Quiz
    Production and Planning Quiz
    Networking Programming Quizzes
    Corba Quiz
    Networking Quiz
    Microsoft Office Quizzes
    Microsoft Word Quiz
    Microsoft Outlook Quiz
    Microsoft PowerPoint Quiz
    Microsoft Publisher Quiz
    Microsoft Excel Quiz
    Microsoft Front Page Quiz
    Microsoft InfoPath Quiz
    Microsoft Access Quiz
    Accounting Quizzes
    Financial Accounting Quiz
    Managerial Accounting Quiz
    Testimonials | Contact Us | Link to Us | Site Map
    Copyright ? 2008. Academic Tutorials.com. All rights reserved Privacy Policies | About Us
    Our Portals : Academic Tutorials | Best eBooksworld | Beyond Stats | City Details | Interview Questions | Discussions World | Excellent Mobiles | Free Bangalore | Give Me The Code | Gog Logo | Indian Free Ads | Jobs Assist | New Interview Questions | One Stop FAQs | One Stop GATE | One Stop GRE | One Stop IAS | One Stop MBA | One Stop SAP | One Stop Testing | Webhosting in India | Dedicated Server in India | Sirf Dosti | Source Codes World | Tasty Food | Tech Archive | Testing Interview Questions | Tests World | The Galz | Top Masala | Vyom | Vyom eBooks | Vyom International | Vyom Links | Vyoms | Vyom World | Important Websites
    Copyright ? 2003-2024 Vyom Technosoft Pvt. Ltd., All Rights Reserved.