Excel 2003 – Tutorial I

Spreadsheet Basics Tutorials

Microsoft Excel is a spreadsheet program that you can use to organize, analyze and attractively present data such as a budget or sales report. Each Excel file is a workbook that can hold many worksheets. The worksheet is a grid of columns, designated by letters, and rows, designated by numbers. The letters and numbers of the columns and row called labels are displayed in gray buttons across the top and left side of the worksheet. The intersection of a column and a row is called a cell. Each cell on the spreadsheet has a cell address that is the column letter and the row number. Cells can contain text, numbers, or mathematical formulas.

Spreadsheet Basics

• Screen Layout
• Title bar
• Menu bar
• Standard Toolbar
• Other Tools
• Task Pane
• Adding and Renaming Worksheets

Modifying Worksheets

• Moving Through Cells
• Adding Worksheets, Rows, Columns, and Cells
• Resizing Rows and Columns
• Selecting Cells
• Moving and Copying Cells
• Deleting Rows, Columns and Cells
• Freeze Panes

Formatting Cells

• Formatting Toolbar
• Format Cells Dialog Box
• Formatting Worksheet
• Dates and Times
• Format Painter
• AutoFormat

Formulas and Functions

• Formulas
• Linking Worksheets
• Relative, Absolute, and Mixed
• Referencing
• Basic Functions
• AutoSum

Sorting and Filling

• Basic Sorts
• Complex Sorts
• Auto-fill

Comparing Workbooks

• Compare Side by Side

Page Properties and Printing

• Page Breaks
• Page Setup
• Margins
• Header/Footer
• Sheet
• Print Preview
• Print

Read more and download

Microsoft Excel Tutorial

Introduction to Excel
Excel allows you to create spreadsheets that can perform automatic calculations. Each Excel file is a workbook that can hold many worksheets. The worksheet is a grid of columns (letters) and rows (numbers).

Adding Worksheets, Rows, and Columns
Worksheets - Add a worksheet to a workbook by selecting Insert|Worksheet from the menu bar. To rename the worksheet tab, right-click on the tab with the mouse and select Rename from the shortcut menu. Type the new name and press the ENTER key. Row - To add a row to a worksheet, select Insert|Rows from the menu bar, or highlight the row by clicking on the row label, right-click with the mouse, and choose Insert.
Column - Add a column by selecting Insert|Columns from the menu bar, or highlight the column by click on the column label, right-click with the mouse, and choose Insert.

Resizing Rows and Columns
There are two ways to resize rows and columns. To resize a row individually drag the line below the label of the row you would like to resize. You can resize a column in a similar manner by dragging the line to the right of the label corresponding to the column you want to resize.

Read More and Download

JSP Tutorial

This is a tutorial to help a developer understand what is meant by JavaServer Pages (JSP). The reader will learn the main concepts, setup the JSP environment on their computer and write a few JSP programs.

JavaServer Pages (JSP) is a technology based on the Java language and enables the development of dynamic web sites. JSP was developed by Sun Microsystems to allow server side development. JSP files are HTML files with special Tags containing Java source code that provide the dynamic content. The following shows the Typical Web server, different clients connecting via the Internet to a Web server. In this example, the Web server is running on Unix and is the very popular Apache Web server.

First static web pages were displayed. Typically these were people’s first experience with making web pages so consisted of My Home Page sites and company marketing information. Afterwards Perl and C were languages used on the web server to provide dynamic content. Soon most languages including Visualbasic, Delphi, C++ and Java could be used to write applications that provided dynamic content using data from text files or database requests. These were known as CGI server side applications. ASP was developed by Microsoft to allow HTML developers to easily provide dynamic content supported as standard by Microsoft’s free Web Server, Internet Information Server (IIS). JSP is the equivalent from Sun Microsystems, a comparison of ASP and JSP will be presented in the following section.

Why use JSP?
JSP is easy to learn and allows developers to quickly produce web sites and applications in an open and standard way. JSP is based on Java, an object- oriented language. JSP offers a robust platform for web development.

Main reasons to use JSP:
1. Multi platform
2. Component reuse by using Javabeans and EJB.
3. Advantages of Java.
You can take one JSP file and move it to another platform, web server or JSP Servlet engine.

Download

JavaServer Pages (JSP) Tutorials

This is a tutorial to help a developer understand what is meant by JavaServer Pages (JSP). The reader will learn the main concepts, setup the JSP environment on their computer and write a few JSP programs.

JavaServer Pages (JSP) is a technology based on the Java language and enables the development of dynamic web sites. JSP was developed by Sun Microsystems to allow server side development. JSP files are HTML files with special Tags containing Java source code that provide the dynamic content. The following shows the Typical Web server, different clients connecting via the Internet to a Web server. In this example, the Web server is running on Unix and is the very popular Apache Web server.

First static web pages were displayed. Typically these were people’s first experience with making web pages so consisted of My Home Page sites and company marketing information. Afterwards Perl and C were languages used on the web server to provide dynamic content. Soon most languages including Visualbasic, Delphi, C++ and Java could be used to write applications that provided dynamic content using data from text files or database requests. These were known as CGI server side applications. ASP was developed by Microsoft to allow HTML developers to easily provide dynamic content supported as standard by Microsoft’s free Web Server, Internet Information Server (IIS). JSP is the equivalent from Sun Microsystems, a comparison of ASP and JSP will be presented in the following section.

Why use JSP?
JSP is easy to learn and allows developers to quickly produce web sites and applications in an open and standard way. JSP is based on Java, an object- oriented language. JSP offers a robust platform for web development.
Main reasons to use JSP:
1. Multi platform
2. Component reuse by using Javabeans and EJB.
3. Advantages of Java.
You can take one JSP file and move it to another platform, web server or JSP Servlet engine

Download

Java Programming for Wireless devices using Java 2 Platform Micro Edition (J2ME)

What is a J2ME Configuration?

A configuration defines the minimum Java™ technology that can be expected to be available on implementing devices Broad range of devices Similar requirements for memory size and processing capabilities Configurations are specified via the Java Community Process Implementations are tested via a compatibility test kit (TCK)

J2ME Configurations
J2ME Connected, Limited Device Configuration (CLDC) Specifies Java environment for mobile phone, pager, and PDA class devices CLDC devices are usually wireless J2ME Connected Device Configuration (CDC) Specifies Java environment for digital television settop boxes, high end wireless devices, and automotive telematics systems. CDC devices may be wired (DTV cable, etc.)

What Is a J2ME Profile?
Java™ technology which supplements a Configuration to provide capabilities for a specific vertical market or device type Defined through Java Community Process initiative Subject to compatibility tests

J2ME Profiles

• Mobile Information Device Profile (MIDP)
• Profile for wireless devices implementing CLDC
• J2ME Foundation Profile
• Profile for non-GUI networked devices implementing
• CDC
• J2ME Personal Basis, Personal, RMI Profiles
• Basic graphics, next generation PersonalJava environment, and RMI support for CDC &
• Foundation Profile based devices

Download

MIDlet development with J2ME and MIDP

Why J2ME?
Nokia, the dominant player in the mobile phone market, has estimated that in 2002 it will sell over 50 million J2ME-enabled mobile phones. With lofty numbers announced by other mobile phone manufacturers as well, there is a flood of interest in software development revolving around J2ME (Java 2 Micro Edition). J2ME is a slimmed-down version of Java targeted at devices that have limited memory, display, and processing power.

This tutorial provides a step-by-step introduction to downloading, installing, and configuring your computer to begin development of applications for this runtime environment. There will be a specific focus on application development for mobile devices using an application programming interface (API) known as the Mobile Information Device Profile (MIDP). Applications written for this API are affectionately referred to as MIDlets.

Download MIDlet development with J2ME and MIDP