UrbanPro
true

Find the best tutors and institutes for Microsoft Excel Training

Find Best Microsoft Excel Training classes

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Microsoft Excel Training Updates

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

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 29 Jan IT Courses/MS Office Software Training/Microsoft Excel Training/PowerPivot in Excel Functional Training/Data Analytics

GAGAN GUPTA

Experienced Business Analyst with skilled in Excel,VBA,SQL,Tableau,Power BI and Alteryx

Hi If you want to embed your report in your personalised web application, then you will need to take a screenshot of your work and then use it as a picture on your application. You can't use Power BI functionality in your personal app.
Answers 3 Comments
Dislike Bookmark

Lesson Posted on 21/07/2020 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training

How to add bullets Point in MS-EXCEL

Pradeep Agrawal

Qualified Software Engineer about to 11+ Year s experience in Training, Data Analysis, MIS reporting...

There is no direct option to add bullets in EXCEL. So we can create the bullets by the following steps: 1. Select the range where you want to apply the bullets.2. go to formate cell ==> Custom Formate.3. delete the General word and do following.4. add five blank space.5. add your symbol with Alt+7... read more

There is no direct option to add bullets in EXCEL. So we can create the bullets by the following steps:

1. Select the range where you want to apply the bullets.
2. go to formate cell ==> Custom Formate.
3. delete the General word and do following.
4. add five blank space.
5. add your symbol with Alt+7 then add one space.
6. type @ and press ok.

 

read less
Comments
Dislike Bookmark

Looking for Microsoft Excel Training classes

Find best Microsoft Excel Training classes in your locality on UrbanPro.

FIND NOW

Lesson Posted on 02/07/2020 IT Courses/MS Office Software Training/Microsoft Excel Training/MS Excel IT Courses/MS Office Software Training/Microsoft Excel Training/MS Excel Formulas IT Courses/MS Office Software Training/Microsoft Excel Training/MS Excel Functions +6 IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Basics of MS Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Excel Tutorial IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Auto Filter in Excel less

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below...

Ankur Sharma

(1) 11+ Years of Professional Experience - from MNCs to Entrepreneurship to Start-ups (2) Years of hands-on...

In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales Amount column, click on Filter drop-down.Step 3) Take Your cursor to Number Filters. A-List of... read more

In the following, You would find lesser-known, unexplored yet Powerful Features of Filter.

Please refer to sample dataset below:

To do Data Analysis:
Step 1) Apply Filter on the dataset.
Step 2) In Sales Amount column, click on Filter drop-down.
Step 3) Take Your cursor to Number Filters. A-List of Options will open up.
As highlighted in the screenshot below:
i) Please click on Top 10 - to see list of Top 10 Performers OR Bottom 10 Performers
ii) Please click on Above Average - to see list of Above Average Performers
iii) Please click on Below Average - to see list of Above Average Performers

 

Likewise, in the Date column, if You click on Filter drop-down, and take the cursor to Date Filters, a List of Options will open up.
As highlighted in the screenshot below, the Options will allow You to do Data Analysis across different periods, in a Click.

 

Isn't this Cool. Data Analysis in Few Clicks!

 

read less
Comments
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

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

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

Nev L.

MS Excel is an extremely versatile and flexible tool. You will be able to perform simple tasks like data entry to running simple analysis to sophisticated data modelling. In short, it can do nothing or a lot, depending on the problem you are trying to solve. Some of the critical things you should master... read more

MS Excel is an extremely versatile and flexible tool. You will be able to perform simple tasks like data entry to running simple analysis to sophisticated data modelling. In short, it can do nothing or a lot, depending on the problem you are trying to solve.

 

Some of the critical things you should master in Excel are:

Data Scrubbing: Getting your dataset “ready” for analysis. This involves (but isn’t limited to) looking for missing info, identifying outliers (these can hurt a lot when computing averages), creating derived fields using TEXT(), MONTH(), YEAR() etc.

 

Data Analysis: Running moderately complex analysis (using pivot tables, VLOOKUP(), MATCH() & INDEX, SUMPRODUCT(), SUMIF(), COUNTIF() etc. Asking questions of the data and looking for answers.

 

Presentation: Once the data has been crunched and insights found, presenting the data in a clear, crisp and concise manner is critical. This is where you can demonstrate your prowess as an Excel power user.

 

VBA: Once you have a good handle on the above, you can look at developing macros/procedures in VBA to extend Excel functionality.

 

I have tried to capture the thought process behind using Excel and not necessarily be (overly) prescriptive. If you can nail the thought process, you will discover the nuances yourself. Being an Excel savant myself, I can tell you that there is a lot of fun you can have in Excel, problems abound all around you that you can use Excel to analyze. 

 

All the Best!

read less
Answers 1 Comments
Dislike Bookmark

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

Nev L.

Following are some of the tips that you can use in MS Word. A. The Microsoft office was be started in Safe mode. One of the most common uses is to disable a Word add-in that is behaving erratically. You can use Safe mode to suppress any customizations made to the program. One would use to take screenshots... read more

Following are some of the tips that you can use in MS Word.

A. The Microsoft office was be started in Safe mode. One of the most common uses is to disable a Word add-in that is behaving erratically. You can use Safe mode to suppress any customizations made to the program. One would use to take screenshots of the default word instead of the customized screen.

 

B. You can disable the start screen because it can be an annoyance for regular word users. You can disable it by Ribbon>File>Options>General.

 

C. You can use The Touch or Mouse mode for more Precise Taps, Large fingers and a touch-enabled screen, that is a recipe for a few disastrous taps. Word '13 offers a Touch or Mouse Toggle that makes working on touch-enabled screens far easier by enlarging the buttons and increasing the distance between them. You will be able to do that by clicking on the drop-down arrow on the right side of Quick Access Toolbar and select Touch or Mouse Mode from the list.

 

D. To remove double spaces; here is a quick and easy tip.

Select all text in the document. Open Find and Replace from the Navigation pane (View > Show > Navigation Pane) or press CTRL+H. You need to Place the cursor on the Find what field, then press the Spacebar twice to insert two spaces. Place your cursor in the Replace with a field, then press the Spacebar once.

 

Hope this helps!

read less
Answers 1 Comments
Dislike Bookmark

Looking for Microsoft Excel Training classes

Find best Microsoft Excel Training classes in your locality on UrbanPro.

FIND NOW

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

Nev L.

You can use these tips while writing VBA Codes. 1. Use the application screen updating at the starting of the coded so that the user can see the final results directly instead of looking at the whole process of doing the activities which do not look good. 2. Using the Application.Display Alerts to... read more

You can use these tips while writing VBA Codes.

1. Use the application screen updating at the starting of the coded so that the user can see the final results directly instead of looking at the whole process of doing the activities which do not look good.

 

2. Using the Application.Display Alerts to stop showing any alerts in between running the macro. 

 

3. Using Application.Calculation to speed up your macro and calculate the values in the macro when needed.

 

4. Using Application.Status Bar which helps the user to know precisely at what process the macro is doing and how much time would it takes to complete the task.

 

5. Using Objects (Like-Worksheets, Range. With etc.) as much as you can, which helps you to speed up and improve the performance of the macro.

 

6. If you have a big macro code, then it is suggested to build in parts and always comment which helps to read the code and very quickly whenever changes required.

 

7. Declaring variable names which helps the coder to understand which variable is used for which purpose.

 

VBA in Excel can be used in several MS Excel-based Automation use cases. For example, if you want to capture sales orders from users Computer using Excel, then you can use Sales Order capture tools - Excel-based VBA application. 

 

Hope this helps.

read less
Answers 1 Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best Microsoft Excel Training classes in India. Post Your Requirement today and get connected.

Overview

Questions 508

Lessons 168

Total Shares  

+ Follow 125,006 Followers

Related Topics

Top Contributors

Connect with Expert Tutors & Institutes for Microsoft Excel Training

x

Ask a Question

Please enter your Question

Please select a Tag

X

Looking for Microsoft Excel Training Classes?

Find best tutors for Microsoft Excel Training Classes by posting a requirement.

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

Looking for Microsoft Excel Training Classes?

Find best Microsoft Excel 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 55 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 7.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