Excel Lecture 8

Using Autosum

Autosum automatically creates the formula that makes use of the sum function.  When you use autosum button, Excel anticipates that you want to add values within the reference range you have specified.

Autosum is very easy to use, just follow these three steps:

1. Select the cell where you want to hold the result of the equation. If you are adding a column or row then choose the last empty cell or the cell after to hold the formula result.
2. From the standard toolbar, look for the autosum button and click it.
3. Press Enter key. The result will be seen at the chosen cell.

Excel Lecture 7

Understanding Excel Formulas

One way to add calculations to an Excel workbook is to create your own formulas. Formulas are typically used to perform calculations such as addition, subtraction, multiplication, and division. More complex calculations are better left to Excel functions, which is a built-in set of formulas that provide financial, mathematical, and statistical calculations.

Formulas that you create typically include cell addresses that reference cells on which you want to perform a calculation. Formulas also consist of mathematical operators, such as + (addition) or * (multiplication).

Excel Lecture 6

Changing Text Attributes with Toolbar Buttons

1.      Select the cell or range that contains the text whose look you want to change.

2.      To change the font, click the Font drop-down list, and select a new font name. To change the font size, click the Font Size drop-down list and select the size you want to use. You can also type the point size into the Font Size box and then press Enter.

3.      To add an attribute such as bold, italic, or underlining to the selected cells, click the appropriate button: Bold, Italic, or Underline, respectively.

You can also change the color of the font in a cell or cells. Select the cell or cells and click the Font Color drop-down arrow on the Formatting toolbar. Select a font color from the Color palette that appears.

Excel Lecture 5

Adjusting Column Width and Row Height with a Mouse

You can also adjust row heights, if you want, using the mouse. However, your row heights will adjust to any font size changes that you make to data held in a particular row. Row heights also adjust if you wrap text entries within them. You will probably find that you need to adjust column widths in your worksheets far more often than row heights.

Excel Lecture 4

Entering Text

Text is any combination of letters, numbers, and spaces. By default, text is automatically left-aligned in a cell, whereas numerical data is right-aligned.

Entering Numbers As Text To enter a number that you want treated as text (such as a ZIP code), precede the entry with a single quotation mark (‘), as in ’46220. The single quotation mark is an alignment prefix that tells Excel to treat the following characters as text and left-align them in the cell. You do not have to do this to “text” numerical entries, but it ensures that they will not be mistakenly acted upon by formulas or functions.

Excel Lecture 3

Opening a workbook

Workbook – is actually a file in which you accumulate information so that we could study them closely and systematically

 

Appearance and part of a workbook

1. Row and column headings – you will know the exact location or address of an active cell through its column and row headings. You can also adjust the dimensions of cells via column and row headings.
2. Active cell – the highlighted or marked cell.
3. Select all button – located between the row and column headings. When you click on this button it automatically selects the whole worksheet, making it susceptible to all kinds of commands available in Excel.
4. Tab scrolling button – these buttons allows you to view your sheets from the beginning or the last sheet.
5. Sheet tabs – shows you which worksheet you are working at the moment.
6. Scroll bars – allows you to see the worksheet area that cannot be seen.

Excel Lecture 2

Starting Excel

Excel is a spreadsheet program that can help you create worksheets and invoices and do simple and sophisticated number crunching; it is designed to help you calculate the results of formulas and help you organize and analyze numerical data.

Excel Lecture 1

The Story Behind the Spreadsheet Program

In 1978, a Harvard Business student named Dan Bricklin got tired of adding up columns of numbers – and adding them up again after making a few changes – just to assess the effect of the merger. Bricklin, who knew little about computers from summer jobs at Wang and other firms, came up with the idea of a spreadsheet program running on a personal computer.

Bricklin’s teachers together with a programmer friend, Bob Frankston, produced Visicalc. It is a program for apple II computer. This marks an important new chapter in American enterprise, the Electronic spreadsheet.

Visicalc was huge success. More than 700,000 copies of the program eventually was sold and it was almost single-handedly responsible for the success of the Apple II personal computer. By 1984 it disappeared when lotus 1-2-3 was launched by IBM. It was an integrated program that combines analytical graphics and database management with what is clearly a clone of Visicalc spreadsheet.

Many innovations did come out, especially during the 90’s when the development of microchips were unstoppable, and so is the rapid the rapid development in various application programs. Finally, the ear of the GUI’s (Graphical User Interface) desktop had arrived. The next decade now belong to Microsoft’s Software king – Bill Gates. Then comes the birth of Microsoft Office software which include the Microsoft Excel, which operates very similar with lotus 123 but much faster and user friendly because it works in a graphical desktop environment with its electronic input device companion – the witty mouse.