We have a macbook at home (we have a name for it too, we call it Shimla, the most romantic place for us). Like all latest macbooks, this one too came with a trail version of iWork. Even though I have used iWork before, this time I wanted to compare iWork numbers with Excel. In this post, I want to highlight 7 really cool features for iWork and how Microsoft excel can benefit from implementing the same.
1. iWork comes with sexy templates
When you try to make a new Numbers document, iWork asks you to select from some of the templates. The templates are really practical and very cool. For eg. they have a template for creating a check-list, product comparison worksheet, household budget. These are really easy to use and work to the point.
With excel 2007, MS introduced several new templates and gave us an option to import templates from web. But still, users resort to quite a few workarounds when it comes to building a neat looking worksheet. We all could benefit if something like this is available in Excel.
2. Simple but effective Paste Options
When you copy some values in to clipboard and try to paste them, iWork gives you an option to “paste values” and “paste and match styles”. 2 most commonly used paste options.
In excel, this is usually hidden in paste special menu (in 2007, paste values is available as a menu choice as well). Excel veterans know the ALT+ESV shortcut by heart. It would be cool to have these options highlighted in the menus and given easy to remember shortcuts.
3. Making Checkboxes, Sliders, Steppers ad List boxes is very easy
In iWork Numbers, to get a checkbox in a cell, all you need to do is format the cell as “checkbox”. You can also format a cell as slider, stepper or “pop-up menu” (usually known as combo box).
This is very easy compared to all the form control based stuff we are used to Excel. If MS implements this idea, we dont need to resort to sneaky tricks to get a bunch of checkboxes in excel or use wingdings font.
4. Quick summary of data
Whenever you select a bunch of numbers, iWork Numbers displays 5 quick statistics about the data, in the status area of the numbers application. (Unlike excel, iWork numbers has status bar in the left side).
Excel also shows the quick summary in the status bar, but usually the sum of values. (In excel 2007, you can configure the stats you want to see, thus mimicking this behavior. But it would surely help if these 5 stats are “always on” by default.
5. Cleaner Menu / toolbar area
While MS is going towards ribbon based interfaces for all their applications, iWork keeps the UI relatively simple and uncluttered. The toolbar area, shown below contains the vital buttons to make a filter, format a cell, create a chart, insert a function, table and change views. Everything else is buried one level deep.
This could be a more effective way to expose a complex application’s functionality. MS should consider these UI options as well.
6. Inspector Dialog for all the formatting options
Excel has a ton of dialogs to format cells, charts, drawings, printer settings, tables and more. In iWork, there is one dialog for all of these, called as inspector window. Using this you can setup printer options, page layout, table design, cell formatting, chart formatting, font, text, paragraph settings, drawing shape formats and other inserted object (such as movies) formats. Based on the selected item, the inspector window shows the corresponding tab where you can adjust the formatting.
This could be a great way to reduce the popup fatigue in Excel. In Excel 2007, MS introduced new popups that further complicated the way even a simple chart axis formatting. We all could benefit if MS implements simpler dialog boxes modeled after the inspector.
7. Switch rows and columns in charts intuitively
In iWork Numbers, to switch rows and columns in a chart, all you had to do is select the chart and then click on the little button that appears next to data range of the chart.
In excel you can do this using “select data” options of the chart. But doing this without leaving the worksheet is much more intuitive and cooler.
Have you tried iWork Numbers?
Apple is famous for its design sense and beautiful products. iWork is no exception. It is a visual treat to work with iWork.
What is your opinion about it?
11 Responses to “Fix Incorrect Percentages with this Paste-Special Trick”
I've just taught yesterday to a colleague of mine how to convert amounts in local currency into another by pasting special the ROE.
great thing to know !!!
Chandoo - this is such a great trick and helps save time. If you don't use this shortcut, you have to take can create a formula where =(ref cell /100), copy that all the way down, covert it to a percentage and then copy/paste values to the original column. This does it all much faster. Nice job!
I was just asking peers yesterday if anyone know if an easy way to do this, I've been editing each cell and adding a % manually vs setting the cell to Percentage for months and just finally reached my wits end. What perfect timing! Thanks, great tip!
If it's just appearance you care about, another alternative is to use this custom number format:
0"%"
By adding the percent sign in quotes, it gets treated as text and won't do what you warned about here: "You can not just format the cells to % format either, excel shows 23 as 2300% then."
Dear Jon S. You are the reason I love the internet. 3 year old comments making my life easier.
Thank you.
Here is a quicker protocol.
Enter 10000% into the extra cell, copy this cell, select the range you need to convert to percentages, and use paste special > divide. Since the Paste > All option is selected, it not only divides by 10000% (i.e. 100), it also applies the % format to the cells being pasted on.
@Martin: That is another very good use of Divide / Multiply operations.
@Tony, @Jody: Thank you 🙂
@Jon S: Good one...
@Jon... now why didnt I think of that.. Excellent
Thank You so much. it is really helped me.
Big help...Thanks
Thanks. That really saved me a lot of time!
Is Show Formulas is turned on in the Formula Ribbon, it will stay in decimal form until that is turned off. Drove me batty for an hour until I just figured it out.