Excel 2010 Means No More Tears With Toolbars
0 views
Skip to first unread message
Rich Talbot
Oct 22, 2012, 3:00:29 AM10/22/12
to articl...@googlegroups.com
Rich Talbot offers the following royalty-free article for you to publish online or in print.
Feel free to use this article in your newsletter, website, ezine, blog, or forum.
-----------
PUBLICATION GUIDELINES
- You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
- Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
- Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
- If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links.
- Please send a copy of the publication, or an email indicating the URL to arti...@microsofttraining.net
- DistributeYourArticles (www.DistributeYourArticles.com) has distributed this article on behalf of the author. DistributeYourArticles does not own this article, please respect the author's copyright and publication guidelines. If you do not agree to these terms, please do not use this article.
-----------
Article Title: Excel 2010 Means No More Tears With Toolbars
Author: Rich Talbot
Category: Software
Word Count: 553
Keywords: Excel courses in London
Author's Email Address: arti...@microsofttraining.net
Article Source: http://www.distributeyourarticles.com
------------------ ARTICLE START ------------------
When Microsoft Office launched 2010, Excel was probably the program that had been least changed - but this has not made people any more confident about using the application. For some, it was the painful memories of using macros in the 2007 version that set them off. Including shapes or charts in your macro recording could leave the final file with huge function gaps or, even worse, a blank recording.
With Excel 2010, however, you can compose graphics-inclusive macros without fear of any glitches making their way into your spreadsheets as Microsoft have ironed out the macro monsters.
And if security was a worry, then rest easy. Previous security problems have now been dealt with in an enhanced Protected View. Any Excel document or Excel-readable document with suspicious origins is automatically opened in Protected View, disabling macros and add-ins that may cause a threat. Once you choose to disable Protected View, then you can edit your document. Any spreadsheet that you download from the internet or receive as an email attachment is automatically filtered to Protected View before opening.
Excel 2010 has a revised version of the Ribbon interface, and the 2007 Office Button has been replaced by a more traditional File menu. The Ribbon does offer more enhanced customisation options, and you can even pin common functions to a quick menu that sits above the Ribbon. This is particularly welcome by anyone who thinks that they will never find the command or function they use regularly amongst the new groups and tabs.
However, the return of the File menu to the Ribbon doesn't mean a return of the File menu that many were used to in pre-2007 versions of Excel.
The File tool brings up the Backstage view, which completely hides your active worksheet and shows a full screen set of controls. These controls in Backstage view include options you associated with the old File menu such as saving options, printing and document templates.
But now there's even more - for example, you can save your Excel worksheets to Skydive, Microsoft's free online storage service. Skydive offers a unique sharing option, as you can keep a version of a spreadsheet on an easily accessible web drive. To use Skydive, you do need a Microsoft Live ID, easy obtainable if you already use Hotmail and MSN Messenger. Backstage also contains the Help menu, a permissions editor and the options menu that allows you customise the Ribbon.
Also new to Microsoft Excel 2010 is the Shared Workbooks function, which allows multiple users to open and edit the same Excel file simultaneously. So, if your organisation shares a common spreadsheet that many employees need to update, usually a file stored on a shared network drive such as a weekly timesheet, collaborative editing means that you will not get locked out if someone else has the same file open.
Sparklines and Slicers are two new Excel 2010 features that are also sure to bring tears of joy, rather than woe. Sparklines are miniature graphs that fit inside single worksheet cells; and Slicers let you build conditional displays into pivot tables.
With these new enhancements, users really can increase their productivity (and reduce anxiety) by upgrading their skills to gain the real benefits of 2010.
Author is a freelance copywriter. For more information on excel courses in london, please visit http://www.microsofttraining.net/info-73-excel-courses-in-london.html
------------------ ARTICLE END ------------------
Feel free to use this article in your newsletter, website, ezine, blog, or forum.
-----------
PUBLICATION GUIDELINES
- You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
- Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
- Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
- If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links.
- Please send a copy of the publication, or an email indicating the URL to arti...@microsofttraining.net
- DistributeYourArticles (www.DistributeYourArticles.com) has distributed this article on behalf of the author. DistributeYourArticles does not own this article, please respect the author's copyright and publication guidelines. If you do not agree to these terms, please do not use this article.
-----------
Article Title: Excel 2010 Means No More Tears With Toolbars
Author: Rich Talbot
Category: Software
Word Count: 553
Keywords: Excel courses in London
Author's Email Address: arti...@microsofttraining.net
Article Source: http://www.distributeyourarticles.com
------------------ ARTICLE START ------------------
When Microsoft Office launched 2010, Excel was probably the program that had been least changed - but this has not made people any more confident about using the application. For some, it was the painful memories of using macros in the 2007 version that set them off. Including shapes or charts in your macro recording could leave the final file with huge function gaps or, even worse, a blank recording.
With Excel 2010, however, you can compose graphics-inclusive macros without fear of any glitches making their way into your spreadsheets as Microsoft have ironed out the macro monsters.
And if security was a worry, then rest easy. Previous security problems have now been dealt with in an enhanced Protected View. Any Excel document or Excel-readable document with suspicious origins is automatically opened in Protected View, disabling macros and add-ins that may cause a threat. Once you choose to disable Protected View, then you can edit your document. Any spreadsheet that you download from the internet or receive as an email attachment is automatically filtered to Protected View before opening.
Excel 2010 has a revised version of the Ribbon interface, and the 2007 Office Button has been replaced by a more traditional File menu. The Ribbon does offer more enhanced customisation options, and you can even pin common functions to a quick menu that sits above the Ribbon. This is particularly welcome by anyone who thinks that they will never find the command or function they use regularly amongst the new groups and tabs.
However, the return of the File menu to the Ribbon doesn't mean a return of the File menu that many were used to in pre-2007 versions of Excel.
The File tool brings up the Backstage view, which completely hides your active worksheet and shows a full screen set of controls. These controls in Backstage view include options you associated with the old File menu such as saving options, printing and document templates.
But now there's even more - for example, you can save your Excel worksheets to Skydive, Microsoft's free online storage service. Skydive offers a unique sharing option, as you can keep a version of a spreadsheet on an easily accessible web drive. To use Skydive, you do need a Microsoft Live ID, easy obtainable if you already use Hotmail and MSN Messenger. Backstage also contains the Help menu, a permissions editor and the options menu that allows you customise the Ribbon.
Also new to Microsoft Excel 2010 is the Shared Workbooks function, which allows multiple users to open and edit the same Excel file simultaneously. So, if your organisation shares a common spreadsheet that many employees need to update, usually a file stored on a shared network drive such as a weekly timesheet, collaborative editing means that you will not get locked out if someone else has the same file open.
Sparklines and Slicers are two new Excel 2010 features that are also sure to bring tears of joy, rather than woe. Sparklines are miniature graphs that fit inside single worksheet cells; and Slicers let you build conditional displays into pivot tables.
With these new enhancements, users really can increase their productivity (and reduce anxiety) by upgrading their skills to gain the real benefits of 2010.
Author is a freelance copywriter. For more information on excel courses in london, please visit http://www.microsofttraining.net/info-73-excel-courses-in-london.html
------------------ ARTICLE END ------------------
Reply all
Reply to author
Forward
0 new messages