All articles with 'list posts' Tag

As part of reader awesomeness week, today I am featuring a list that Larry sent me with 12 beautifully defined rules for making better spreadsheets. He says that spreadsheets should be easy to understand, have a clearly defined purpose and should use Excel features as much as possible. I totally agree with him.

Read the rest of this post to find the rules and download a poster containing these rules. Thanks Larry.

Darren writes one of my favorite blogs – Problogger, it is a blog about blogging. It is super helpful for people like me who write, connect, share and sell online. A week back, Darren asked his readers to participate in a fun experiment by posting 7 links on their blogs. It seemed like an interesting […]

Looking for FIFA World cup 2018 Tracker? Click here. Today FIFA World-cup 2010 is beginning. For the next 30 days or so, no matter where you go, you are bound to hear about soccer, world cup, teams, points, goals and what not. As a tribute to this beautiful and lovely sport, I want to showcase […]

Starting Excel 2010, you can finally customize the ribbon UI and define your own tabs or groups. This can be a huge productivity boost for people using MS Office applications. In this post, learn how to customize excel ribbon to improve your productivity.

In October 2008, I have started an ambitious series of posts on this blog called – Spreadcheats. These are little tricks, nuggets, tutorials on using Excel that would make anyone a spreadsheet guru.

The spreadcheats series has been wildly successful. I am compiling all this useful information and articles in to one big post so that anyone can follow the links and become good in Excel. Read on,

[Note: This is not for beginners. If you know what a formula is, you would enjoy this 31 articles]

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 […]

Today we will learn Excel SUBTOTAL formula and 5 beautiful reasons why you should give it a try.

SUBTOTAL formula is used to find out subtotal of a given range of cells. You give SUBTOTAL two things – (1) a range of data (2) type of subtotal. In return, SUBTOTAL will give you the subtotal for that data. Unlike SUM, AVERAGE, COUNT etc. which do one thing and only one thing, SUBTOTAL is versatile. You can use it to sum up, average, count a bunch of cells.

We, data junkies, love pivot tables. We think pivot tables are solution for everything (except for may be global warming and that broken espresso machine down stairs).

Today, we are going to learn 5 awesome pivot table tricks that will make you a star.

Sales reports and dashboards are very common in any company. There are several ways in which you can visualize sales data to understand the trends and sales performance. So in November, I have asked you to visualize sales data using sample data. The visualization challenge #2, sponsored by Zoho Reports generated a huge buzz around the community and fetched 32 incredible entries. The response was so overwhelming that it took me almost 24 hours to write this post. Thanks everyone for participating and making this a huge learning experience for everyone. Personally I have learned several useful dashboard and charting tricks. I will be sharing some of these lessons with all of you in the coming weeks.

Today I want to introduce Excel 2010 to you. Excel 2010 is the latest version of spreadsheet software from Microsoft, set to be released for sale in late 2010. On Nov 18th, MS released the public beta of Excel 2010 [download here] along with other Office productivity software.

Excel 2010 has several improvements compared to earlier version – Excel 2007. In this post, I want to highlight some of the User Interface improvements made in Excel 2010 that are very exciting and fun to use.

We all have atleast one story of how that one time the boss / co-worker / classmate / cat ruined the carefully crafted excel spreadsheet by mucking up the formulas or disturbing the formatting. Read this post to learn 10 awesome excel tips to make better and boss-proof excel sheets.

Paste or Ctrl+v is probably the most effective productivity tool available to us. But how well do you know “Paste”?, do you know that there are many variations to paste data to your excel sheets? Surprised? Well, read this post to become a master paster 🙂 After copying your data, You can activate Paste Special […]

Excel has various functions, including functions to calculate inverse cosine of a given value, to multiply 2 matrices, to estimate the internal rate of return. But, most of us(well, just me then..) use just about 5-6 formulas to do our jobs. And IF formulas are a majority of these, so it doesn’t harm to learn […]