Scribd
Upload
127 views20 pages

Excel Basics for Beginners Guide

The document provides an overview of basic Microsoft Excel functions. It explains how to create a new spreadsheet and workbook, enter data into cells, insert columns and rows, use formulas to calculate values, and print worksheets. Key topics covered include getting started with Excel, entering numbers and text into cells, using formulas with functions like SUM and AVERAGE, and setting print options like page orientation and order.

Uploaded by

amol_humane
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
127 views20 pages

Excel Basics for Beginners Guide

The document provides an overview of basic Microsoft Excel functions. It explains how to create a new spreadsheet and workbook, enter data into cells, insert columns and rows, use formulas to calculate values, and print worksheets. Key topics covered include getting started with Excel, entering numbers and text into cells, using formulas with functions like SUM and AVERAGE, and setting print options like page orientation and order.

Uploaded by

amol_humane
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
  • Introduction to Microsoft Excel
  • Getting Started with Excel
  • Creating a New Spreadsheet
  • Columns, Rows, and Cells
  • Working with Cells
  • Entering and Managing Data
  • Updating and Inserting Data
  • Using Formulas
  • Advanced Functions and Averages
  • Printing and Page Setup
  • Conclusion

MICROSOFT EXCEL

Presented By,
Amol Humane Anju Vaishnav Parag shah Pooja Borkar Vidit Taksali

GETTING STARTED :

You have to open the Microsoft Excel 2003 or 2007 by going to the Microsoft office folder

CREATE NEW SPREADSHEET :

Figure 1 A blank worksheet in a new workbook. The first workbook you open is called Book1 in the title bar at the top of the window until you save it with your own title. Sheet tabs at the bottom of the workbook window.

CREATE NEW SPREADSHEET :

COLUMNS AND ROWS AND CELLS

COLUMNS AND ROWS AND CELLS

Column headings are letters. Row headings are numbers. Column headings. Row headings. After the first 26 column headings (A through Z), the next 26 column headings are AA through AZ. The column headings continue through column IV, for a total of 256 columns.

CELLS ARE WHERE THE DATA GOES :

CELLS IN WORKSHEET :

Figure 1 The active cell is outlined in black. Figure 2 Cell C5 is selected and is the active cell. It has a black outline.

Column C is highlighted.
Row 5 is highlighted. Cell C5, the active cell, is shown in the Name Box in the upper-left corner of the worksheet.

ENTER DATA,

ENTERING DATA :

You can use Excel to enter all sorts of data, professional or personal. You can enter two basic kinds of data into worksheet cells: numbers and text. You can use Excel to create budgets, to work with taxes, or to record student grades. You can use Excel to list the products you sell or to record student attendance.

UPDATING THE DATA :

Press TAB to move the selection one cell to the right. Press ENTER to move the selection down one cell.

INSERT A COLUMN OR A ROW :

To insert a single column, click any cell in the column immediately to the right of where you want the new column to go. So if you want an order-ID column between columns B and C, you'd click a cell in column C, to the right of the new location. Then on the Insert menu, click Columns. To insert a single row, click any cell in the row immediately below where you want the new row to go. For example, to insert a new row between row 4 and row 5, click a cell in row 5. Then on the Insert menu, click Rows.

INSERT A COLUMN OR A ROW :

ENTERING THE FORMULA :

Type the equal sign, type SUM, and type an opening parenthesis in cell C9. Click cell C4, then type a comma in cell C9. Click cell C6, then type a closing parenthesis in cell C9.

Press ENTER to display the formula result.

FORMULAS :

FIND AN AVERAGE :

Click in cell D7, click the arrow on the AutoSum button, and then click Average in the list. Press ENTER to display the result in cell D7.

CHANGE PAGE ORIENTATION :

To change page orientation, in print preview click Setup (or in normal view, on the File menu, click Page Setup). On the Page tab, under Orientation, click Landscape.

PRINTING MULTIPLE PAGES :

You can change this order, so that Excel prints first over, and then down. In print preview, click Setup (or in normal view, on the File menu, click Page Setup), and then click the Sheet tab. Under Page order, click Over, then down.

CHOOSE WHAT DATA TO PRINT :

Select the area you want to print. Then, on the File menu, click Print. Under Print what, click Selection. Then click OK.

THANK YOU

MICROSOFT EXCEL Presented By, Amol Humane Anju Vaishnav Parag shah Pooja Borkar Vidit Taksali
GETTING STARTED : • You have to open the Microsoft Excel 2003 or 2007 by going to the Microsoft office folder
CREATE NEW SPREADSHEET : Figure 1 A blank worksheet in a new workbook.  The first workbook you open is called Book1
CREATE NEW SPREADSHEET :
COLUMNS AND ROWS AND CELLS
COLUMNS AND ROWS AND CELLS Column headings are letters. Row headings are numbers. Column headings. Row h
CELLS ARE WHERE THE DATA GOES :
CELLS IN WORKSHEET : Figure 1 The active cell is outlined in black. Figure 2 Cell C5 is selected and is the active
ENTER DATA,
ENTERING DATA : You can use Excel to enter all sorts of data, professional or personal. You can enter two basic kinds

You might also like