Learn MS Office Software Training from the Best Tutors
Search in
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
Lesson Posted on 29 Jan Learn Excel Tutorial
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 := '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
Asked on 20 Jan Learn Excel Dashboard
How to login as a freelancer in Urban Pro? not as Tutor
Learn MS Office Software Training from the Best Tutors
Lesson Posted on 06/07/2021 Learn Advanced Excel
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 less
Lesson Posted on 06/07/2021 Learn Microsoft Excel Training
Mukesh Chopra
I am an enthusiastic trainer with a total 30 years of IT-experience Believing in performing training...
Answered on 04/05/2021 Learn IT Courses
CADD Centre Training Services
Learn MS Office Software Training from the Best Tutors
Lesson Posted on 25/03/2021 Learn Microsoft Excel Training
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 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 lessAnswered on 08/02/2021 Learn Python
Daniel Mekala
Learn MS Office Software Training from the Best 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 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.
UrbanPro.com helps you to connect with the best MS Office Software Training in India. Post Your Requirement today and get connected.
Ask a Question
The best tutors for MS Office Software Training Classes are on UrbanPro
The best Tutors for MS Office Software Training Classes are on UrbanPro
Book a Free Demo