true

Find the best tutors and institutes for MS Office Software Training

Find Best MS Office Software Training

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

MS Office Software Training Updates

Ask a Question

All

Lessons

Discussion

Lesson Posted on 21 Jul 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 Share

Lesson Posted on 02 Jul 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 Share

Answered on 30 May 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 23 Comments
Dislike Bookmark Share

Overview

Questions 519

Lessons 209

Total Shares  

+ Follow 18,197 Followers

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

Nev L.

First of all, MS Office applications such as MS Excel, Word, Powerpoint, Access are easy to learn. If you know the basics of computer operations such as saving the file, opening a file, left mouse button click, left mouse button click, scrolling the screen, then you can start learning now. The best... read more

First of all, MS Office applications such as MS Excel, Word, Powerpoint, Access are easy to learn. If you know the basics of computer operations such as saving the file, opening a file, left mouse button click, left mouse button click, scrolling the screen, then you can start learning now. 

 

The best way is to do it yourself, the more you do, the more you learn. The key to learning computer skill is by doing yourself. Understand what is the purpose of using Excel, or word, and start doing it.

 

To be very basic, Excel is a spreadsheet application. It has a lot of formulas to manipulate data, charts to present data in visual representation. MS Word is a document you can type, format, save, print, share thats it. Menus are very easy to understand; simple English or the language of your selection.

 

Refer videos online to understand more, search for each of the menu item you see in the excel one by one practice it with sample data. Start using excel or word for your business. If you find it difficult learning by yourself, then you can also seek experts’ guidance to accelerate your MS Excel learning process. 

 

Hope this helps. All the Best!

read less
Answers 1 Comments
Dislike Bookmark Share

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

Nev L.

Excel has a known issue (sluggishness) with Tables with a thousand rows where one or more columns contain cells with formulas. If you convert the Table into a range of cells (I know, it kind of defeat the excellent features of a Table), you will restore the speed to your workbook. Microsoft is aware... read more

Excel has a known issue (sluggishness) with Tables with a thousand rows where one or more columns contain cells with formulas. If you convert the Table into a range of cells (I know, it kind of defeat the excellent features of a Table), you will restore the speed to your workbook. Microsoft is aware of the issue.

 

If you are using array formulas that refer to entire columns, then it is advised to change those formulas so that they see to a more restricted range of cells, say rows 2 through 6000.

 

If you are using Volatile formulas, then those would be formulas using INDIRECT, OFFSET, RAND, NOW, or TODAY. Volatile formulas are recalculated whenever you enter data in any open workbook. As you might imagine, thousands of rows full of volatile formulas will spend a lot of time recalculating. In most cases, you can use alternative formulas that aren’t volatile. 

 

If you are using a lot of VLOOKUP formulas, then you make it a thousand times faster, if you sort the data table and then use the binary search form of VLOOKUP and MATCH.

These are some of the tips for decreasing the bogging down of Excel.

 

Hope this helps!

read less
Answers 1 Comments
Dislike Bookmark Share

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

Nev L.

To be honest! Neither you’ll be able to master in Excel by just reading a book nor by attending a training course and watching videos. Yes, books are helpful when it comes to learning certain things. For example, books which have the list of the formulas which cover the basics, formulas for all... read more

To be honest! Neither you’ll be able to master in Excel by just reading a book nor by attending a training course and watching videos. Yes, books are helpful when it comes to learning certain things. For example, books which have the list of the formulas which cover the basics, formulas for all purposes, formatting, charting and Intro to VBA etc. would be of great help in your learning process. But, only by reading those books, you’ll not abe to master in Excel. It is simply because, alongside theoretical knowledge, you also need practical experience to master in it. 

 

It would help if you learned it by taking one piece at a time by tackling problems you would care about in the job, personal life or classes. You can learn by asking questions to yourself like how you can analyze the data and how can you make the tedious task efficient and how can you make the workbook more persuasive. Analyzing a workbook built by someone skilled would be a great start.

As a learner, you must comprehend the fact that Excel is a skill that you cannot master in a few months. It takes time, patience and a lot of effort as it has many layers to unfold. 

 

Hope this helps you. All the best!

read less
Answers 1 Comments
Dislike Bookmark Share

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

Nev L.

The problem with Excel is that each step is easy, so it’s a bit like Lego. So very few people put in the effort to master what is a large and sophisticated set of tools, with a dozen different modes of operation. Thus, nearly every spreadsheet is awful and financial regulators are worried that... read more

The problem with Excel is that each step is easy, so it’s a bit like Lego. So very few people put in the effort to master what is a large and sophisticated set of tools, with a dozen different modes of operation. Thus, nearly every spreadsheet is awful and financial regulators are worried that they will cause the next financial crash; some say they created the last one.

 

A real Excel Expert is someone who can make it quickly do the things that are needed, knowing syntax is less important than the more in-depth knowledge of how things can be best achieved in Excel. Excel development is much more of a real-time thing; an expert knows when to prepare out a quick sheet and when to build something resilient and is skilled at extracting from users what they want without a formal specification.

 

A top-rate expert knows when to use MSTO to bring it more up to date and has the wisdom to know when to leave VBA and XL4 macros well alone and just patch.

 

One would be defined as an expert. A reasonably smart person can learn any feature of Excel just like Python, SQL or any other tool. What distinguishes an expert from someone who has merely used something a lot is their ability to make the right decisions. That’s what one would look for when selecting people to recommend.

 

Hope this helps

read less
Answers 1 Comments
Dislike Bookmark Share

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

Nev L.

Spreadsheets are basically to solve minute problems. You can make several random spreadsheets to track different things. You can make a spreadsheet to track your grades in school by reverse-engineering the grade book software you would use. You can also make a spreadsheet that would create a Sudoku... read more

Spreadsheets are basically to solve minute problems. You can make several random spreadsheets to track different things. 

 

You can make a spreadsheet to track your grades in school by reverse-engineering the grade book software you would use. You can also make a spreadsheet that would create a Sudoku puzzle by Random number generators. It will also help you solve a Sudoku puzzle by warning if you break a rule in the process.  Another funny use for excel is if you are married with a kid, you can create an excel sheet as to track whose day it is to change the diaper. Yeah, I know its crazy.

 

The most common spreadsheet one would think of is to track the expenses, by allocating a score out of 10 to each person and put in the total budget. The spreadsheet then proportionally allocated a budget to each person based on our score. The beauty of it was that when we bought a present, we'd put in how much we'd spent on an individual. 

 

The spreadsheet then worked out if we'd gone over or under budget then proportionally spread out the over/underspend to all remaining people on the list, ensuring that we remained within budget overall.

 

Hope this helps!

read less
Answers 1 Comments
Dislike Bookmark Share

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

Nev L.

A VLOOKUP can lookup data automatically instead of a person having to do it manually, so time-saving is the first benefit that springs to mind. How much time a VLOOKUP can save depends on the amount of time it takes a person to look up the data manually, how many records are being looked up and whether... read more

 

A VLOOKUP can lookup data automatically instead of a person having to do it manually, so time-saving is the first benefit that springs to mind. How much time a VLOOKUP can save depends on the amount of time it takes a person to look up the data manually, how many records are being looked up and whether the lookup function can be re-used to complete the same or similar tasks in the future.

 

VLOOKUP takes four arguments, in the following format:

VLOOKUP(Lookup_value, Table_array, Col_index_num, Range_lookup)

Lookup_value is the value that you want to search for.

 

Table_array is the array of data containing the lookup value and the column containing the data to be returned. The column containing the lookup value has to be the first column in the array.

 

Col_index_num is the column number at the array that you want to return values from.

 

Range_lookup is a TRUE/FALSE field indicating whether you want an exact or partial match. You’ll always want this to be False, for an exact match.

 

VLOOKUP is probably the most commonly used lookup function in Excel, but it’s not the only one, and depending on your situation, it might not be the best one. Other lookup options include HLOOKUP, INDEX MATCH or combinations of all these functions.

 

Hope this helps!

read less
Answers 1 Comments
Dislike Bookmark Share

Top Contributors

Connect with Expert Tutors & Institutes for MS Office Software Training

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

Nev L.

The companies or organizations which are wise provide Excel VBA access to employees as it helps increases productivity. Excel VBA access does not create information security risks, Per se'. The risk is instead that of bugs in the code resulting in bad decisions being made. The reason why VBA is so... read more

The companies or organizations which are wise provide Excel VBA access to employees as it helps increases productivity.  Excel VBA access does not create information security risks, Per se'. The risk is instead that of bugs in the code resulting in bad decisions being made.

 

The reason why VBA is so famous is that every Office user has access to it. If you have a problem, you can actually use VBA to automate the routine tasks in your job and increase productivity. And if you share those VBA tools with peers, you can multiply their productivity as well.

 

Information security risks occur if parties gain access to corporate databases (or worse yet, change them) who aren't permitted to do so. It requires a pretty sophisticated VBA coder to do that, and such a person can also circumvent any attempt by the IT Department to prevent access to VBA. It is far better to identify the people within the organization who have those skills and make sure you trust them.

 

It is also to be noted that Information security risks also occur if parties outside the organization are given access to information exported from corporate databases. Lack of VBA access won't stop someone from copying such files onto a flash drive and letting it fall into the wrong hands.

 

Hope this helps!

read less
Answers 1 Comments
Dislike Bookmark Share

About UrbanPro

UrbanPro.com helps you to connect with the best MS Office Software Training in India. Post Your Requirement today and get connected.

x

Ask a Question

Please enter your Question

Please select a Tag

X

Looking for MS Office Software Training Classes?

Find best tutors for MS Office Software Training Classes by posting a requirement.

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

Looking for MS Office Software Training Classes?

Find best MS Office Software 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