UrbanPro
true

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Learn Basic Excel with Free Lessons & Tips

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Lesson Posted on 17/07/2022 Learn Basic Excel +3 Microsoft Excel Training Advanced Excel Auto Filter in Excel

Learn in Excel To Create a LIST in One Minute

Sanjay Singh

I am Professor teaching advance excel to MBA students. I have more than 20 years of corporate experience. I...

https://vz-3ad30922-ba4.b-cdn.net/f773e4aa-5f17-41f9-8b79-6acd58c81307/play_480p.mp4
Comments
Dislike Bookmark

Lesson Posted on 02/07/2020 Learn Basic Excel +8 MS Excel MS Excel Formulas MS Excel Functions Basics of MS Excel Advanced Excel Excel Tutorial Microsoft Excel Training Auto Filter in Excel

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

Lesson Posted on 01/04/2020 Learn Basic Excel +4 MS Excel Basics of MS Excel Advanced Excel Microsoft Excel Training

Tips - How to put PivotTable Field List back at its Original Position?

Ankur Sharma

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

Have You ever struggled to put PivotTable Field List back at its Original Position?*Original Position - right-side of the worksheet, as highlighted in the following picture: If Your answer is Yes, You should find the following helpful. Q) How to move PivotTable Field List back at its Original Position?... read more

Have You ever struggled to put PivotTable Field List back at its Original Position?
*Original Position - right-side of the worksheet, as highlighted in the following picture:

If Your answer is Yes, You should find the following helpful.

Q) How to move PivotTable Field List back at its Original Position?
A) Double-click on its Header. *Header = where PivotTable Fields is written
PivotTable Field List could be anywhere on the worksheet. If You double-click on its Header, it will move back to its Original Position.

Note: closing and re-showing Field List will not put Field List back at its Original Position. Field List will re-show where it was just before it was closed.

read less
Comments 1
Dislike Bookmark

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • Flexible Timings
  • Choose between 1-1 and Group class
  • Verified Tutors

Answered on 03/03/2020 Learn Basic Excel +2 Microsoft Excel Training Advanced Excel

Apoorva P.

You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you observe the way in which do things step by step. A number of Youtube channels upload videos for the... read more

You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you observe the way in which do things step by step. A number of Youtube channels upload videos for the same, and they are free in most circumstances. You can easily subscribe to any such channel and learn Excel at your own pace. But if that doesn’t help, try getting a teacher for some one-on-one classes

read less
Answers 7 Comments
Dislike Bookmark

Answered on 05/03/2020 Learn Basic Excel +2 Microsoft Excel Training Advanced Excel

Apoorva P.

The best way to learn Excel for accounting is by both reading and ding. It is one thing to use Excel; it is another to understand the capabilities that are available to you and attempting to make use of them. Having an application on which to apply your newly acquired skills is a great way to get started.... read more

The best way to learn Excel for accounting is by both reading and ding. It is one thing to use Excel; it is another to understand the capabilities that are available to you and attempting to make use of them.

 

Having an application on which to apply your newly acquired skills is a great way to get started. What may start as a simple project could become a much more sophisticated application in a relatively short period.

 

To become an expert is to know everything there is to know about Excel. This means reading and doing a lot with Excel. One should read more than a fair share of books and continue to learn every day as software technologies continue to evolve.

 

Once you become comfortable working with Excel (and VBA for Excel), you will learn to ask questions that will stretch beyond the realm of current common knowledge and tread into the unknown.

 

read less
Answers 3 Comments
Dislike Bookmark

Answered on 05/03/2020 Learn Basic Excel +2 Microsoft Excel Training Advanced Excel

Apoorva P.

It depends on which field of Civil Engineering you want to pursue. There are a couple of courses that might need to take. This differs from one domain to another. If you're opting for structural engineering, then you should have good knowledge in softwares like STAAD, AUTOCAD etc. In Quality Control... read more

It depends on which field of Civil Engineering you want to pursue. There are a couple of courses that might need to take. This differs from one domain to another. If you're opting for structural engineering, then you should have good knowledge in softwares like STAAD, AUTOCAD etc. 

 

In Quality Control and Quality assurance, you can take up practical courses which involve experiments and projects involving testing. There are a number of QC tests, which you should know in detail. Apart from these, you can also read about Infrastructure Finance, Project Finance, Construction Planning and Management. 

 

These topics are fundamentally different from the specialised courses, and it will provide you with a new perspective to see the construction industry.

read less
Answers 4 Comments
Dislike Bookmark

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • Flexible Timings
  • Choose between 1-1 and Group class
  • Verified Tutors

Answered on 10/03/2020 Learn Basic Excel +2 Microsoft Excel Training Advanced Excel

Charlie

Of course, you would also be knowing that an ample amount of content is available online. You can refer to many videos, and at the same time you can practice those things as well, Not to be cliche but practise is very important in learning excel. Now coming to the VBA part, it needs some logical thought... read more

Of course, you would also be knowing that an ample amount of content is available online. You can refer to many videos, and at the same time you can practice those things as well, Not to be cliche but practise is very important in learning excel. Now coming to the VBA part, it needs some logical thought process and a little bit of programming background. It would be an added advantage if you have some knowledge of programming, but it is not mandatory. The best is the free sources online, you don't have to pay anything and you have the liberty to choose from many sources. If you find some parts to be difficult, you can always find online tutors too.

All the best.

 

read less
Answers 2 Comments
Dislike Bookmark

Answered on 12/05/2020 Learn Basic Excel

Abhay

Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results. Microsoft... read more

Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

Microsoft Word is a word processing program designed to make it possible to create a variety of documents that will look the same between different computers and similar on the screen to how they appear on paper. It's used by businesses and individuals to write personal and professional letters, reports for work and school and to take notes on conversations and in seminars and classes. Because it's so widely used, many businesses appreciate that it's possible to send documents created in Word to clients, employees and other business associates without worrying about whether or not they'll be able to open them.

But, unlike MS Word, Excel organises the data into rows and columns, the intersection of which is called a cell. A cell can contain various data forms such as numbers, alphabets, dates, or formulae. It is an efficient tool which helps to organise the data and analyse it with the help of charts, bar graphs, pivot tables etc.

In today’s world, Excel is prominently used in every aspect of life, be it, maintaining personal expenses, or organising a large set of data in an organisation. With the efficiency it possesses, excel has become a necessary tool in every organisation, and every person should have a knowledge of it. 

read less
Answers 1 Comments
Dislike Bookmark

Answered on 12/05/2020 Learn Basic Excel

Abhay

Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results. Microsoft... read more

Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

Microsoft Word is a word processing program designed to make it possible to create a variety of documents that will look the same between different computers and similar on the screen to how they appear on paper. It's used by businesses and individuals to write personal and professional letters, reports for work and school and to take notes on conversations and in seminars and classes. Because it's so widely used, many businesses appreciate that it's possible to send documents created in Word to clients, employees and other business associates without worrying about whether or not they'll be able to open them.

But, unlike MS Word, Excel organises the data into rows and columns, the intersection of which is called a cell. A cell can contain various data forms such as numbers, alphabets, dates, or formulae. It is an efficient tool which helps to organise the data and analyse it with the help of charts, bar graphs, pivot tables etc.

In today’s world, Excel is prominently used in every aspect of life, be it, maintaining personal expenses, or organising a large set of data in an organisation. With the efficiency it possesses, excel has become a necessary tool in every organisation, and every person should have a knowledge of it.

read less
Answers 1 Comments
Dislike Bookmark

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • Flexible Timings
  • Choose between 1-1 and Group class
  • Verified Tutors

Answered on 12/05/2020 Learn Basic Excel

Abhay

The essential functions are Index and Match. Index formula is where you can call a reference of a cell in an array based on its location as rows and columns. We use match formula to find the position of a specific value in a selected cell range. This is for those who have some or little knowledge of... read more

The essential functions are Index and Match. Index formula is where you can call a reference of a cell in an array based on its location as rows and columns. We use match formula to find the position of a specific value in a selected cell range. This is for those who have some or little knowledge of excel. But if you are fresh to excel, then, it is best to start by entering data into a worksheet, enter numbers as text, flash fill, necessary calculations, copying formulas, using auto calculate. Autosum, average, how to edit formulas, absolute cell reference, freeze panes, moving/copying/deleting data, formatting, list auto-fill, printing

Master, all that, learn shortcuts for some of these necessary actions and you’ll have a reasonable foundation to move on to more topics.

The next step is to work on naming worksheets, reorder sheets, move/copy sheets, insert sheets, linking worksheets and workbooks, paste a link, managing links in workbooks, data validation, protection, conditional formatting, creating and editing charts.

Learning the above-mentioned skills in Excel will make you ready for the tasks that are often used in a typical organisation.

Know all that lot as well, and you’ll find yourself in the above-average group of excel users.

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 95

Lessons 31

Total Shares  

+ Follow 143,779 Followers

You can also Learn

Top Contributors

Connect with Expert Tutors & Institutes for Basic Excel

x

Ask a Question

Please enter your Question

Please select a Tag

X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

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