DATE(YEAR(TODAY()),1,1) calculates the first day of the year (“”)
Business process mapping tools excel how to#
Then explain how to filter and sort the data. Start by creating a Pivot Table to answer 1 question.Keep it simple though, as the flexibility can get overwhelming to new users very quickly. If you can help your colleagues navigate the treacherous waters of Pivot Tables, they will definitely appreciate it. Pivot Tables : Pivot Tables are daunting to most people who don’t use them regularly.
Create a combination chart with both bar and line graphs.You’ll win points if you can explain how to: Most people have used charts before, but are in no way experts. Bonus: Holding SHIFT down while using any of the above shortcuts will select that entire range.CTRL + End: To get to the last cell (bottom right) in your data set.CTRL + Home: To get to the first cell (top left) in your data set.CTRL + left arrow: To get to the first column of your data set.CTRL + right arrow: To get to the last column of your data set.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.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.
Business process mapping tools excel 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,