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 10/12/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Before analysis start Important

Amol Mane

I am working with international BPO/KPO company as business intelligence manager. I have worked with...

Hi All, Often we do analysis in day to day life, before we start we should follow few principles of data cleaning activities in any application such as removing unwanted space, converting data into correct data type and arrangements of required data, we have below option in excel 1- Use Delimited... read more

Hi All, 

Often we do analysis in day to day life, before we start we should follow few principles of data cleaning activities in any application such as removing unwanted space, converting data into correct data type and arrangements of required data, we have below option in excel

 

1- Use Delimited option to remove or separate the data as per requirements

2- Remove unwanted space

3- Convert data formating from text to number, Date, time etc

4- If required remove duplicate data

5- Sort data basis Criteria

6- Remove blank cells/rows/columns

7- Update proper heading of columns and don't keep any duplicate heading

8- Most important is to keep original data file separate  as work on a copy of data until you get the desired outcome 

read less
Comments
Dislike Bookmark

Lesson Posted on 31/10/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

EXCEL - Not just for the professionals but to make your daily life easy

Kunal Kansra

I have hands on experience of working on Excel and VBA programming language. I have also worked as a...

Microsoft Excel This course will focus on real-life applications of MS Excel and help you start from scratch to help build your macros to make your life easier. Apart from technical bits, we will work together to help unravel the analytical self in you by continually questioning the method proposed... read more

 

Microsoft Excel 

 

This course will focus on real-life applications of MS Excel and help you start from scratch to help build your macros to make your life easier. Apart from technical bits, we will work together to help unravel the analytical self in you by continually questioning the method proposed by me and trying to figure out easier and more efficient ways to solve the problems. Throughout the course, we will pick examples close to our environment so that the problems are more relatable and directly applicable (as opposed to the trigonometric problems that I barely have used since 12th grade). During the course of the course, we will be able to not only solve well-defined problems but also try and work together to define the problems and then work towards finding a probable solution. Now that I have detailed out the plan (well, too much detailing I must say with utmost guilt), we will begin with the first lesson towards making sure we have MS Excel at our disposal (rather than the other way round).

Excel Basics - The two guiding Pillars

Imagine Excel sheets as a blackboard/whiteboard but only more organized (someone did not want you to get lost out there!). In order to navigate this blackboard, we have our two guiding pillars - the rows (Pillar 1) and the columns (Pillar 2). Rows are represented by the numbers along the side of this board while the columns are represented by letter across the top of this board. While these are our guiding pillars, they also divide the sheet into small houses called 'Cells'. Each of the combinations of these numbers and letters help us locate one of the houses on the board called cells. Let's say I am told to go to Satya's house, without his house number I am not sure if I will ever be able to locate the right Satya (unless I am that Swiggy delivery guy who just knows it all). Just like I need a house number (say 123, block 4) to locate Satya, I need both the Rows' number and Columns' letter to be able to locate that tiny little house on my excel sheet.

Example: Locate Sandy's house at B5 on the Excel sheet

How do I do it?: I start with the top of the board and locate the letter B. I then move down, down and down till I hit the 5th small house in that column. Here I am at Sandy's

How else could I have done it?: I would have alternatively started with going down till the number 5 is highlighted. I then would have moved right till I reach the 2nd house in that row. Even this brings me to Sandy's (certainly all roads lead to Rome)

How else could this still have been done?: This, I leave upon to you and help me figure out how we could have done this and still be at Sandy's.

read less
Comments
Dislike Bookmark

Lesson Posted on 23/09/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel

What is save workspace?

Krishanu Paul

I have a Total experience of 11 years in domestic and MNC accounting. This experience includes 6 years...

Its an option in excel that help you to save a shortcut in particular place (may be your desktop). When you double click to open this shortcut it opens all the related excel files together from different folders including different sharedrives. When you use this option, you can save your time needed... read more

Its an option in excel that help you to save a shortcut in particular place (may be your desktop). When you double click to open this shortcut it opens all the related excel files together from different folders including different sharedrives.

When you use this option, you can save your time needed to open multiple excel files from different locations.. 

Connect with me and I will help you to learn hundred of these trick to become pro in excel. Additionally you will get your training videos on youtube for future reference.. 

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 31/05/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

VBA - Loop Demo

Vipin K

I have about six years experience on database side with data analytics , business intelligence, data...

Comments
Dislike Bookmark

Answered on 06/06/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Dheeraj Kumar Mishra

Ms Excel Trainer with 4 years of working experience

Hi Venkat, As per my opinion and experience, we are using VBA for reducing the repetitive task in excel. For example: Suppose every day you are preparing an attendance tracker in which you will mark present/absent or any other comment in the attendance section every day. Either you are using v-lookup... read more

Hi Venkat,
As per my opinion and experience, we are using VBA for reducing the repetitive task in excel. For example: Suppose every day you are preparing an attendance tracker in which you will mark present/absent or any other comment in the attendance section every day. Either you are using v-lookup or any other method to reflect desired remarks in the respective section, and you will spend 30min. Everyday. By using VBA, you can do the same thing within 2-3 min.
I would suggest you work on macro. Because in the macro, you will record the required steps for performing the specific task every day. It will increase your productivity.
I hope this will help you.

read less
Answers 5 Comments
Dislike Bookmark

Lesson Posted on 25/05/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Basic excel required for MIS position

Dheeraj Kumar Mishra

I have 4 year experience in reporting and analytics domain. I have extensive experience in MS excel,...

Dear Students, Today we will know about the mis and its importance in business world. In Business world, organisation's have many business problem related to process are exists. For taking any decision, first we will sure the effect of next course of action w. r. t issue. So we need the data.This data... read more

Dear Students, 

Today we will know about the mis and its importance in business world. In Business world, organisation's have many business problem related to process are exists. For taking any decision, first we will sure the effect of next course of action w. r. t issue. So we need the data.This data will be provide by mis executive to management.

Basic's of excel:

Text function: Trim, Left, Right, Mid, find, search etc. 

Lookup function: lookup, v-lookup, H-lookup, index match etc. 

Logical finction: if, and, or, if with and. If with or etc. 

Arithmetic function: sum function and its type, count function with its type etc. 

These are the basic skills required for MIS daily functionality. 

 

read less
Comments
Dislike Bookmark

Answered on 29/05/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training

Hi, what is the future growth in excel VBA, how much is the demand in the present?

Dheeraj Kumar Mishra

Ms Excel Trainer with 4 years of working experience

Hi Santosh, As per my opinion, you will know about VBA. As per current market, trend companies are looking for those persons who have expertise in excel and VBA. Because they want automation of different types of reports as required and provide maximum time to resources for analysis and finding critical... read more

Hi Santosh,
As per my opinion, you will know about VBA. As per current market, trend companies are looking for those persons who have expertise in excel and VBA. Because they want automation of different types of reports as required and provide maximum time to resources for analysis and finding critical insights from the stories.
You can learn VBA with your daily excel work.
First, you will work on macro then learn VBA coding. Learn at least one topic in a day.
I hope this will help you

read less
Answers 1 Comments 1
Dislike Bookmark

Answered on 28/03/2019 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training IT Courses/Adobe RoboHelp

Bikram Jeet

Tutor

As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team. VBA is for programmers who need to develop softwares. Learning VBA is like - How you learned Bi-cycle. You will learn it, but it would take you an year to master it. You need immediate... read more

As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team.

VBA is for programmers who need to develop softwares.

Learning VBA is like - How you learned Bi-cycle. You will learn it, but it would take you an year to master it. You need immediate returns of your invested time, to make more money, and should not waste your another 3-6 months.

read less
Answers 5 Comments
Dislike Bookmark

Looking for Microsoft Excel Training classes

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

FIND NOW

Answered on 11/03/2020 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training Exam Coaching/Foreign Education Exam Coaching/Advanced Placement Tests Coaching/Computer Science

Charlie

AutoCorrect is a Microsoft tool that helps us detect and correct typos, wrong spellings and case sensitive words in Microsoft Word. You can customise it according to your needs when you're exporting or importing from or to another computer. There are two ways by which you can export or import AutoCorrect... read more

AutoCorrect is a Microsoft tool that helps us detect and correct typos, wrong spellings and case sensitive words in Microsoft Word. You can customise it according to your needs when you're exporting or importing from or to another computer.

There are two ways by which you can export or import AutoCorrect from one computer to another: One is manually, and the other is by using Kutools for Word. For manually importing and exporting the files, you have to follow the steps:

- copy the Normal. dotm file on your computer to a destination the network can access.

- C:\Documents and Settings\username\Application Data\Microsoft\Templates locate his file on your destination computer, on which you want the data to be stored. To have a backup of the file, rename it to Normal.bak

- Close all the Microsoft applications and copy the Normal. dotm file and paste it in C:\Documents and Settings\username\Application Data\Microsoft\Templates on the destination computer. 

The procedure is much simpler using the Kutools  tool:

- Click Enterprise > Import / Export > AutoCorrect to export the AutoCorrect entries

- Select whatever you want to export and export it to files of the intermediate location, which is accessed by the destination computer.

- Then your AutoCorrect files will be exported to a specific folder. 

 

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 12

Lessons 34

Total Shares  

+ Follow 94,756 Followers

Related Topics

Top Contributors

Connect with Expert Tutors & Institutes for Excel VBA & Macro 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 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