What is a cool trick for data analysis in Excel?

Asked by Last Modified  

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

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

Engineering Professional Project Management Trainer

Pivot table.
2 Comments

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

Learn PowerBI. Better than Excel
1 Comments

View 2 more Answers

Related Questions

Linear Programming in Excel ?? Can someone can solve just 1 question of Linear Programming in Excel ?? I am ready to pay. Thanks
Hi Gary I might be able to help you please share your question with me and hopefully would be able to help you on the same.
Profile Photo
Garry
0 0
View Comments5
Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Profile Photo
Ramkumar
0 0
View Comments7
Is MS Excel very easy to learn?
Yes it is easy application to learn
Profile Photo
Kamal
0 0
View Comments6
Excel formulas in advance level?
In excel we have lot of staff and formulas, we can learn based on your requirement, in excel vlookup, hlookup, pivot table if condition, sumif ifs, countA, if ifs, data validation, etc. and we have to...
Profile Photo
ManojGS

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

Ask a Question

Related Lessons


Power View
Power View is now a feature of Microsoft Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions. Power View...
Profile Photo

Chart
A chart is a set of coordinates When you make a chart you start with an empty, two-dimensional space, a vertical dimension (y) and a horizontal dimension (x) . You also have a data source. Your job is...
Profile Photo

Be prepared to get trained--init
Before starting the training,students must be mentally prepared for acceptance of new knowledge. Students must attend training with open minded forgetting the position they are working.This will help...
S

Smartnub Softsolutions

0 0
View Comments0

Pivot table - Transform numbers in calculated field
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...
Profile Photo

Recommended Articles

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 >

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 >

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 >

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 >

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