"SMEClabs" is a registered trademark of SMEC Automation Pvt. Ltd. © 2022 SMEClabs All rights reserved
A cell address is used to identify a particular cell on a worksheet. It is denoted by a combination of the respective column letter and a row number.
The order of operations in Excel is referred to as PEDMAS. Shown below is the order of precedence while performing an Excel operation.
It counts the number of cells that contain numeric values only. Cells that have string values, special characters, and blank cells will not be counted.
It counts the number of cells that contain any form of content. Cells that have string values, special characters, and numeric values will be counted. However, a blank cell will not be counted.
As the name suggests, it counts the number of blank cells only. Cells that have content will not be taken into consideration.
We can use the CONCATENATE ()
The function VLOOKUP in Excel is used to look up information in a table and extract the corresponding data.
Syntax: VLOOKUP (value, table, col_index, [range_lookup])
The SUMIF() function adds the cell values specified by a given condition or criteria.
A pivot table is like a summary table of the dataset that enables you to create reports and analyze trends. They are useful when you have long rows or columns that hold values you need to track.
This can be done by using the ‘Data Validation’ option present in the Data tab
Data Validation restricts the type of values that a user can enter into a particular cell or a range of cells.
Macro is a program that resides within the Excel file. The use of it is to automate repetitive tasks that you would like to perform in Excel.
The What-If Analysis in Excel is a powerful tool to perform complex mathematical calculations, experiment with data, and try out different scenarios.
The use of macros allows you to perform a series of tasks repeatedly, and Macros can be used to automate repetitive tasks and instructions.
To apply the advanced filter, you need to
Step 1 : Select the data set
Step 2 : Go to Data –> Sort & Filter –> Advanced
Step 3 : Locate the Advanced Filter dialogue box, and select ‘Copy to another location’
Step 4 : Click OK
You can double-click on the bottom right corner of the cell to apply a formula to an entire column in Excel.
If the cell already has the formula, you can apply it down as follows:
Select the cell containing the formula and press CTRL+SHIFT+DOWN to select the rest of the column
Some of the file formats to save Microsoft Excel files are csv, xlsm, xls, xla, xlb.
We can get the current date by using = TODAY () function.
We can wrap a text within a cell by simply selecting the cell, and then clicking on the Wrap Text option which is a part of the Home tab
Conditional formatting allows you to apply a format to a single cell or range of cells based on specific criteria. It makes trends and patterns in your data look more apparent.