true

Find the best tutors and institutes for MS Office Software Training

Find Best MS Office Software Training

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

MS Office Software Training Updates

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Lesson Posted on 03 Feb IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Macro Recording

GAGAN GUPTA

Experienced Reporting Analyst with a demonstrated history of working in the marketing and advertising...

Comments
Dislike Bookmark

Lesson Posted on 03 Feb IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Introduction to VBA editor

GAGAN GUPTA

Experienced Reporting Analyst with a demonstrated history of working in the marketing and advertising...

Comments
Dislike Bookmark

Lesson Posted on 03 Feb IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training IT Courses/MS Office Software Training/Microsoft Excel Training/Excel Dashboard

Range Selections

GAGAN GUPTA

Experienced Reporting Analyst with a demonstrated history of working in the marketing and advertising...

Comments
Dislike Bookmark

Looking for MS Office Software Training

Find best MS Office Software Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 03 Feb IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training IT Courses/MS Office Software Training/Microsoft Excel Training/Excel Dashboard

Multiple rows selections

GAGAN GUPTA

Experienced Reporting Analyst with a demonstrated history of working in the marketing and advertising...

Comments
Dislike Bookmark

Lesson Posted on 03 Feb IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training IT Courses/MS Office Software Training/Microsoft Excel Training/Excel Dashboard

Cell Properties

GAGAN GUPTA

Experienced Reporting Analyst with a demonstrated history of working in the marketing and advertising...

Comments
Dislike Bookmark

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

Excel VBA Macros - Record Macro

Gokul

I am working as automation engineer I can take classes in rpa, vba macros and in machine learning. I...

If you are New to VBA Macro for Excel Automation, please follow step by step you can automation your Task. Step First - Enable the Developer Tab (This Tab is only for Macro Development) Goto -> Options ->Customize Rippon -> Enable "DEVELOPER" once you're done, you can find additional Tab... read more

If you are New to VBA Macro for Excel Automation, please follow step by step you can automation your Task.

Step First - Enable the Developer Tab (This Tab is only for Macro Development)

Goto -> Options ->Customize Rippon -> Enable "DEVELOPER" 

once you're done, you can find additional Tab name called Developer.

Step Two - Record Macro and Shortcut key Creation

In the Developer tab, you have an option called Record Macro. once you clicked that -> you will see another window to give Shortcut Key. (Conditions to follow while giving shortcut key - Shortcut key should not be a Keyboard Short cut keys because using keyboard shortcuts system won't work as expected).

Step Three - Record your Activities

Once we are done with the Shortcut Key Creation System, start to record your actions (Your actions should be only keyboard actions mouse actions will not record) 

Important Note: Only Excel Window Keyboard actions record, Keyboard actions can perform whatever we want

Step Four - Stop Recording

We need to stop the recording once we are done with our keyboard actions, in the Developer tab you have an option to STOP (Same button where we select the Record Macro)

Step Five - Run Macro (What we Recorded)

Once we are done with Everything, this is the Output or Final step Press Shortcut key we created while recording.

read less
Comments
Dislike Bookmark

Answered on 08 Feb IT Courses/Programming Languages/Python IT Courses/MS Office Software Training/Microsoft Excel Training/Excel Dashboard

Daniel Mekala

Hi, as far as my knowledge goes first, you should learn data processing tools or programs like MS Excel, Power Bi, or SQL then you should then take a leap into Python, which will make automating your work quite simple.
Answers 49 Comments 2
Dislike Bookmark

Answered on 30/05/2020 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel Dashboard

Vaskar Das

Enter DOB in one cell. For example in Cell A1. Then in the cell where you want to calculate Age there write as =(TODAY()-A1)/365.25 .25 has been added to the 365 because to accommodate the leap year days in between.
Answers 24 Comments
Dislike Bookmark

Answered on 02/12/2020 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

Aamir Mohammed

Vba developer, web scraping, data automation, advanced excel

You need to use application.sendkeys; search in google it will trigger the enter button.
Answers 1 Comments
Dislike Bookmark

Looking for MS Office Software Training

Find best MS Office Software Training in your locality on UrbanPro.

FIND NOW

Answered on 09/12/2020 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

Is there a way of exporting LinkedIn search results to an Excel spreadsheet or similar?

Aamir Mohammed

Vba developer, web scraping, data automation, advanced excel

You can do with web automation in VBA or try import XML function in Google spreadsheet, or you can use Google add-on parser or data miner. There are many ways to scrape data.
Answers 2 Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best MS Office Software Training in India. Post Your Requirement today and get connected.

Overview

Questions 521

Lessons 216

Total Shares  

+ Follow 18,667 Followers

Related Topics

Top Contributors

Connect with Expert Tutors & Institutes for MS Office Software Training

x

Ask a Question

Please enter your Question

Please select a Tag

X

Looking for MS Office Software Training Classes?

Find best tutors for MS Office Software Training Classes by posting a requirement.

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

Looking for MS Office Software Training Classes?

Find best MS Office Software Training Classes in your locality on UrbanPro

Post your learning requirement

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more