## Useful Shortcut Keys in Excel

In this shortcut keys in excel tutorial, we will learn popular keyboard shortcuts used with the excel. Using a keyboard shortcut helps the user to work in excel more efficiently. Keyboard shortcut keys speed up our work. Microsoft Excel has

## IFERROR Function in Excel

IFERROR Function in Excel: We will learn about syntax and how to use iferror function in Excel with examples. Description: The Function returns a custom value when a function generates an error, otherwise, it returns the result of the value

## TEXT Function in Excel

Text Function in Excel : Here, we will discuss about syntax and usage of TEXT function. Description: The TEXT Function in Excel is used to convert number into given text format. It returns text value, so it may not perform mathematical

## IF Function in Excel

IF Function in Excel : In this excel tutorial we will learn about syntax, usage and nesting of IF function. Description: The IF function is the most popular function for a logical test in Excel worksheet. It compares two values

## EXACT Function in Excel

Exact function in Excel : In this tutorial, we will learn about syntax and usage of the Exact function. Description : Exact function in excel is used to compare two strings (text) and returns TRUE if the string is same, otherwise

## Copy and Paste Content From a sheet to Another sheet in Excel Macro

This Blog post show you how to copy and paste content from a sheet to another sheet in Excel Macro. This code is done by our student as assignment. public sub test() Dim i, k As Integer Set s1 =

## Advance Excel Course in Delhi

excelvbaguru.com offers new batch for advance excel course in delhi. advance excel course includes most important function of excel, it covers pivot table, pivot chart, hlookup, vlookup and all important functions in this course. advance excel course focus on practical

## Excel Macro Operators

Mathematical Operators in Excel Macro Operator Action Precedence (1=top; 5=bottom) ^ The power operator 1 * The multiplication operator 2 / The division operator 2 \ The integer division operator – this operator divides two numbers and returns the integer

## Data Types in Excel Macro

This Blog Post explain you data types in excel macro. Whenever macro code accept input from user or when you assign value to a variable, you need to define type of data to be store in a variable. for example