Sunday, February 14, 2010

Excel 2003 Tutorials from Kansas University

Here are 4 illustrated Excel 2003 Tutorials from Kansas University that demonstrate how use use many important features of Excel. These tutorials take you step-by-step through each task being taught using screen shots and easy-to-follow instructions.

Excel Introduction Tutorial

This introductory Excel tutorial will get you going with using Excel to perform fundamental tasks, such as creating, saving, and opening new Excel workbooks and worksheets; selecting, copying, and moving data; constructing formulas; formatting worksheets; and setting up worksheets for printing. (22 pages, 424kb, pdf format)

After using this Excel tutorial, you will be able to:
- Create, open, and save Excel workbooks
- Select, copy, and move data
- Create formulas using relative and absolute references
- Format worksheets
- Use Page Setup to set up worksheets for printing


Contents of Excel Introduction Tutorial:
Introduction
Objectives
Definitions
Creating and Opening Excel Workbooks
Inside an Excel Worksheet
Creating Formulas
Editing & Deleting Formulas
Copying Formulas and Values
Changing the Workbook or Worksheet Appearance
Getting Additional Help

Excel Data Management Tutorial

This Excel 2003 tutorial describes you how to use Excel to work with lists, data forms, filtering, and subtotals features, along with managing windows and link to data and formulas. (18 pages, 267kb, pdf format)

After using this Excel tutorial, you should be able to:
- Sort a data list
- Filter a data list according to criteria
- Extract data list information
- Use the subtotal function
- Adjust the spreadsheet windows

Contents of Excel Data Management Tutorial:

Introduction
Objectives
Using Excel lists
Creating a List
Sorting
To perform a Simple Sort
To Sort by Multiple Columns
Data Forms
Adding Data Using the Data Form
Finding Records Using Criteria
Filtering Data
AutoFilter
Advanced Filters
Special Features for Filtered Lists
Totals and Subtotals
Total Row
Subtotals
Managing Windows
Multiple Windows
Splitting Windows
Freezing Panes
Linking Data
Getting Additional Help


Excel Tutorial on Functions and Data Analysis Tools

This Excel 2003 tutorial will show you how to use Excel’s functions and data analysis tools. Topics explained include functions such as Average and Sum, and data analysis tools such as pivot tables and conditional summations. (19 pages, 371kb, pdf format)

After reading and applying this Excel tutorial, you will be able to:
- Define terms related to using functions
- Create and edit a function
- Identify add-in functions
- Perform data analysis using Data Analysis Tools
- Create a formula with the Conditional Sum wizard
- Learn to troubleshoot a formula

Contents of Excel Tutorial on Functions and Data Analysis Tools:

Introduction
Objectives
Definitions
Inserting Functions
Sample Functions
Add-In Commands and Functions
Loading an Add-In
Unloading an Add-In
Data Analysis Tools
Histogram
Conditional Sum
Analyzing Data with the PivotTable
Array Formulas
Getting Additional Help


Excel Charting Tutorial

Learn how to use Excel to create and edit charts, modify chart options, and format chart objects, as well as use trendlines, forecasts, and error bars to present data graphically. (17 pages, 361kb, pdf format)

You will be able to do the following after going through this Excel tutorial:
- Create and edit charts
- Modify chart options
- Format chart objects
- Apply trendlines and error bars

Contents of Excel Charting Tutorial:

Introduction
Objectives
Definitions
Creating a Chart
Using the Chart Wizard
Modifying Charts
Formatting Chart Objects
Trendlines
Pie Charts
Creating a Pie Chart
Printing Charts
Printing an Embedded Chart on a Separate Page
Getting Additional Help

Entering Formula – Memasukkan Rumus

Excel tidak memerlukan perintah khusus dalam memasukkan rumus. Yang selalu diperlukan dalam dalam hal ini adalah tanda sama dengan (=). Semua rumus harus dimulai dengan tanda sama dengan ini


Walaupun excel menampilkan seluruh rumus di formula bar dengan huruf besar semua, akan tetapi excel tidak memerlukan rumus yang ditulis dengan huruf besar semua, jadi cukup masukan rumus dengan huruf kecil semua atau huruf besar semua dan bahkan kombinasi huruf besar dan kecil..


Semua rumus dalam excel (sum, average, etc.) menempatkan sel data dalam tanda kurung. Sebagai contoh

=sum (a1:a5) benar,
=sum a1:a5 salah.


Entering Excel Formulas
Excel has no special requirements when it comes to entering formulas. The one always necessary item is the equal sign (=). All formulas must begin with an equal sign.


Although Excel will display all formulas in uppercase in the Formula Bar, Excel doesn’t care about the case at all. When you enter formulas, you can save yourself some trouble by just entering them in lowercase.


All formulas (sum, average, etc.) place data cells in parentheses. For example

=sum (a1:a5) works, but

=sum a1:a5 won’t work.

Clear Excel Formatting – Menghapus Format Sel


How To Clear Excel Formatting

If you have modified the cell formats in a range of cells, and now need to get back to the original formatting without losing data, select the cells you want to clear and choose Edit/Clear/Formats. Doing so will take you back to the default format and will leave your data intact.

Menghapus format sel dalam Excel

Jka kita memodifikasi format sel atau beberapa sel, kemudian kita ingin mengembalikan ke format aslinya tapi tidak menghapus datanya, maka kita dapat melakukan hal tersebut dengan perintah Edit/Clear/Formats. Dengan demikian kta akan mendapatkan kembali format awal dengan tetap memiliki data yang telah diketikan di dalam sel maupun beberapa sel

Buat Grafik Excel – A Default Excel Chart

The easiest and quickest way to create a chart in Excel is to highlight the cell range you want to include in the chart and press F11. This creates the default column chart. Excel will create the chart on a separate Chart sheet.
To test this, type data into cells A1 through C3 and then select the range and press F11.


Pembuatan Grafik deng Excel


Cara paling cepat dan mudah dalam membuat grafik di Excel adalah dengan cara memilih range sel yang datanya akan dimasukkan ke dalam grafik kemudian tekan F11. Untuk mencobanya, maka masukan data ke sel A1 s/d C3 dan kemudian pilih range tersebut dan selanjutnya tekan F11.