UrbanPro
true

Learn MS Office Software Training from the Best Tutors

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

Search in

Learn MS Office Software Training with Free Lessons & Tips

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Answered on 30 Mar Learn Advanced Excel

I have Professional MS Excel teaching experience I want to join as a trainer, what we should do.

Dheeraj Kushwaha

Adobe Certified , Microsoft Certified Trainer with 9 years of experience

You can easily do registration at the given website -https://www.urbanpro.com/register for free. Fill the tutors form with the required requisites as asked in the form. Incase you intend to have faster growth can alway upgrade your membership.
Answers 1 Comments
Dislike Bookmark

Lesson Posted on 29 Jan Learn Excel Tutorial +5 Excel Dashboard Excel INDEX Excel VBA & Macro Training Microsoft Excel Training Advanced Excel

Pivot table - Transform numbers in calculated field

Phanitha P

Basic to advance Excel tutor with 8 years of teaching experience Training provided based on student...

How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking on the field representing the numbers (available below). Example : Name: Price(in Mn) Formula... read more

How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source.

Name the field in the Calculated field and apply the formula by Double-clicking on the field representing the numbers (available below).

Example :

Name: Price(in Mn)

Formula := 'Total price' / 10^6  ---> to covert into millions.

Now here comes the new field with Price(in Mn) in the pivot table. Now we can remove or add it later as per our requirement

 

read less
Comments
Dislike Bookmark

Asked on 20 Jan Learn Excel Dashboard

How to login as a freelancer in Urban Pro? not as Tutor

Answer

Learn MS Office Software Training from the Best Tutors

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

Lesson Posted on 06/07/2021 Learn Advanced Excel +1 Excel VBA & Macro Training

Advanced Excel and VBA concept

Nagadarshan

I am a Microsoft Certified Trainer and I have more than 6 years of experience in the teaching field,...

In this video, learn about Advanced Excel: - Data Input and Hidden Features, - Worksheet Navigation, - Excel Formulas & Functions, - Data Cleaning and Formatting. VBA and its useful Built-in Functions, Debugging, Error Handling & Procedure Scope and more. read more

In this video, learn about Advanced Excel:

- Data Input and Hidden Features,

- Worksheet Navigation,

- Excel Formulas & Functions,

- Data Cleaning and Formatting.

VBA and its useful Built-in Functions, Debugging, Error Handling & Procedure Scope and more.

 

read less
Comments
Dislike Bookmark

Lesson Posted on 06/07/2021 Learn Microsoft Excel Training

Excel Conditional Formatting

Mukesh Chopra

I am an enthusiastic trainer with a total 30 years of IT-experience Believing in performing training...

In this video, learn about Conditional Formatting, Creating Conditional Formatting Rules, Use Conditional Formatting Presets, Managing & Removing Conditional Formatting.
Comments
Dislike Bookmark

Learn MS Office Software Training from the Best Tutors

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

Lesson Posted on 25/03/2021 Learn Microsoft Excel Training

Vlookup in excel

Shilpa Jain

I am a corporate expert Trainer in Basic, Advance & Expert Excel, Tableau, Ms. Access, Power BI Tools,...

Vlookup is a very useful formula in excel. Vlookup can be used in two ways Exact and approximate. We can find and fill in data with the help of Vlookup. The syntax of Vlookup is: Vlookup (Lookupvalue, Table array, Column number, Range lookup) lookup value is the value which ypu want to search from... read more

Vlookup is a very useful formula in excel. Vlookup can be used in two ways Exact and approximate. We can find and fill in data with the help of Vlookup.

The syntax of Vlookup is: 

Vlookup (Lookupvalue, Table array, Column number, Range lookup)

lookup value is the value which ypu want to search from data.

Table array is the complete range of data.

The column number is the number of the column from the data which you want to find out.

Range lookup is the exact match (0) or approximate match (1).

Id name

1   Shilpa

2  Deepak

3 Pooja

Id  name

2  Vlookup( Id number(2), full data (id,name), 2 (column number of name column), 0( exact match).

Thanks.

For more info search my profile, Shilpa Jain.

read less
Comments 1
Dislike Bookmark

Lesson Posted on 03/02/2021 Learn Excel VBA & Macro Training

Macro Recording

Gagan

Comments
Dislike Bookmark

Answered on 08/02/2021 Learn Python +1 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

Learn MS Office Software Training from the Best Tutors

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

Answered on 05/12/2021 Learn Microsoft Excel Training

Swati Agarwal

Learning by understanding helps you remember the concept

Excel is one of the tools that is most widely used by people all over the world, As others have said, it is a very vast topic, but the basics can be learnt in 10-15 hours. And there are many additions to it, like VBA/Macros.. which will take an additional 20+ hours.There is so much in that that if you... read more

Excel is one of the tools that is most widely used by people all over the world, As others have said, it is a very vast topic, but the basics can be learnt in 10-15 hours. And there are many additions to it, like VBA/Macros.. which will take an additional 20+ hours.
There is so much in that that if you do not practice it along with your classes it will be there just in the notes. Practicing it is very important. Fess can be variable according to the course and tutor. 

read less
Answers 52 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 524

Lessons 219

Total Shares  

+ Follow 19,348 Followers

You can also Learn

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?

The best tutors for MS Office Software Training Classes are on UrbanPro

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

Learn MS Office Software Training with the Best Tutors

The best Tutors for MS Office Software Training Classes are on UrbanPro

Book a Free Demo

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