Python, C, C++, C#, PowerShell, Android, Visual C++, Java ...
Microsoft Excel provides logical formulas to enable to select the data depending on the given criteria. For example, select the data; if some condition(s) satisfies. In this Article, we will go through; IF, IFERROR and IFNA Logical Functions in Microsoft Excel. IF function The syntax of this function is: =IF(condition, [true-value], [false-value]) IF function takes […]
Microsoft Excel provides another set of operators to deal with the concatenation of text and combine ranges of Cells for calculations. Concatenation Operator This operator ONLY works on text data. It concatenates the text values or the values in the reference Cells to produce the concatenated text. If you apply this with any other data […]
Microsoft Excel provides Comparison Operators to compare the values of two operands. You can give the values directly or you can give the Cell references when you use these operators in Excel formulas. Comparison Operators Excel’s comparison operators are useful to compare the values in two operands. You can compare two values or the values […]
Microsoft Excel provides different types of Operators to evaluate Arithmetic Expressions. Arithmetic Operators in Excel deal with ONLY Numerical data. In this article, I am going to explain what are Arithmetic Operators and their usage in Microsoft Excel. Arithmetic Operators in Excel These are the Arithmetic Operators, to work on Numerical data. If you attempt […]
Microsoft Excel provides a great feature, Conditional Formatting, to apply the formatting to particular Cells when the given criteria are met. We can apply the formatting to a particular cell or range of cells. You need to select the Rule depending on your requirements to colorize or format the cells. In this article, I am […]
Microsoft Excel – AVERAGEIFS, AVERAGEIF, and AVERAGE functions are useful to calculate the Average value. Microsoft Excel provides a good number of Functions to enable us to deal with Spreadsheet data. In this article, I am going to explain, AVERAGE, AVERAGEIF, and AVERAGEIFS functions. Before we start looking into these functions; lets’ understand, why an […]
Excel allows the creation of multiple Worksheets in each Excel Workbook. And it provides Tabs to manage the Worksheets. You can hide or show these Worksheets inside the Workbook. When the Worksheets are hidden, you can not see the associated Tabs. Tabs can be visible only when Worksheets are Visible. And Excel provides an option […]
Microsoft Excel has great features to allow Users to easily work with the Work Sheets. And some of the features are allowed you to write programming; for example, macros. Some of these features can be enabled or disabled through Microsoft Excel Options. Once the options are enabled, Microsoft Excel will display the Controls / Icons […]
Microsoft Excel application provides chart tools to manage charts in Excel sheets. In this article, we are going to discuss the steps to increase the gap between the slices in the Pie Chart. Step 1. Open the excel sheet where the Pie Chart graph is added; in Microsoft Excel 2013 application. Step 2. Select the […]
VLOOKUP function in Microsoft Excel is used to look up the values vertically (leftmost column) in the given range and find the matching entry. If the matching entry is found, it returns the entry from the given column in the same row where it found the look-up value. The syntax of the VLOOKUP function is: […]
