• Summarizes and analyzes data from a range into a concise, tabular format.
  
• Aggregates data based on arithmetic operations.
• Allow altering and sorting of data. Enable deep data analysis.

Excel is a spreadsheet program used for data organization, analysis, and visualization. It provides many features such as

• Performing Complex Calculations with the help of built-in functions such as COUNTIF, SUM etc.
• Creating charts
• Creating Graphs for Data Visualisation and more.

Use cell references or create formulas that reference cells in other worksheets.

• Selecting the columns and rows which require freezing.
• The user then needs to select the option of freeze panes in the view tab.
• The user will thennd three options to freeze the columns and rows which include “freeze panes”, “freeze top row” and “freeze the rest column”.

The order of operations in Excel is as follows: first, any calculations inside parentheses are performed; second, any exponentiations are completed; third, multiplication and division are carried out from left to right; and finally, addition and subtraction are executed from left-right. 

Remembering this order of operations is critical for getting accurate results in Excel. Invalid results can arise if the user does not follow the correct order.

You can double-click on the bottom right corner of the cell to apply a formula to an entire column in Excel.

OR

If the cell already has the formula, you can apply it as follows:

Select the cell containing the formula and press

CTRL+SHIFT+DOWN to select the rest of the column

Press CTRL+D

Use CTRL+UP to return up OR

If the formula is in the first cell of a column –

Select the entire column by clicking the column header or any cell in the column Press CTRL+SPACE Fill the consecutive cells using CTRL+D

Freezing a pane in a spreadsheet keeps a designated section of data stationary as you move through other information. This feature is o en employed to ensure a particular element remains in place, such as an index or key data. By using freeze panes, users can navigate through a sheet without losing track of that important information, improving overall productivity and organization.

You must follow the PEDMAS precedence in Excel when writing such a formula. 

• COUNT counts the number of cells with numbers.
• COUNTA counts non-empty cells.
• COUNTIF counts cells based on a single criterion.
• COUNTIFS does the same with multiple criteria.

It is not difficult to protect workbooks in the cell. The user can find three options for doing the following. They are:

The user can set up passwords to open the workbooks.

The user can also protect sheets from being added up or deleted. The sheets can also be prevented from being hidden or unhidden.

The user can protect the size of the window or the position of the windows from being changed.

• Number
• Currency
• Date
• Percentage Text.
• Common data formats for saving a workbook include:
• Excel workbook (.xlsx)
• Excel macro-enabled workbook (.xlsm)
• Excel binary workbook (.xlsb)
• Template (.xltx)
• Template (code) (.xltm) XML data (.xml)

• The following software carries graphics tools
• The following software carries inbuilt functions like SUM, COUNTIF, DATE, and others.

There are numerous benefits of using the formula in Excel, such as

Time-Saving: Formulas can be used to automate calculations. Once a formula is established, you can easily and repeatedly change the input values without manually calculating the new values.

Accuracy: A formula is much more accurate, especially for complex calculations.

Consistency: A formula can be applied to different datasets ensuring that the calculation remains consistent.

Flexibility: The formula can be easily modified, allowing the user to accommodate new data, scenarios, etc.

It is an alternative to VLOOKUP, which is used to look up values in a table.

If the user doesn’t wish to modify the cell addresses and still copy the formulas, then he needs to utilize the Absolute Cell Addresses.

• Arrange the information in the form of columns and rows.
• Keep in mind that there should be a unique heading in the first row of each column.
• There should be only one type of data in each column.
• The rows must feature data for a single recording only.
• There should be no blank rows in the following table.
• The must be no blank columns in the following table.

To modify a chart’s data source

• Select the chart you want to edit.
• Locate and open the “Chart Data” or “Select Data” option in your charting software.
• Adjust the data range references by selecting and editing them.
• Confirm the changes and the chart will update to reflect the modified data source.
• Ensure that the new data structure aligns with the chart’s requirements for accurate visualization.

Adding a Row

Where you wish to place the new row, choose the row below. Select row 4, for instance, if you wish to add a row between row 3 and row 4.

To access the context menu, perform right-click on the chosen row.

Go to the context menu and select ‘Insert’ or ‘Insert Cells.’ This will add a new row above the currently chosen row.

There are two types of references –

Relative reference in Excel

Relative references refer to the location of the cell, that is, the row and column where the cell that contains a value or a formula is located. When we take that same cell to move it to another cell, worth the redundancy, this will reference new cells based on their location.

Therefore, we can say that Excel predetermines relative references.

Absolute reference in Excel

The absolute reference represents a specific address. It always refers to the same cell and does not allow them to be modified when copying.

Absolute references are important because they remain, which is very good when working with Excel functions or formulas.

There are three formats:

Compact Form

Outline Form

Tabular Form