Excel Macro Training

Excel Macro Training

Trending Questions and Lessons

Follow 1,062 Followers

Ask a Question

Feed

All

All

Lessons

Discussion

Lesson Posted on 13 Jun Advanced C++ IT Courses/Programming Languages/C Language IT Courses/Programming Languages/C++ Language +3 Excel Macro Training Excel VBScript Training Excel VBA Training less

Compiler vs Interpreter

Umasankar N.

Software Professional Trainer and Consultant with 22+ years of software design & development experience...

Compiler Interpreter Convert all the code into binary format and execute. Convert one statement at...

Comments
Dislike Bookmark

Lesson Posted on 10 Jun Excel Macro Training Excel VBA Training Excel VBScript Training +4 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training less

Concatenate Function

Saburudeen MA

I started my teaching carrier since i was doing my UG, as part time faculty in a computer institute....

Concatenate , one of the text functions, to join two or more text strings into one string. The Excel...

Comments
Dislike Bookmark

Lesson Posted on 08 Jun IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel +3 Excel Macro Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training less

Datedif() Function

Saburudeen MA

I started my teaching carrier since i was doing my UG, as part time faculty in a computer institute....

Purpose: This function calculates difference between two dates. it can show the result in days, months...

Comments
Dislike Bookmark

Looking for Excel Macro Training

Find best Excel Macro Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 07 Jun IT Courses/Advanced VBScript Excel Macro Training Excel VBA Training +4 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel less

Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.

Karthik Dale

II have 8 years of Data Analytics Experience. I have extensive experience in wide range of Excel Automation...

In Column “C”, I have product list and some of them are duplicates. My requirement is to...

Comments
Dislike Bookmark

Lesson Posted on 06 Jun Excel Macro Training Excel VBA Training Excel VBScript Training +1 IT Courses/MS Office Software Training/MS Access less

VBA Fixed And Variable String

Umasankar N.

Software Professional Trainer and Consultant with 22+ years of software design & development experience...

VBA (Excel VBA, Access VBA, Word VBA, Outllook VBA, Power Point VBA, MS Project VBA) defined two types...

Comments
Dislike Bookmark

Lesson Posted on 06 Jun Excel Macro Training Excel VBScript Training Excel VBA Training +1 IT Courses/MS Office Software Training/MS Access less

VBA Static Array Vs Dynamic Array

Umasankar N.

Software Professional Trainer and Consultant with 22+ years of software design & development experience...

There are two types of array in VBA, Static array and Dynamic array. Static array: Array is dimenstioned...

Comments
Dislike Bookmark

Looking for Excel Macro Training

Find best Excel Macro Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 06 Jun Excel Macro Training Excel VBA Training IT Courses/Advanced VBScript +2 Excel VBScript Training IT Courses/MS Office Software Training/MS Access less

Early Binding vs Late Binding

Umasankar N.

Software Professional Trainer and Consultant with 22+ years of software design & development experience...

Binding is a process of matching function calls written by the programmer to the actual code (internal...

Comments
Dislike Bookmark

Lesson Posted on 30 May IT Courses/Advanced VBScript Advanced Computer Course coaching IT Courses/MS Office Software Training/Microsoft Excel Training +4 IT Courses/MS Office Software Training Excel VBA Training Excel Macro Training IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training less

Excel Tip: Use Index Or Match Instead Of Vlookup Or Hlookup.

Karthik Dale

II have 8 years of Data Analytics Experience. I have extensive experience in wide range of Excel Automation...

Hi, In today's Excel topic we will see how Index & Match function is superior than Vlookup/Hlookup. With...

Comments
Dislike Bookmark

Lesson Posted on 27 May Excel Macro Training Excel VBA Training IT Courses/MS Office Software Training/Microsoft Excel Training

Difference between Find and Search Function in excel

Umasankar N.

Software Professional Trainer and Consultant with 22+ years of software design & development experience...

In excel there are two functions which are taking same arguments and return type. SEARCH() --> Search...

Comments
Dislike Bookmark

Looking for Excel Macro Training

Find best Excel Macro Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 24 May Excel Macro Training Excel VBA Training Excel VBScript Training +4 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training less

Excel Tip: VLOOKUP formula limitations

Karthik Dale

II have 8 years of Data Analytics Experience. I have extensive experience in wide range of Excel Automation...

1. Vlookup is not case-sensitive 2. If Lookup value has duplicates in the lookup column, then it returns...

Comments
Dislike Bookmark

Overview

Lessons 24

Total Shares  

Top Contributors

Connect with Expert Tutors & Institutes for Excel Macro Training

x

Ask a Question

Please enter your Question

Please select a Tag