Weekly Links – Even More Downloads Edition
Over the weekend I could get sometime to cleanup few of the pages on the blog. Checkout the free excel spreadsheets page, we now have almost 30 excel spreadsheet files for download neatly arranged in to areas like Top 5, Latest 5, Excel Chart Templates, VBA, Excel Apps. Check out the page yourself and download a file or two.
Ok, moving on to this weeks excel links from around web.
Note to new readers: Every week (ok, not really every week, but almost) I share few excel, charting, presentation related links that can help you become more productive and successful.
JP at Code for outlook and excel blog has taken one look at my excel from twitter workbook and immediately felt that, an add-in is a cool way to extend it. Being the compulsive VBA programmer he is, he just did that and posted the add-in for download at his blog. While there, also checkout his random sample data generator add-in, might come handy when you need to generate sample data.
Jorge at his charts blog touches a very relevant and important issue. Often when you have more data, we plot bars without really emphasizing on focus and context. It is important to plot your data, but it is more important to highlight the key values and bring context so that readers will know the story better. He suggests using accordion charts, something that I have been experimenting in the last few weeks. check out more at Jorge’s site.
Debra shares this wonderful little mouse based shortcut to paste copied values as cell. Just select the values you want to copy, right click on the border and drag the range to where you want to paste while holding the right mouse button depressed. When you are ready release mouse button and select one of the options shown (copy here as values only). You can do this and much using excel’s paste special features too.
Simple Expense Tracker using Excel 2007 Features
Monica, a software engineer in Excel team at MS tells us how you can build an expense tracking application using Excel 2007’s features like SUMFIS formula.
What would you do if you do not have excel 2007 or not want to use SUMIFS ? Well, you can build an expense tracker using Google docs.
Leaving the door open could cause excessive CPU load
Dick at Daily Dose of Excel discovers that leaving few ADO data connections open in the VBA code could lead to excessive CPU consumption and slowing down of every app including Excel. Make sure you are not doing the same mistake in your vba / macro code.
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|Review of PTS Clustered Stack Chart||PHD reader gears up for a promotion despite recession and makes my day|