Excel Notes 1

What is Excel?

Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications. Microsoft Excel enables users to format, organize and calculate data in a spreadsheet.

Excel contains a large number of boxes called cells that are ordered in rows and columns. Data is placed in these cells.

The Extension of Excel is .xls.

 Use of Excel

Ø 👉collection and verification of business data;

Ø 👉business analysis;

Ø 👉data entry and storage;

Ø 👉data analysis;

Ø 👉performance reporting;

👉strategic analysis

Excel Terminology

👉Cell. A user enters data into a cell, which is the intersection of a column and row.  

👉Cell reference. This is the set of coordinates where a cell is located. Rows are                 horizontal and numbered whereas columns are vertical and assigned a letter.

👉Active cell. This is the currently selected cell, outlined by a green box.

👉Workbook. This is an Excel file that contains one or more worksheets.

👉Worksheet. These are the different documents nested within a Workbook.

👉Worksheet tab. These are the tabs at the bottom left of the spreadsheet.

👉Column and row headings. These are the numbered and lettered cells located just           outside of the columns and rows. Selecting a header highlights the entire row or                column.

👉Formula. Formulas are mathematical equations, cell references or functions that             can    be placed inside a cell to produce a value. Formulas must start with an equal            "=" sign.

👉Formula bar. This is the long input bar that is used to enter values or formulas in             cells. It is located at the top of the worksheet, next to the "fx" label.

👉Address bar. This bar located to the left of the formula bar shows the number and           letter coordinates of an active cell. 

👉Filter. These are rules a user can employ to select what rows in a worksheet to                 display. This option is located on the top right of the home bar under "Sort &                    Filter." An auto filter option can be selected to show rows that match specific                    values.

👉AutoFill. This feature enables users to copy data to more than one cell                               automatically. With two or more cells in a series, a user can select both cells and               drag the bottom right corner down to autofill the rest of the cells.

👉AutoSum. This feature enables users to add multiple values. Users can select the             cells they want to add and press the Alt and Equal keys. There is also a button to               enable this feature on the top right of the home page, above "Fill" and to the left of           "Sort & Filter."

👉PivotTable. This data summarization tool sorts and calculates data automatically.             This is located under the insert tab on the far left.

👉PivotChart. This chart acts as a visual aid to the PivotTable, providing graph                   representations of the data. It is located under the middle of the insert page, next to            maps.

What is Micro 

A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to make minor changes to the way it works.

protection in Excel File

If We want to protect your file with password then you can use the the protect option which is available in Review option