#Data analysis excel 2011 how to
#Data analysis excel 2011 full

CTRL +up arrow: To get the top row of your data set.

CTRL + down arrow:To get to the bottom row of your data set.

Here are a few keyboard shortcuts that will save time: Nobody wants to waste their whole day scrolling to the bottom of a spreadsheet.

Keyboard Shortcuts: Scrolling is the enemy.

#Data analysis excel 2011 how to

Transpose: Need to change how your data is oriented? Not sure exactly how to phrase what you’re trying to do? Just Paste Special and check the Transpose box and your data will magically be transformed from horizontal to vertical.One co-worker affectionately calls this the “ double click trick“.Autofill: Instead of wasting time scrolling and dragging a formula all the way down the page, your colleagues will be amazed that double clicking on the AutoFill icon will automatically do it for them.Here are a few simple tips that will wow your colleagues: If you can point out tips that are within your colleagues’ comprehension, you will quickly become an excel rock star. Regardless of your audience, complicated formulas can be difficult to explain. But even more important than your excel expertise is the ability to communicate helpful tips to others. As a Chandoo reader, you’re probably already an excel expert or well on your way to becoming one. They use formulas and charts regularly, occasionally experimenting with Pivot Tables. Most of your colleagues are probably like mine – they’ve got a pretty good understanding of excel. Thanks to, I’ve developed a reputation as an “excel wizard” and even taught a 4 week excel training class! That’s why Chandoo’s tips have been so helpful – because we use excel every day. Analyzing site trends, forecasting traffic, charts, dashboards, and slide shows you name it, we use excel for it. I am sure many business analysts, analysts and managers out there can co-relate to Matt’s experience.Īt we use excel for a variety of purposes.

#Data analysis excel 2011 full

He gladly accepted the offer and here were are, with a post full of tips & ideas to help you. So I asked him to write a small guest post sharing his experiences. While the mail is flattering, I was more interested to know how Matt uses Excel in his day to day work. I even taught a 4 week training class at my old job! Over the past 3 years, tips I’ve learned from your site have been appreciated all the way in Seattle, Washington, at an internet marketing company, a newspaper, and a food website. Thanks to you, I’ve become an “excel wizard,” and have been able to show coworkers mind blowing new things with excel they never knew about. Your site has such an incredible array of useful tips, tricks, and solutions to every day problems, I don’t know what I would do without it! It’s the only place I go to look for help when I’m stumped with excel. Thank you for sharing all of your knowledge on such an incredible website. On Jan 4, I received this email from Matt,