Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster
Sachin Tendulkar is undoubtedly the best cricketers to play One Day International Cricket. He is a source of inspiration and joy for me and many others. So, naturally I was jumping with joy when I heard that he scored the highest ever runs in a single match on 24th of Feb. He scored 200 runs […]
Adding Calculated Fields to Pivot Table P&L [part 3 of 6]
This is part 3 of 6 on Profit & Loss Reporting using Excel series, written by Yogesh Data sheet structure for Preparing P&L using Pivot Tables Preparing Pivot Table P&L using Data sheet Adding Calculated Fields to Pivot Table P&L Exploring Pivot Table P&L Reports Quarterly and Half yearly Profit Loss Reports in Excel Budget […]
Use Paste Special to Speed up Chart Formatting [Quick Tip]
Excel Paste Special is one of my favorite features. So I was naturally thrilled when I discovered that you can use paste special to paste formatting from one chart to another. When we have multiple charts, ensuring consistent color schemes, fonts etc. is very important. Often we individually format the charts because they have different […]
Find and Remove Blank Items from a Range of Cells [personal experience]
Most of you know that during day time I work as a business analyst. Today while preparing some test scenarios for our latest insurance application, I came across a weird problem. There are some steps in testing. For each test scenario, a combination of these steps is required. It is my responsibility to identify the […]
Comprehensive List of Excel Keyboard Shortcuts
Few weeks back I have invited all of you to share your excel keyboard shortcuts in a open thread. More than 50 people commented on that post and shared a hundred excel keyboard shortcuts with us. There were so many wonderful keyboard shortcuts and tricks buried in the comments section of that post. During the […]
How do you consolidate data from multiple sheets in to one? [open thread]
Long time PHD reader and mother of a lovely kid, Michelle, sent me a question in email that provoked me to write this post, I was wondering how to tabulate large amount of information gathered through surveys. Where I work customers are constantly handed survey sheets in order for us to measure how the service […]
Excel School Last Call, Closing in Few Hours – Join Now!
If excel school were to be a bar, this post is your last call. Come one, come all and order the course now. Click here to sign-up for excel school (on a lighter note, if excel school were to be a pie, we wouldn’t be having this conversation :P) How many students have joined the […]