✕

Find the best tutors and institutes for Microsoft Excel Training

Find Best Microsoft Excel Training classes

✕

Search for topics

Lesson Posted on 31/05/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Vipin K

I have about six years experience on database side with data analytics , business intelligence, data...

Like 0

Comments Answered on 06/06/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Dheeraj Kumar Mishra

Ms Excel Trainer with 4 years of working experience

Hi Venkat, As per my opinion and experience, we are using VBA for reducing the repetitive task in excel. For example: Suppose every day you are preparing an attendance tracker in which you will mark present/absent or any other comment in the attendance section every day. Either you are using v-lookup... read more

Hi Venkat,

As per my opinion and experience, we are using VBA for reducing the repetitive task in excel. For example: Suppose every day you are preparing an attendance tracker in which you will mark present/absent or any other comment in the attendance section every day. Either you are using v-lookup or any other method to reflect desired remarks in the respective section, and you will spend 30min. Everyday. By using VBA, you can do the same thing within 2-3 min.

I would suggest you work on macro. Because in the macro, you will record the required steps for performing the specific task every day. It will increase your productivity.

I hope this will help you.

Like 3

Answers 5 Comments Lesson Posted on 25/05/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Basic excel required for MIS position

Dheeraj Kumar Mishra

I have 4 year experience in reporting and analytics domain. I have extensive experience in MS excel,...

Dear Students, Today we will know about the mis and its importance in business world. In Business world, organisation's have many business problem related to process are exists. For taking any decision, first we will sure the effect of next course of action w. r. t issue. So we need the data.This data... read more

Dear Students,

Today we will know about the mis and its importance in business world. In Business world, organisation's have many business problem related to process are exists. For taking any decision, first we will sure the effect of next course of action w. r. t issue. So we need the data.This data will be provide by mis executive to management.

Basic's of excel:

Text function: Trim, Left, Right, Mid, find, search etc.

Lookup function: lookup, v-lookup, H-lookup, index match etc.

Logical finction: if, and, or, if with and. If with or etc.

Arithmetic function: sum function and its type, count function with its type etc.

These are the basic skills required for MIS daily functionality.

read less

Like 0

Comments Looking for Microsoft Excel Training classes

Find best Microsoft Excel Training classes in your locality on UrbanPro.

Answered on 29/05/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Hi, what is the future growth in excel VBA, how much is the demand in the present?

Dheeraj Kumar Mishra

Ms Excel Trainer with 4 years of working experience

Hi Santosh, As per my opinion, you will know about VBA. As per current market, trend companies are looking for those persons who have expertise in excel and VBA. Because they want automation of different types of reports as required and provide maximum time to resources for analysis and finding critical... read more

Hi Santosh,

As per my opinion, you will know about VBA. As per current market, trend companies are looking for those persons who have expertise in excel and VBA. Because they want automation of different types of reports as required and provide maximum time to resources for analysis and finding critical insights from the stories.

You can learn VBA with your daily excel work.

First, you will work on macro then learn VBA coding. Learn at least one topic in a day.

I hope this will help you

Like 3

Answers 1 Comments 1 Asked on 12/03/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Hi Friends, I am trying to bulid a macro for Web page automation where I am not getting how to write... read more

Hi Friends, I am trying to bulid a macro for Web page automation where I am not getting how to write a code for that. In HTML source page there is no any id,class to get element, the tag is

**<a href="javascript:;" onclick="enableMandate('MjQ9Kio9ZW5hYmxl')">Enable</a> **

where if I click enable button the pop up message will come are you sure you need to enable I need to click yes. So, I have to do it for 1000 items, hence I am trying to build a VBA code.

Can any any one help me, it is emergency? read less

Answer

Answered on 28/03/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training IT Courses/Adobe RoboHelp

Bikram Jeet

Tutor

As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team. VBA is for programmers who need to develop softwares. Learning VBA is like - How you learned Bi-cycle. You will learn it, but it would take you an year to master it. You need immediate... read more

As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team.

VBA is for programmers who need to develop softwares.

Learning VBA is like - How you learned Bi-cycle. You will learn it, but it would take you an year to master it. You need immediate returns of your invested time, to make more money, and should not waste your another 3-6 months.

read less Like 4

Answers 5 Comments Lesson Posted on 07/04/2018 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Why Option Explicit is Required in the VBA Editor

Kumar S

I have 5 Years of experience in MNC's and I worked on real time projects in VBA, Python, MSBI and SQL.

Hi Folks,Do you know Excel VBA Editor has functionality where you don't need to declare a variable in memory (DIM).But what will happen if you write a program without declaring a variable nothing happens?Then why do we need to declare a variable and what is Option Explicit? Yes here comes the answer.When... read more

Hi Folks,

Do you know Excel VBA Editor has functionality where you don't need to declare a variable in memory (DIM).

But what will happen if you write a program without declaring a variable nothing happens?

Then why do we need to declare a variable and what is Option Explicit? Yes here comes the answer.

When you write option explicit at the top of your VBA Editor VBA will force you to declare a variable it's a standard practice to declare a variable.

One more point when you are not declaring a variable in VBA by default VBA Program considers that as a variant data type which consumes more space, Also it increases programs running time.

So next time when you write a program don't forget to declare a variable.

Happy learning!!

Like 0

Comments Asked on 29/03/2018 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training Exam Coaching/Foreign Education Exam Coaching/Advanced Placement Tests Coaching/Computer Science

How do I transfer AutoCorrect from one computer to another computer?

Answer

Lesson Posted on 24/02/2018 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel IT Courses/MS Office Software Training/Microsoft Excel Training

MS Excel: Formulas and Functions: Listed by Category

Siddhartha Mahapatra

I am working in IBM as a Lead Finance and Administration. I have gained exposure on financial reporting...

MS Excel: Formulas and Functions: Listed by Category Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel. VBA functions are built-in functions that are used in Excel's programming environment called Visual... read more

MS Excel: Formulas and Functions: Listed by Category

Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel. VBA functions are built-in functions that are used in Excel's programming environment called Visual Basic for Applications (VBA).

Below is a list of Excel formulas sorted by category.

(Enter a value in the field above to quickly find functions in the list below)

A. Lookup/Ref Functions

- ADDRESS (WS): Returns a text representation of a cell address
- AREAS (WS): Returns the number of ranges in a reference
- CHOOSE (WS, VBA): Returns a value from a list of values based on a given position
- COLUMN (WS): Returns the column number of a cell reference
- COLUMNS (WS): Returns the number of columns in a cell reference
- HLOOKUP (WS): Performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number
- HYPERLINK (WS): Creates a shortcut to a file or Internet address
- INDEX (WS): Returns either the value or the reference to a value from a table or range
- INDIRECT (WS): Returns the reference to a cell based on its string representation
- LOOKUP (WS): Returns a value from a range (one row or one column) or from an array
- MATCH (WS): Searches for a value in an array and returns the relative position of that item
- OFFSET (WS): Returns a reference to a range that is offset a number of rows and columns
- ROW (WS): Returns the row number of a cell reference
- ROWS (WS): Returns the number of rows in a cell reference
- TRANSPOSE (WS): Returns a transposed range of cells
- VLOOKUP (WS): Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position

B. String/Text Functions:

- ASC (VBA): Returns ASCII value of a character
- CHAR (WS): Returns the character based on the ASCII value
- CHR (VBA): Returns the character based on the ASCII value
- CLEAN (WS): Removes all nonprintable characters from a string
- CODE (WS): Returns the ASCII value of a character or the first character in a cell
- CONCAT (WS): Used to join 2 or more strings together
- CONCATENATE (WS): Used to join 2 or more strings together (replaced by CONCAT Function)
- CONCATENATE with & (WS, VBA): Used to join 2 or more strings together using the & operator
- DOLLAR (WS): Converts a number to text, using a currency format
- EXACT (WS): Compares two strings and returns TRUE if both values are the same
- FIND (WS): Returns the location of a substring in a string (case-sensitive)
- FIXED (WS): Returns a text representation of a number rounded to a specified number of decimal places
- FORMAT STRINGS (VBA): Takes a string expression and returns it as a formatted string
- INSTR (VBA): Returns the position of the first occurrence of a substring in a string
- INSTRREV (VBA): Returns the position of the first occurrence of a string in another string, starting from the end of the string
- LCASE (VBA): Converts a string to lowercase
- LEFT (WS, VBA): Extract a substring from a string, starting from the left-most character
- LEN (WS, VBA): Returns the length of the specified string
- LOWER (WS): Converts all letters in the specified string to lowercase
- LTRIM (VBA): Removes leading spaces from a string
- MID (WS, VBA): Extracts a substring from a string (starting at any position)
- PROPER (WS): Sets the first character in each word to uppercase and the rest to lowercase
- REPLACE (WS): Replaces a sequence of characters in a string with another set of characters
- REPLACE (VBA): Replaces a sequence of characters in a string with another set of characters
- REPT (WS): Returns a repeated text value a specified number of times
- RIGHT (WS, VBA): Extracts a substring from a string starting from the right-most character
- RTRIM (VBA): Removes trailing spaces from a string
- SEARCH (WS): Returns the location of a substring in a string
- SPACE (VBA): Returns a string with a specified number of spaces
- SPLIT (VBA): Used to split a string into substrings based on a delimiter
- STR (VBA): Returns a string representation of a number
- STRCOMP (VBA): Returns an integer value representing the result of a string comparison
- STRCONV (VBA): Returns a string converted to uppercase, lowercase, proper case or Unicode
- STRREVERSE (VBA): Returns a string whose characters are in reverse order
- SUBSTITUTE (WS): Replaces a set of characters with another
- T (WS): Returns the text referred to by a value
- TEXT (WS): Returns a value converted to text with a specified format
- TEXTJOIN (WS): Used to join 2 or more strings together separated by a delimiter
- TRIM (WS, VBA): Returns a text value with the leading and trailing spaces removed
- UCASE (VBA): Converts a string to all uppercase
- UPPER (WS): Convert text to all uppercase
- VAL (VBA): Returns the numbers found in a string
- VALUE (WS): Converts a text value that represents a number to a number

C. Date/Time Functions:

- DATE (WS): Returns the serial date value for a date
- DATE (VBA): Returns the current system date
- DATEADD (VBA): Returns a date after which a certain time/date interval has been added
- DATEDIF (WS): Returns the difference between two date values, based on the interval specified
- DATEDIFF (VBA): Returns the difference between two date values, based on the interval specified
- DATEPART (VBA): Returns a specified part of a given date
- DATESERIAL (VBA): Returns a date given a year, month, and day value
- DATEVALUE (WS, VBA): Returns the serial number of a date
- DAY (WS, VBA): Returns the day of the month (a number from 1 to 31) given a date value
- DAYS (WS): Returns the number of days between 2 dates
- DAYS360 (WS): Returns the number of days between two dates based on a 360-day year
- EDATE (WS): Adds a specified number of months to a date and returns the result as a serial date
- EOMONTH (WS): Calculates the last day of the month after adding a specified number of months to a date
- FORMAT DATES (VBA): Takes a date expression and returns it as a formatted string
- HOUR (WS, VBA): Returns the hours (a number from 0 to 23) from a time value
- ISOWEEKNUM (WS): Returns the ISO week number for a date
- MINUTE (WS, VBA): Returns the minutes (a number from 0 to 59) from a time value
- MONTH (WS, VBA): Returns the month (a number from 1 to 12) given a date value
- MONTHNAME (VBA): Returns a string representing the month given a number from 1 to 12
- NETWORKDAYS (WS): Returns the number of work days between 2 dates, excluding weekends and holidays
- NETWORKDAYS.INTL (WS): Returns the number of work days between 2 dates, excluding weekends and holidays
- NOW (WS, VBA): Returns the current system date and time
- SECOND (WS): Returns the seconds (a number from 0 to 59) from a time value
- TIME (WS): Returns a decimal number given an hour, minute and second value
- TIMESERIAL (VBA): Returns a time given an hour, minute, and second value
- TIMEVALUE (WS, VBA): Returns the serial number of a time
- TODAY (WS): Returns the current system date
- WEEKDAY (WS, VBA): Returns a number representing the day of the week, given a date value
- WEEKDAYNAME (VBA): Returns a string representing the day of the week given a number from 1 to 7
- WEEKNUM (WS): Returns the week number for a date
- WORKDAY (WS): Adds a specified number of work days to a date and returns the result as a serial date
- WORKDAY.INTL (WS): Adds a specified number of work days to a date and returns the result as a serial date (customizable weekends)
- YEAR (WS, VBA): Returns a four-digit year (a number from 1900 to 9999) given a date value
- YEARFRAC (WS): Returns the number of days between 2 dates as a year fraction

D. Math/Trig Functions:

- ABS (WS, VBA): Returns the absolute value of a number
- ACOS (WS): Returns the arccosine (in radians) of a number
- ACOSH (WS): Returns the inverse hyperbolic cosine of a number
- AGGREGATE (WS): Apply functions such AVERAGE, SUM, COUNT, MAX or MIN and ignore errors or hidden rows
- ASIN (WS): Returns the arcsine (in radians) of a number
- ASINH (WS): Returns the inverse hyperbolic sine of a number
- ATAN (WS): Returns the arctangent (in radians) of a number
- ATAN2 (WS): Returns the arctangent (in radians) of (x,y) coordinates
- ATANH (WS): Returns the inverse hyperbolic tangent of a number
- ATN (VBA): Returns the arctangent of a number
- CEILING (WS): Returns a number rounded up based on a multiple of significance
- CEILING.PRECISE (WS): Returns a number rounded up to the nearest integer or to the nearest multiple of significance
- COMBIN (WS): Returns the number of combinations for a specified number of items
- COMBINA (WS): Returns the number of combinations for a specified number of items and includes repetitions
- COS (WS, VBA): Returns the cosine of an angle
- COSH (WS): Returns the hyperbolic cosine of a number
- DEGREES (WS): Converts radians into degrees
- EVEN (WS): Rounds a number up to the nearest even integer
- EXP (WS, VBA): Returns e raised to the nth power
- FACT (WS): Returns the factorial of a number
- FIX (VBA): Returns the integer portion of a number
- FLOOR (WS): Returns a number rounded down based on a multiple of significance
- FORMAT NUMBERS (VBA): Takes a numeric expression and returns it as a formatted string
- INT (WS, VBA): Returns the integer portion of a number
- LN (WS): Returns the natural logarithm of a number
- LOG (WS, VBA): Returns the logarithm of a number to a specified base
- LOG10 (WS): Returns the base-10 logarithm of a number
- MDETERM (WS): Returns the matrix determinant of an array
- MINVERSE (WS): Returns the inverse matrix for a given matrix
- MMULT (WS): Returns the matrix product of two arrays
- MOD (WS): Returns the remainder after a number is divided by a divisor
- ODD (WS): Rounds a number up to the nearest odd integer
- PI (WS): Returns the mathematical constant called pi
- POWER (WS): Returns the result of a number raised to a given power
- PRODUCT (WS): Multiplies the numbers and returns the product
- RADIANS (WS): Converts degrees into radians
- RAND (WS): Returns a random number that is greater than or equal to 0 and less than 1
- RANDBETWEEN (WS): Returns a random number that is between a bottom and top range
- RANDOMIZE (VBA): Used to change the seed value used by the random number generator for the RND function
- RND (VBA): Used to generate a random number (integer value)
- ROMAN (WS): Converts a number to roman numeral
- ROUND (WS): Returns a number rounded to a specified number of digits
- ROUND (VBA): Returns a number rounded to a specified number of digits
- ROUNDDOWN (WS): Returns a number rounded down to a specified number of digits
- ROUNDUP (WS): Returns a number rounded up to a specified number of digits
- SGN (VBA): Returns the sign of a number
- SIGN (WS): Returns the sign of a number
- SIN (WS, VBA): Returns the sine of an angle
- SINH (WS): Returns the hyperbolic sine of a number
- SQR (VBA): Returns the square root of a number
- SQRT (WS): Returns the square root of a number
- SUBTOTAL (WS): Returns the subtotal of the numbers in a column in a list or database
- SUM (WS): Adds all numbers in a range of cells
- SUMIF (WS): Adds all numbers in a range of cells based on one criteria
- SUMIFS (WS): Adds all numbers in a range of cells, based on a single or multiple criteria
- SUMPRODUCT (WS): Multiplies the corresponding items in the arrays and returns the sum of the results
- SUMSQ (WS): Returns the sum of the squares of a series of values
- SUMX2MY2 (WS): Returns the sum of the difference of squares between two arrays
- SUMX2PY2 (WS): Returns the sum of the squares of corresponding items in the arrays
- SUMXMY2 (WS): Returns the sum of the squares of the differences between corresponding items in the arrays
- TAN (WS, VBA): Returns the tangent of an angle
- TANH (WS): Returns the hyperbolic tangent of a number
- TRUNC (WS): Returns a number truncated to a specified number of digits

E. Statistical Functions:

- AVEDEV (WS): Returns the average of the absolute deviations of the numbers provided
- AVERAGE (WS): Returns the average of the numbers provided
- AVERAGEA (WS): Returns the average of the numbers provided and treats TRUE as 1 and FALSE as 0
- AVERAGEIF (WS): Returns the average of all numbers in a range of cells, based on a given criteria
- AVERAGEIFS (WS): Returns the average of all numbers in a range of cells, based on multiple criteria
- BETA.DIST (WS): Returns the beta distribution
- BETA.INV (WS): Returns the inverse of the cumulative beta probability density function
- BETADIST (WS): Returns the cumulative beta probability density function
- BETAINV (WS): Returns the inverse of the cumulative beta probability density function
- BINOM.DIST (WS): Returns the individual term binomial distribution probability
- BINOM.INV (WS): Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion
- BINOMDIST (WS): Returns the individual term binomial distribution probability
- CHIDIST (WS): Returns the one-tailed probability of the chi-squared distribution
- CHIINV (WS): Returns the inverse of the one-tailed probability of the chi-squared distribution
- CHITEST (WS): Returns the value from the chi-squared distribution
- COUNT (WS): Counts the number of cells that contain numbers as well as the number of arguments that contain numbers
- COUNTA (WS): Counts the number of cells that are not empty as well as the number of value arguments provided
- COUNTBLANK (WS): Counts the number of empty cells in a range
- COUNTIF (WS): Counts the number of cells in a range, that meets a given criteria
- COUNTIFS (WS): Counts the number of cells in a range, that meets a single or multiple criteria
- COVAR (WS): Returns the covariance, the average of the products of deviations for two data sets
- FORECAST (WS): Returns a prediction of a future value based on existing values provided
- FREQUENCY (WS): Returns how often values occur within a set of data. It returns a vertical array of numbers
- GROWTH (WS): Returns the predicted exponential growth based on existing values provided
- INTERCEPT (WS): Returns the y-axis intersection point of a line using x-axis values and y-axis values
- LARGE (WS): Returns the nth largest value from a set of values
- LINEST (WS): Uses the least squares method to calculate the statistics for a straight line and returns an array describing that line
- MAX (WS): Returns the largest value from the numbers provided
- MAXA (WS): Returns the largest value from the values provided (numbers, text and logical values)
- MEDIAN (WS): Returns the median of the numbers provided
- MIN (WS): Returns the smallest read less

Like 0

Comments Looking for Microsoft Excel Training classes

Find best Microsoft Excel Training classes in your locality on UrbanPro.

Answered on 14/05/2017 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Edulitix

Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.

Like 2

Answers 32 Comments UrbanPro.com helps you to connect with the best Microsoft Excel Training classes in India. Post Your Requirement today and get connected.

x

Ask a Question

X ### Looking for Microsoft Excel Training Classes?

Find best tutors for Microsoft Excel Training Classes by posting a requirement.

- Post a learning requirement
- Get customized responses
- Compare and select the best

Find best Microsoft Excel Training Classes in your locality on UrbanPro

Post your learning requirement