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 22/04/2020 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

How to Insert a Pivot Table.

AMEY VIDVANS

I am an education and Technology Enthusiast with a teaching experience of more than 10 years. I am...

Let's learn how to Insert a Pivot Table.
Comments
Dislike Bookmark

Lesson Posted on 22/04/2020 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel Tutorial IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Advanced Excel - Excel What-If Analysis Goal Seek !

AMEY VIDVANS

I am an education and Technology Enthusiast with a teaching experience of more than 10 years. I am...

Comments
Dislike Bookmark

Answered on 03/03/2020 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Charlie

Yes, of course, if you are a regular MS excel user in your office and all the reporting is happening through MS Excel, then you should start learning advanced features of MS Excel right away. Solving problems in an office gives you an edge over others. Not everyone knows much about MS Excel. Learning... read more

Yes, of course, if you are a regular MS excel user in your office and all the reporting is happening through MS Excel, then you should start learning advanced features of MS Excel right away. Solving problems in an office gives you an edge over others. Not everyone knows much about MS Excel. Learning MS Excel will open doors for a data analysis role. MIS role and what not. Big data and data science are the two hot cakes in the market with handsome salaries. Advanced Excel users know how to structure and present their data so that it looks impressive. Good understanding of Excel features like tables, cell styles, formatting options is necessary to make great data presentations.

So yeah, all hands for advanced excel.

read less
Answers 3 Comments
Dislike Bookmark

Looking for Microsoft Excel Training classes

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

FIND NOW

Answered on 03/03/2020 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Charlie

Ok if one is using Excel, you might focus on Excel + Microsoft SQL Server Express instead of VBA + Access. Both Access and AQL Server are databases, but Access has an engine to develop forms and reports if it was for Excel that may be preferred front end instead of Access. To focus on the core of Excel... read more

Ok if one is using Excel, you might focus on Excel + Microsoft SQL Server Express instead of VBA + Access. Both Access and AQL Server are databases, but Access has an engine to develop forms and reports if it was for Excel that may be preferred front end instead of Access.

To focus on the core of Excel VBA without having lots of chapters on fewer core topics, a book called "Excel 2003 Power programming" would be beneficial.

After this, to get an excellent overview of best practices, Bullen, Bovey and Green's "Professional Excel Development" will be like the bible.

So, after this, you will have a framework to dive either into programming for particular applications or particular features like programming charts.

Hope this helps

read less
Answers 3 Comments
Dislike Bookmark

Answered on 03/03/2020 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Charlie

Yes, it is possible to set multiple conditional formats and also to even have them active at the same time. So if one formatting only specifies a text colour and the other only a background, then you can get both effects in a cell. The very tricky thing is that once you set it, you will not be able to... read more

Yes, it is possible to set multiple conditional formats and also to even have them active at the same time. So if one formatting only specifies a text colour and the other only a background, then you can get both effects in a cell. The very tricky thing is that once you set it, you will not be able to unset formatting, so you need to switch to the " Red Border" that is preset before actually adjusting your pre-determined desired format.

 For example, there is a table that contains the name (Column A) and subject wise marks (Columns B to G) of students of a class. Say the class has 50 students. Row 1 will heave headers so that data will be populated in Rows 2 to 51.

One level of conditional formatting that can be applied to cells B2 to G51 is that if the value of the cell is greater or equal to 35, the cell must turn green. The second level of conditional formatting can be set as if the marks of that subject are more significant than the class average; then the font must turn Bold.

Hence, in the first case, a cell is a part of range A2: G51, and in the second case it is a part of column B, C, D, E, F or G. Depending on the value, a cell can become both Green as well as BOLD.

There is one more thing. You can select the option of stopping further rules to be applied if the first rule is run TRUE.

 Hope this helps

read less
Answers 3 Comments
Dislike Bookmark

Answered on 03/03/2020 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Apoorva P.

Excel and Access are two Microsoft applications. The foremost difference between Excel and Access is that Excel is a spreadsheet to perform calculations and to interpret data visually. At the same time, Access is a Database Management System that helps store and manage data efficiently. Access is... read more

Excel and Access are two Microsoft applications. The foremost difference between Excel and Access is that Excel is a spreadsheet to perform calculations and to interpret data visually. At the same time, Access is a Database Management System that helps store and manage data efficiently. 

 

Access is better for managing data: helping you keep it organized, easy to search, and available to multiple simultaneous users. Excel is generally better for analyzing data: performing complex calculations, exploring possible outcomes, and producing high-quality charts. The purpose of Access is to assist in collecting, sorting, and manipulating the databases. Compared to Access, the storage capacity is less since excel isn't built for storing data.

 

read less
Answers 3 Comments
Dislike Bookmark

Answered on 03/03/2020 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Apoorva P.

Microsoft Excel and LibreOffice Calc are comparable. Calc may not be as user-friendly as Excel, but in a lot of ways, it is notably more capable as it's oriented towards a complete set of features over ease of use. In fact, the compatibility between the two is rather high, but with a slightly different... read more

Microsoft Excel and LibreOffice Calc are comparable. Calc may not be as user-friendly as Excel, but in a lot of ways, it is notably more capable as it's oriented towards a complete set of features over ease of use. In fact, the compatibility between the two is rather high, but with a slightly different user interface. 

 

These days Excel on-line creates files in the Open Document Format, should you not have installed a compatible version of Excel on your computer. There are, of course, differences for advanced users, but in terms of the apps doing the same thing differently, they are similar. LibreOffice cannot do MS Visual Basic but has its own version of Basic

read less
Answers 3 Comments
Dislike Bookmark

Answered on 03/03/2020 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Apoorva P.

One of the cool tricks I think few people know is to create a graph that auto-updates as new data is added to a spreadsheet. This might not be ultra mind-blowing if you have like one graph but think of a document linked to hundreds of Excel graph objects that you need to update every quarter, for example,... read more

One of the cool tricks I think few people know is to create a graph that auto-updates as new data is added to a spreadsheet. This might not be ultra mind-blowing if you have like one graph but think of a document linked to hundreds of Excel graph objects that you need to update every quarter, for example, like earnings reports and financial data. This method could save you hours, and it uses only two little-known Excel features: OFFSET and names. It can just speed up the process of summarizing stats and could get a quick graphic representation automatically.

 

The quickest of the tools for data analysis are pivot tables. Simple drag and drop operations allow you to create data sets with filters any way you like.

read less
Answers 4 Comments
Dislike Bookmark

Answered on 03/03/2020 IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Should I learn MS Excel before Power BI for data analysis and visualization?

Apoorva P.

Yes, in my opinion, you need to learn MS Excel, because most of the visualization tools in Data Analytics uses Excel data or function to manipulate the data. So, it is useful and helpful to have knowledge in MS Excel, so that it will be easier for you to manipulate and visualize the data. Also, Power... read more

Yes, in my opinion, you need to learn MS Excel, because most of the visualization tools in Data Analytics uses Excel data or function to manipulate the data. So, it is useful and helpful to have knowledge in MS Excel, so that it will be easier for you to manipulate and visualize the data. Also, Power BI and MS Excel are Microsoft tools. So, Power BI internally uses the formulas of MS excel to manipulate all the data. Hence, it is always better to learn MS Excel before you learn Power BI and Data Analytics.

 

read less
Answers 2 Comments
Dislike Bookmark

Looking for Microsoft Excel Training classes

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

FIND NOW

Answered on 23/03/2020 IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Apoorva P.

The duration to complete any kind, of course, depends on your grasping power and the ability to learn the concepts quickly. Having said that, it usually takes about three to four weeks to learn the topics in Advanced excel. For this, you need to be through with your MS Excel concepts and also practice... read more

The duration to complete any kind, of course, depends on your grasping power and the ability to learn the concepts quickly. Having said that, it usually takes about three to four weeks to learn the topics in Advanced excel. For this, you need to be through with your MS Excel concepts and also practice every day.

Advanced excel contains topics like VLOOKUP, Macros etc. These topics are pretty time consuming but easy to learn. So, it all depends on you. If you practice every day and dedicate around 2-3 hours every day to learn the concepts, then you can learn it within four weeks. But, to master the concepts in Excel, you need to use the tricks and formulas on a daily basis. 

 

read less
Answers 12 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 97

Lessons 74

Total Shares  

+ Follow 96,662 Followers

Related Topics

Top Contributors

Connect with Expert Tutors & Institutes for Advanced Excel

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