In this video we introduce you the basic meaning of module , functions and sub in vba
Object oriented programming is on of the most important concepts in programming and we discuses what it means in this video
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
In this video we start the VBA programming course in Excel by introducing Macro and VBA programming in general
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.
REPLACE replaces part of a text string, based on the number of 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 REPLACE function in different situations.
The Microsoft Excel T function returns the text referred to by a value. The T function is a built-in function in Excel that is categorized as a String/TextFunction. It can be used as a worksheet function in Excel
In this video we described how to use T function in different situations
The EXACT function compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document. In this video we described how to use EXACT function in different situations.
Dashboard is one of the best way to have data status under control. We use dashboard to control the status of situations in time line and to report them to management. In this video we show how to develop a simple management dashboard in Excel
The Excel TEXTJOIN function concatenates (joins) values with a given delimiter. Unlike the CONCAT function, TEXTJOIN allows you to supply a range of cells, and has a setting to ignore empty values.
In this video we described how to use TEXTJOIN function in different situations.