Affiliates

Amazon.com


Popular Microsoft Excel Books

Excel 2003 Bible
Excel 2003 Bible
Author: John Walkenbach 

Excel 2003 for Dummies
Excel 2003 for Dummies
Author: Greg, PhD Harvey 

Microsoft Office Excel 2003 Step by Step
Microsoft Office Excel 2003 Step by Step
Author: Curtis Frye 

Excel VBA Programming For Dummies
Excel VBA Programming For Dummies
Author: John Walkenbach 

Excel 2003 Personal Trainer
Excel 2003 Personal Trainer
Author: Inc 

Microsoft Office Excel 2003 Inside Out
Microsoft Office Excel 2003 Inside Out
Author: Craig Stinson 

Excel 2003 All-in-One Desk Reference for Dummies
Excel 2003 All-in-One Desk Reference for Dummies
Author: Greg Harvey 

Popular MS Excel Related Websites

Microsoft Corporation 













Microsoft Excel 2007 Tutorial for beginners    

Welcome to MS Tips and Tricks
Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories - Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,

  Microsoft Excel Tips and Tricks for beginners
Create Excel 2007 Files {Tutorial for beginners}  
 
Written by Upendra Kumar  
Saturday, 07 July 2007
Category MS Excel 2007 - Misc.  
 
General Information
 
 
Opening Excel
Create a database from a template
Creating a new WorkBook
Working with cells
Keyboard abbreviated methods
 
 
Microsoft Office Excel 2007 is an effective tool that can use to create and to apply format to spreadsheets, and to analyze and to share information to make decisions better founded. 
 
Office Excel 2007 takes advantage of its new user interface oriented to the results to facilitate the access to effective productivity tools. Also it offers more space to work and a faster operation. 
 
Opening Excel
 
1) Click on the Start button. Then select Programs >> Microsoft Office >> Microsoft Office Excel 2007 menu item.
 
2) A new blank workbook, Book1, will be displayed.
 
Illustration 1: Excel empty workbook.  Click here to view larger image.
 
3) Upper the grid area, you will see the columns, named with letters from A.
 
4) A t the left area, you will see the rows numbers. Then, cells are referenced by their column name and row number. As you can see in the above image, the cursor is positioned at cell D8.
 
5) The Options Tape extends throughout the superior part of Excel and their related commands are organized in groups. Each group is related to a specific work that the people can make in Excel.
 
Illustration 2: Options Tape and Groups.  Click here to view larger image.
 
6) In order to see the different commands in each group, you must click in groups located in the superior part of the tape of options. The card Home, that is the first card beginning by the left, contains the habitual commands that people use more frequently.
 
7) The commands are organized in small related groups. For example, the commands to edit cells are in the group Font, and the commands to work with cells are in the group Cells.
 
Illustration 3: Commands related to a group.
 
8) The first book opened is denominated Book1. This title appears in the bar at upper side of the window until the book is saved with a new name. Each new book has three sheets, like the pages of a document. Within the sheets you can specify data. Sometimes the sheets receive the name of spreadsheets. It is recommended to change the sheet's name to more easily identify the information contained in each one.
 
Illustration 4: Book sheets.
 
Creating a new WorkBook
 

 
Advertisement



Advertisement



Copyright MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster