tuitorial excel bisa di download disini
Excel 2007 offers a wide range of customizable options that allow you to make Excel work the best for you. To access these customizable options:
- Click the Office Button
- Click Excel Options
These features allow you to personalize your work environment with the mini toolbar, color schemes, default options for new workbooks, customize sort and fill sequences user name and allow you to access the Live Preview feature. The Live Preview feature allows you to preview the results of applying design and formatting changes without actually applying it.
This feature allows you to modify calculation options, working with formulas, error checking, and error checking rules.
This feature allows you personalize how word corrects and formats your text. You can customize auto correction settings and have word ignore certain words or errors in a document through the Custom Dictionaries.
This feature allows you personalize how your workbook is saved. You can specify how often you want auto save to run and where you want the workbooks saved.
This feature allows you to specify options for editing, copying, pasting, printing, displaying, formulas, calculations, and other general settings.
Customize allows you to add features to the Quick Access Toolbar. If there are tools that you are utilizing frequently, you may want to add these to the Quick Access Toolbar.
etting started with Excel 2007 you will notice that there are many similar features to previous versions. You will also notice that there are many new features that you’ll be able to utilize. There are three features that you should remember as you work within Excel 2007: the Microsoft Office Button, the Quick Access Toolbar, and the Ribbon. The function of these features will be more fully explored below.
A spreadsheet is an electronic document that stores various types of data. There are vertical columns and horizontal rows. A cell is where the column and row intersect. A cell can contain data and can be used in calculations of data within the spreadsheet. An Excel spreadsheet can contain workbooks and worksheets. The workbook is the holder for related worksheets.
Microsoft Office Button
The Microsoft Office Button performs many of the functions that were located in the File menu of older versions of Excel. This button allows you to create a new workbook, Open an existing workbook, save and save as, print, send, or close.
The ribbon is the panel at the top portion of the document It has seven tabs: Home, Insert, Page Layouts, Formulas, Data, Review, and View. Each tab is divided into groups. The groups are logical collections of features designed to perform function that you will utilize in developing or editing your Excel spreadsheets.
Commonly utilized features are displayed on the Ribbon. To view additional features within each group, click the arrow at the bottom right corner of each group.
Home: Clipboard, Fonts, Alignment, Number, Styles, Cells, Editing
Insert: Tables, Illustrations, Charts, Links, Text
Page Layouts: Themes, Page Setup, Scale to Fit, Sheet Options, Arrange
Formulas: Function Library, Defined Names, Formula Auditing, Calculation
Data: Get External Data, Connections, Sort & Filter, Data Tools, Outline
Review: Proofing, Comments, Changes
View: Workbook Views, Show/Hide, Zoom, Window, Macros
Quick Access Toolbar
The quick access toolbar is a customizable toolbar that contains commands that you may want to use. You can place the quick access toolbar above or below the ribbon. To change the location of the quick access toolbar, click on the arrow at the end of the toolbar and click Show Below the Ribbon.
ou can also add items to the quick access toolbar. Right click on any item in the Office Button or the Ribbon and click Add to Quick Access Toolbar and a shortcut will be added.
A new feature in Office 2007 is the Mini Toolbar. This is a floating toolbar that is displayed when you select text or right-click text. It displays common formatting tools, such as Bold, Italics, Fonts, Font Size and Font Color.
Microsoft Excel is allows you to create professional spreadsheets and charts. It performs numerous functions and formulas to assist you in your projects. This tutorial will help you get started with Microsoft Excel and may solve some of your problems, but it is a very good idea to use the Help Files that come with Microsoft Excel , or go to Microsoft’s web site located at http://microsoft.com/office/excel/default.htm for further assistance. Back to top
Starting Microsoft Excel
# Two Ways
1. Double click on the Microsoft Excel icon on the desktop.
# Click on Start –> Programs –> Microsoft Excel
Back to top
1. Click the cell that you want to enter the formula.
2. Type = (an equal sign).
3. Click the Function Button
4. Select the formula you want and step through the on-screen instructions
Adding Borders and Shading to Cells
# Make sure you have the Formatting toolbar visible
* Click on View –> Toolbars –> Formatting
# Select cells you wish to format by left clicking on them and highlighting them
# Click the
button to shade a cell and/or the
to give a cell a border
Inserting A Chart
1.Select over the text you want to make your chart with
2. Click Insert –> Chart
3.Select the type of chart you want
4.Confirm or change your data range
5. Update the Chart Options
Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!