Main Menu

Our Partners

Authorized Pearson Vue Test Center

Live Online Training

Live CCNA Remote lab



CNCTC Articles - Excellence in IT TRAINING

The Whole New 2011 Excel Spreadsheet: Part 2

by: Cresencio Daffon Jr. | 07 Jan, 2011 18:31:35

Article Word Count: | Viewed: times

Thank you for bearing with me and for waiting for this second part of our article about 2011 Excel Spreadsheet which will concentrate on tracking trends through sparklines, and smarter spreadsheet through cell styles and themes.

Now, let’s continue our discussion about the rest of the two topics. 

  • tracking trends through sparklines

You can now look at a single cell more easily to view your data trends with Sparklines of 2011 Excel spreadsheet. The sales tracking worksheet includes month by month statistics by salesperson by product over time consideration. You are making it more uneasy to determine who are among your salespeople are the strongest if you are focusing only at huge numbers display which includes a few salespeople and products.

You’ll be given a visual data representation when a data graph is placed into a single cell which solves the problem and the salespeople’s performance statistics can be transparently seen on a bird’s eye view through Sparklines.

Now, to start with Sparkline, you may choose Insert > Sparklines after you choose the cell where you like the graph to be seen which is normally close to the graphed data. You may click OK after choosing the range of the data to be graphed. In the cell you chosen there you will see a Sparkline

  • smarter spreadsheet through cell styles and themes 

For people to look over your data over and over, you need to have better-looking spreadsheets for a presentation, and that’s obtainable through the use of 2011 Excel. You don’t need to exert more effort now with two closely-related features which can make your spreadsheets a smarter alternative.

If you want to view your worksheet on a different level and perspective with just a few clicks away, you may select options which can make an effect on all switches through new fonts, colors, and theme.

If you wish, you may easily return to the version which was saved, if you want to be sure that the changes were saved upon changing your worksheet’s theme.

At this point, to display themes available you may click on the Themes button after which in the Ribbon you press the Home button to be sure of the visibility of the Ribbon by using the step View > Ribbon. 

Now to select a new theme, you may change your worksheet’s appearance. By using the option for Save Theme located at the bottom of the theme selector, your theme can be saved which would be ideal for corporate settings when it comes to worksheets colors and fonts. You are good to go after creating a theme with customized colors and fonts.

On the other hand, in relation to Themes, instead of working at the worksheet level, you can alternatively work at the cell level which is called Cell Styles. On the Ribbon’s Home tab you’ll find Cell Styles as with Themes. For you to see the drop-down menu which contains the number of styles that are pre-defined, you may press Styles after highlighting cell ranges or a just a cell.

You may choose the style for Check Cell to turn the cells into white-on-gray which is double-outlined if you have data ranges you want to check later if you’re not yet sure of it. For this situation however, for a yellow sticky note appearance of the selection, you may use the Note style. You can simply put on your personal touch to any cell if you save your customized Cell Styles after defining it as with Themes.

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


No comments yet. You can be the first!

Live Chat Software

Job Openings


Stay Informed Subscribe

Name *

Email *