AVERAGEIF Function in Excel
PNRao2022-06-17T03:54:42+05:30AVERAGEIF Function in Excel find the Average of all numbers in a range based on a given criteria. Learn Formulas, Excel and VBA with examples explained.
Pivot Tables in Excel VBA – Explained with Examples!
PNRao2013-03-01T00:00:00+05:30Pivot tables in Excel VBA helps us to create summary tables and analyzing our data - Examples to Create Pivot tables, Pivot Charts and Calculated Fields.
IF Function in Excel – Formula Explained with Examples
PNRao2022-06-17T03:54:34+05:30IF Function in Excel - formula helps us to check a condition, it returns one value if a specified condition is TRUE, or another value if the condtion is FALSE
Protect and Unprotect Excel Workbook using VBA
PNRao2022-06-17T03:53:35+05:30When we are dealing with confidential data we need to Protect Workbook in Excel VBA. So that user can enter password if he has and can view the data in the workbook.
CHOOSE Function in Excel – Formula Explained with Examples
PNRao2022-06-17T03:54:31+05:30CHOOSE Function in Excel - formula returns a value from a list of values based on a given index position. Learn Formulas, Excel and VBA with examples.
Hello World VBA- Writing Your First Macro
PNRao2022-06-17T03:55:53+05:30A step by step tutorial to write a simple Hello World VBA macro. Follow the below steps to do this to show the "Hello World!" message box to the user.
INDEX Function in Excel – Formula Explained with Examples
PNRao2022-06-17T03:54:31+05:30INDEX Function in Excel - formula returns either the value or the reference to a value from a table or range. Learn Formulas, Excel and VBA with examples.
MATCH Function in Excel – Formula Explained with Examples
PNRao2022-06-17T03:54:30+05:30MATCH Function in Excel - formula searches for a value in an array and returns the relative position of that item. Learn Formulas, Excel and VBA with examples.
Protect and UnProtect Worksheets in Excel VBA
PNRao2022-06-17T03:53:28+05:30Protect UnProtect Worksheet in Excel VBA if you want to restrict the users to not to modify the structure of the worksheet. You can find more examples here.
Record Macro in Excel
PNRao2022-06-17T03:52:14+05:30The Macro Recorder is a very useful tool available in Microsoft Excel, you can Record Macro in Excel if you want to automate any repetitive task. It helps to save the process time and avoid the human errors. In this section you will learn how to record a macro to automate repetitive task.
Select Cell Range in Excel VBA
PNRao2022-06-17T03:52:57+05:30We select cell range in Excel VBA to do particular task with the selection. For example we may want to change the background color of a range and we may want to change the font to Bold. In this case we do not required to loop each and every cell of the range to change the background color and font.
Introduction to SAS
PNRao2026-03-17T18:33:02+05:30In this topic I am giving an Introduction to SAS, [...]