Sparklines in Excel
What is Sparkline in Excel? Sparkline is a small graph that represents a series of data. It fits into a single cell. The three different data visualizations are: Line Column Win/Loss It is an...
MS Excel Tutorials
VBA Data Types, Variables and Constants
This “VBA Variables, Data Types & Constants” topic covers the concept of what variables and constants are. Knowing the difference between them and where to use them is really important. What is a Variable?...
Arithmetic Operators – Visual Basic
VBA Arithmetic Operators perform operations such as adding, subtracting, multiplying and dividing the numbers. In these operations, we calculate the numeric values and they are represented by variables, functions, constants, property calls and other...
VBA Comparison Operators
Comparison operators are the operators that are used to compare values. Some of the comparison operators are equal to (=), less than (<), greater than(>) and not equal to(<>). The user mostly uses comparison...
VBA String Functions | Operators for Manipulating Strings
String can contain alphabets, numbers and special characters in a sequence. The special advantage of a string is that it can hold all different characters at a single string. String operators help in manipulating...
ISNA in Excel
What is ISNA in Excel? ISNA is one of the built-in excel functions, which returns true when there is a #N/A error in the cell. ISNA function is also known as information function. You...
Macros in Excel
Macros helps in automating the tasks that you wanted to do repeatedly by recording a macro. While recording a macro, each and every mouse clicks and keystrokes will be recorded. It can be edited...
Import Different Types of Data Into Excel in Easy Steps
The datasets are imported into a single excel sheet for analysis of data and further evaluation. The data can be of any format like XML, Text/CSV, MS Access, and SQL Database. These can be...
VLOOKUP in Excel with Examples
Vlookup is a built-in function in MS-Excel. Vlookup stands for vertical lookup. In this vlookup function, it fetches the value from the column you specify. In simple terms, we could say that vlookup helps...
Pivot Table in Excel
In this blog, we will discuss how to form a pivot table in MS-Excel, what a pivot table is and what are the features in a pivot table. What is Pivot table in Excel?...
