Main Menu

Our Partners


Authorized Pearson Vue Test Center



TESDA
Live Online Training


Live CCNA Remote lab

Contest

  

CNCTC Articles - Excellence in IT TRAINING

The Whole New 2011 Excel Spreadsheet: Part 1

by: Cresencio Daffon Jr. | 07 Jan, 2011 15:30:50

Article Word Count: | Viewed: times


If you are still using 2008 Excel or older, you better think of switching to the newest version which is 2011 Excel which got a lot of new exciting features. We are going to tackle 3 major things about the changes and updates on the new Excel version for 2011.

But at this point, we will give our focus on key values and trends revealed by formatting conditionally.  

  • key values and trends revealed by formatting conditionally

The key values and trends in your data are revealed by the 2011 Excel ‘s formatting conditionally which has bigger improvement. Before, you really have to work thoroughly hard to get the most of the features you want from the previous Excel versions. But now with the dawning of the whole new 2011 Excel, you can expect additional formats conditionally pre-defined by just a mouse click away.

You may choose the range of data you are about to analyze, and then select Format>Conditional Formatting when you start the program. In adding a new rule for the chosen range, you may press the plus sign located at the bottom upon the appearance of the window for Manage Rules which will open the window where you do rule defining called New Formatting Rule.

Now, to select the formatting type you like to apply, you may use the pop-up for Style. The comparison of values on your specified conditions will be based on color accordingly for the options like 3-color and 2-color scales, respectively. Behind each value of cells, the Data Bar draws a small bar graph.

Based on the conditions you set the icon for Sets insert coins into cells. With the new 2011 Excel, the dots colored will make it visible which parts are unlikely and which are likely, and to show percentiles versus performance, simply add a four-level icon set when you are using a spreadsheet data.

With the whole new 2011 Excel, all the information you’ll be sharing to others will be more useful, and your job will be easier because of its new features which you cannot find from any of the older Excel versions. Now, creating easier to interpret and easier to read worksheets will make history because of the new 2011 Excel’s feature for formatting conditionally, Cell Styles, Themes, and Sparklines.

We shall continue our discussion about the whole new 2011 Excel on the second part of this article. The topics that will be highlighted on the next cut will be about tracking trends through sparklines, and smarter spreadsheet through cell styles and themes. Please stick around. 


Protected by Copyscape Originality Checker





Other Related Topics..
« Prev item - Next Item »
---------------------------------------------


What do you think?

Leave comment

This item is closed, it's not possible to add new comments to it or to vote on it

Comments

No comments yet. You can be the first!

  
CNCTC Live Chat Inquiry

Job Openings

Subscribe

Stay Informed Subscribe

Name *

Email *