Object oriented programming is on of the most important concepts in programming and we discuses what it means in this video
Tag: Excel
HLOOKUP Function in Excel
HLOOKUP function will help you to find a value in a row of sheet and will return another value from another row in same column of first value
VLOOKUP NA ERROR
When VLOOKUP function resulted to NA, then it mean it can find the interested value in the table, however, there are the times that you have interested value in the table, still vlookup function results to NA error. In this video we talk about these situations and how it can be handled.
How to edit Macro code in VBA
Assume that you record a Macro in Excel and you want to change some of its code to make it more practical, so we need to go to the VBA environment and do our modification there
VLOOKUP Function in Excel
VLOOKUP function finds a value in a table or array and then return a value which is in the same row but another column
LOOKUP Function in Excel
Lookup function will find a user defined value in a vector and then return another value which is same position of first value in another vector with same size of first vector
01 Introducing Macro and programming in Excel
In this video we start the VBA programming course in Excel by introducing Macro and VBA programming in general
AND OR function in Excel
The And function check if all statements to be true, and if so, it will return the True result, otherwise, if one of the statements be false, then it will return the False value.
The OR function check if at least one of the statements be true, if so, then it will return the True value. Otherwise, if all of the statements be false, then it will return the false value
IF function in Excel
IF function check if an one operation is True or false, then based on the result its don an operation (if its true) and another operation if it is False
SUBSTITUTE function in Excel
SUBSTITUTE replaces part of a text string, based on the characters you specify, with a different text string. This function is categorized as a String/Text Function. In this video we described how to use SUBSTITUTE function in different situations.