What is a cool trick for data analysis in Excel?

Asked by Last Modified  

4 Answers

+2 Basic Excel Advanced Excel

Follow 9
Answer

Please enter your answer

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
Comments
Dislike Bookmark

Pivot Tables and Pivot Charts are easy tools to make sense of large datasets. If you are willing to invest more time to learn formulas, they can be used to refine and analyse your data.
1 Comments
Dislike Bookmark

Engineering Professional Project Management Trainer

Pivot table.
2 Comments
Dislike Bookmark

Microsoft Certified Excel Specialist & Power BI Tutor with 15+ yr Corporate & Personal Training Exp

Learn PowerBI. Better than Excel
1 Comments
Dislike Bookmark

View 2 more Answers

Related Questions

I need excel analysis like a professional ..... Plz help
Hi Ohid, call me
Ohid
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin
How many days it will take to complete advance excel course?
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...
Amit
Use of INDEX in MS Excel?
INDEX function is a powerful tool that allows you to retrieve values from a specified range or array based on row and column numbers. INDEX(array, row_num, ) As it requires row_num and column_num, it is...
Prabhakar
0 0
6
Is learning Tally good or is learning Advanced Excel and Python good? Which one will be better for getting a job? What would be the general cost of learning Tally, Advanced Excel and Python? Which are the best tutors or institutes near to Kudlu Gate and Electronic City?
As a beginner, you should go with Advance Excel and MIS reporting. After that, you can go for VBA, SQL, and Python in the end. Follow this career path. You will end up being a data analyst and package raging from 8-12lakh pa.
Prabhu

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

MS Excel

Monika K.

0 0
0
VBA Tip: Print Random Numbers In A Selected Range
Let’s say you want to print some random numbers in a selected range then you can use below Macro. Sub Print_Randomnumbers() Dim myrng As Range For Each myrng In Selection myrng.Value = Application.WorksheetFunction.Int(Rnd...

Karthik Dale

0 0
0
Quick Introduction to MS Excel

Sanjeev Singh

0 0
0
What are the function categories on Excel?
Function Categories There are many categories of functions in Excel. Each category has specific functions that pertain to that category. Financial: Performs common business calculations including accounting...

Talent Hub Training Institute

0 0
0
What is the difference between Analytics and analysis?
Analysis> Separation of a whole into its component parts> Looks backwards over time, providing marketers with a historical view of what has happened Analytics > Defines the science behind the...

Itech Analytic Solutions

0 0
0

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Make a Career as a BPO Professional

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you