Skip to content
Call Us: 9999850802
excel vba guru

excelvbaguru

Menu

  • Home
  • Our Courses
    • Excel Training
    • Excel Macro
    • SQL Training
  • Excel Blog
  • Contact Us

Excel Blog

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

admin May 22, 2020 Excel Function No Comments Read more

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

admin November 24, 2018April 20, 2023 Excel Function, Excel Tutorial, Logical Function 1 Comment Read more

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

admin October 31, 2018 Excel Function, Excel Tutorial 1 Comment Read more

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

admin October 13, 2018 Excel Tutorial No Comments Read more

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

admin October 12, 2018 Excel Tutorial No Comments Read more

Range Object in Excel VBA

Range Object in Excel VBA

Range object in excel vba represents a cell or group of cells in excel worksheet. Most of time excel user working with cells in excel. Range Object accept single cell or multiple cell name as argument and refer excel worksheet cells

admin April 23, 2018 Excel Macro Training, Range Object, VBA Tutorial No Comments Read more

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 =

admin December 4, 2014 Excel Macro Training No Comments Read more

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

admin January 2, 2014 Excel Training 3 Comments Read more

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

admin December 9, 2013 Excel Macro Training, Excel Training 1 Comment Read more

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

admin November 28, 2013 Excel Macro Training, Excel Training No Comments Read more
excel guru
  • Useful Shortcut Keys in Excel
  • IFERROR Function in Excel
  • TEXT Function in Excel
  • IF Function in Excel
  • EXACT Function in Excel

About ExcelVBAGuru

Excel VBA Guru is a Best excel training institutes in delhi. We offers excel, excel macro, ms-access, SQL training for students and working professionals. Our training programs combine theoretical knowledge with practical experience. Excel Training is designed in very project

Read more

Latest Post

  • IF Function in Excel
  • IFERROR Function in Excel
  • TEXT Function in Excel
  • EXACT Function in Excel

A-66, 2nd & 3rd Floor
Sector-7, Ramphal Chowk
Near ICICI Bank, Dwarka
New Delhi-110075

PH: 011-45613139
Mob: +91-9999850802

Copyright © 2025 excelvbaguru. All rights reserved. Theme Spacious by ThemeGrill. Powered by: WordPress.
  • Privacy Policy
  • Contact Us
  • About Us