Microsoft Excel 2010 Backstage View
Free Microsoft Office Tutorials
Backstage View : Excel 2010 Backstage View
Before we look at this in more depth let’s see how easy it is to create a new workbook. It takes seconds to create a new blank workbook or a workbook from one of the templates that we have personally created. We can also use the templates from Office.com.
Watch this short video tutorial about the Excel 2010 Workbooks
The Excel 2010 Backstage View view can be accessed by clicking the file tab. You will be presented with the view illustrated above.
Download the workbook for the 5 miniute challenge. The backstage workbook challenge.xlsx
To help us to learn some of the more popular features in the backstage view that we will use in our workplace I have created the five-minute backstage view challenge.
It is not as easy as it looks. Are you up for a challenge?
Watch this short video tutorial about the Excel 2010 Backstage View.
Why have I chosen in these 10 points? It is because these 10 procedures are things that we regularly use in our workplace. I’m going to go through them one at a time and tell you the value that they will be to you. I really do encourage you to watch the video and take the challenge.
1 Save this workbook as a template
Using templates is very important, why? You may wish to send out a document that others can use as a basis to start their work from. They can enter their information and when they save that information it will always be saved to a new workbook. Your template remains the same and can be used over and over again.
2 Create a PDF from this file
Distributing files and collaborating is never been easier with the use of portable document formats or PDF. The document cannot easily be modified. It can be opened in all platforms. The size of the document is small in comparison to the original. If you plan to distribute your file you should always consider sending it as a PDF. Microsoft Excel 2010 will let you create your PDF file right from inside the application.
3 Close this workbook and still leave Excel open
You can work more proficiently in the course of your day by not closing down Microsoft Excel every time you wish to open a new file or close a file. Simply close the file but leave Microsoft Excel open and then navigate to your new work assignment.
4 Protect the current sheet with the password "Online"
Protecting the workbook and or the worksheet is essential if your application is to work effectively. It will stop your formulas from being deleted your formats from being erased. In fact in protecting the worksheet you can decide exactly what you want your user to be able to edit and what cannot be touched.
5 Add a title into properties call the title "Challenge"
The properties of a workbook will tell us all the background information that is necessary. It is this information that is used when searching for our workbook in large file repositories or on the web. Properties are very important. Certain properties will be set by default, others you can add as you see fit.
6 Check the workbook for hidden properties
In the world of litigation today documents are scanned for hidden data. Before sending your document you can scan and find all of the data then leave or remove exactly what you want. This could save you a lot of heartache. This is especially important if your document has been used by multiple users prior to it being distributed.
7 Create a time sheet from office.com save it to your desktop
Microsoft office 2010 comes complete with many excellent templates that you can use for free. You can save yourself literally hours of time by knowing how to access these templates and use them as a starting platform for your work.
8 Print a selection of data E12 to I16
Printing in Microsoft Excel is a lot different to printing in the other office applications. If you’re not careful instead of printing just one page you could end up earning 400 blank pages by mistake or even more. Learn how to set Microsoft Excel for printing. In this exercise we learn to print a selection of data.
9 When correcting spelling turn "Ignore upper case" off
There is a large range of proofing options that you can change and modify. You can specialise the way that your writing is corrected within Microsoft Excel.
10 Hide the sheet tab in this work sheet to
Becoming familiar with the options is important. They now reside in the backstage view. In the options tab of the backstage view you will be able to change many of the default settings and worksheet settings for your application. Here we simply hide the worksheet tabs.
In the MOS exams for Excel 2010 or Excel expert 2010 there are many questions that focus on the back stage view. Why not consider taking a Microsoft certification exam?
With regard to our challenge. How did you go? Let me know your thoughts.
Excel 2010 Backstage View 5 minute challenge.
Online PC Learning is committed to providing free office tutorials