Functions of Excel introduction to use it

Excel is a program for table layout, graphical presentation of data and various calculations.

Printing Margins Exit Preparation (Printing)  Inserting objects into Excel  Formatting the row, columns and tree plots  Forms and functions – Inserting functions  Editing data  Formatting tables  Creating tables – Inserting  Excel main window – Toolbar  Excel opening
Opening Excel Excel opens in several ways:

  1. On the Desktop by clicking the Excel icon twice.
  2. Start – Programs – Microsoft Excel.
  3. Start – Run and in the window presented in Open we write Excel.

Excel main window After Excel is activated, the main window that opens is displayed:

1. Main Menu – Contains these options: File, Edit, View, Insert, Format, Tools, Data, Help, and Help. 2. Work area (table) oriented on sheets (sheet) and consists of columns and beams that together form the cell. 3. Toolbars.

Excel

 The Standard Bar contains the following tools:

New, Open, Save, Print, Previe Print, Spelling, Research, Cut, Copy, Paste, Pigment Format, Undo, Redo, Insert Hyperlink, Autosum, Sort Ascending, Chart Wizard, Drawing, Zoom , Microsoft Excel Help. The most widely used tools are those found in Standard and Formatting tapes.  Activate the tapes by: View, Toolbars and select the desired bar.

Standard Toolbars
The Formatting Bar contains the following tools: Style, Font, Highlight, Bold, Italic, Underline, Align Left, Center, Align Right, Justify, Bullets, Numbering, Increase Indent, Decrease Indent, Left to Right / Right to left.

Formatting Toolbars
Cell insertion is done through Insert / Cells. The selection is done in such a way that the cursor is placed in column letters and line numbers and while holding down the mouse key and including the necessary rows or columns, we can select them as follows. choice of columns choice of rows  On the working surface there is an “infinite” table for data processing. But this table is empty in the frame of which many tables can be created. The table can be created in each cell.

Creating Input Tables
Data can be changed by clicking on the cell and writing what we want. Data retrieval on the worksheet is done through the Find option found in Edit mode after selecting the space where the text is searched then Find.  Data that can be entered in Excel can be: Text (without numeric value), Numeric (only numbers) or Formula (mathematical equations)

Data editing
Sort the data with a certain step: First select the formula then in the lower right corner place the cursor that changes from its usual form. Using formulas in Excel is done in two ways: 1. Using the numbers directly in table 2. referring to table cells.  The calculation is done through these arithmetic operators: multiplication (*), division (/), collection (+), subtraction (-), power (^)  To create a formula in the cell that represents the result should be written the arithmetic expression, the expression always begins with the sign = and after the equation are written the cell addresses by combining them with the arithmetic operators or with constant numbers.

Formulas
 Functions can be:

  1. Mathematical or trigonometric, 2. static, 3. logical, 4.Data and time functions

The most commonly used functions are:

1.Minimum = Min, 2.Maximum = Max, 3.Number of members = Count, 4. Average = Average, 5. Sum = Sum.

Excel has many functions that can be used and they are written directly into cells or taken from tools.  To insert functions, select the Insert / Function menu.

Entering Functions
Adjusting the numbering data: takes place in Format and Number mode. On the right side of the window, the details of the appearance of numbers are set, such as the Decimal Places Number and the Negative Number Presentation Form. In Excel is a set of data that we can arrange as desired. However, the most accurate way of data formatting is to format the contents of the data by choosing Format / Cell.

Spreadsheet formatting
Formatting Tables Data Reconciliation: The Format Cells window has an Aligment Log in which textual orientation options and some other effects are available. In Text Alignment, we align the horizontal content of the cell horizontally / vertically. In Wrap text, if this text-picker text option is enabled, it may appear in more than one line. Etc … Font: The Font Registry option is the font font selection and we can choose the color and the effects as Bold and Italic. Borders: If we want the lines to be limited by lines.
If you want toColon and row formatting

 

Leave a Reply

Your email address will not be published. Required fields are marked *