To Delete a Digital Signature from your Computer

To remove a Certificate, Digital signature, made with, the Excel Digital Signature, or Digital Certificate for VBA Projects use certmgr.msc go to personal then certificate.


In earlier versions of Windows go to the Start bar then go to Run and type in certmgr.msc this will open a dialog box.

In Windows Vista and later versions of Windows go to the Start bar then type in certmgr.msc and hit enter this will open a dialog box.

Open the Personal Folder and you will see a list of Certificates created. Open the Certificates Folder. Select the one that you wish to remove, a Red X will appear on the toolbar that you can use to Delete the certificate with, or you can use the Delete Key on your Keyboard, or you can right mouse click and choose Delete.

Digital Signatures in Excel 2007

Add a Digital Signature

What is a digital signature?

A digital signature is another way to protect your Workbook, this is one of the easier protections to break, and all you need to do is remove the signature.

Why should I use it then?

If you need to prove to someone that the document has not been tampered with this will help you. Digital Signatures or Digital Certificates have specific information in them that can be checked to see when it was created.

Differences between Digital Signatures:

If you have not yet created a digital signature, or someone else has not created one for you, there are two types of digital signature that you can create.
     1. Free Digital signature
     2. Paid for Digital Signature

What are the differences?

If you purchase a Digital Signature through a Microsoft Partner, other people will be able to verify that that is your Signature (Certificate).  If you use the free version, others will not be able to verify that you signed the document unless they use the computer that the Signature (Certificate) was created on.

To create a Digital Signature:

     1. Click the Office Symbol Button
      2. Hover over the Prepare Button
      3. Click the Add a Digital Signature
            a. A Dialog Box will appear
            b. Here you can choose if you wish to purchase a Signature (Certificate) or use the free one.
                  i. By clicking the Signature Services from the Office Marketplace… you will be sent to the web and offered several options to purchase one.
                  ii. If you click the OK you can create your own.
      4. After you click OK, you will be offered the choice of purchasing a Digital Signature or Create your
own.
      5. Let us choose Create your own digital  ID
      6. Click OK
      7. Another Dialog box will appear. The  Dialog box will be titled Create a  Dialog ID.
      8. Fill in the information that you want to see when you  look at the Digital Signature (Certificate).
      9. Click the Create Button.
      10. You will be asked to create a purpose for signing. You can use  any reason that you wish.
      11. Then Click the Sign Button.
      12. You will then see a  confirmation dialog. If you do not  wish to see this dialog after you  sign another document just check  the setting Don’t show this  message again.
      13. Hit okay, this dialog box  will disappear, and another dialog  box will appear
      14. A signature validation dialog will show at the right side of  the spreadsheet and it will show the name of the  signature.
            a. You can hide the signature box by clicking the X in  the right hand corner.
            b. In the status bar at the bottom of the Workbook  you will see a symbol that  indicates the  Workbook has been  digitally signed.
            c. If the Valid signature dialog box has been closed you can reopen it by double clicking this icon. There is another way to open the dialog box by clicking the office symbol, going to the prepare selection and clicking the View Signatures button.
      15. The Digital Signature will do two things for you.
            a. It will sign the Workbook.
            b. It will automatically mark the Workbook as Read Only. Read Only means that others  cannot change any content within the Workbook.

The Mark as Final Option in Excel 2007

What does Mark as Final do for me?

Mark as Final will make your Workbook a Read Only, similar to the Digital Signature, however, the Digital Signature add another level of security. The Mark as Final can be removed and then the information changed and then the Mark as Final can be added again.

In order to mark a workbook as final
1. Click the Microsoft Office Symbol
2. Hover over the Prepare option
3. Click the Mark as Final option
4. A Dialog Box will appear
5. Click the OK Button
6. Once you click the OK button a couple of things will happen.
     a. The Workbook will automatically save.
     b. Another Dialog Box will appear, the first time only unless you do not check the “Don’t show this message again” check box.
     c. An Icon will appear in the Status Bar.
     d. The Groups will become grayed out. With the exception of a few options.
     e. The Title Bar will show the words Read Only.

Remember: if you cannot access the options in the groups that you want the Workbook is in the Mark as Final, or read only mode.

To Remove the Mark as Final or Read Only

1. Click the Microsoft Office Symbol.
2. Hover over the Prepare option
3. Click the Mark as Final button; this will have an orange / gold square around it.
a. After this is done all the buttons in the groups should be active again.

Restrict Permission in Excel 07

     The restriction of permissions is similar to the Encrypt choice, with the exception that you need to sign up for this service through Microsoft. You have a free trial period and then Microsoft will start charging for the service. In the service agreement Microsoft states that they may retract the trial service before it officially ends and you will be given the choice of purchasing the service if you desire.


     To start this you need to go to the Office Symbol, then Prepare and then Restrict Permissions. Once you hover over Restrict Permissions you will get a small dialog box that gives you three choices.

• Unrestricted Access: Anyone can read the document.
• Restricted Access: Only those with the correct credentials can read  the document.
• Manage Credentials: You can change the credentials.  If you choose anything other than Unrestricted Access you will get a dialog box that asks if wish to sign u for this service. Later on I will discuss another way to estrict access to the document.

Encrypt Document in Excel 07

The encryption of an Excel Workbook is up to you.

What does encryption do for me?

Good Question, encryption is a safeguard method that ensures the safety of your Workbook. The only people that can read your Workbook are those that have the password. If the password is not input correctly the document will not open, you will just get the Excel program with no Workbook.
Remember: that if you forget the password yourself there is little probability that you will be able to open your own Workbook. Even Microsoft says that if you forget your password there is no way of recovering it.
There are a couple of different ways to password protect your document, one is password protect to open, and the other is password protect to modify. The encryption method we are talking about now is password protect to open.

Let’s get started.

In order to use the encryption click the Microsoft Office Symbol, hover over the word Prepare and the Prepare menu will show. Click the Encrypt Document selection. Once you do this a dialog box will appear. Enter the password that you have selected.

Remember: do not forget the password or you will not be able to access your information.
After you enter your password click the OK button. Once you have done this another dialog box will open this will ask you to confirm your password.

Microsoft put this in as a measure to ensure that you have input the password correctly. If the two passwords do not match you will get a dialog box that states Confirmation password is not identical.

The passwords must be put in the same. If you used a combination of uppercase and lowercase it must be the same. As an example, PassWord must be PassWord in order to work. If you typed PassWord and then Password you will get the confirmation error dialog box again. It is the same if you use alpha numeric passwords.

Hint: Keep in mind that there is no way that Excel can be set to force the user to save the Workbook with encryption.


Remember: Even Microsoft says that there is no way to retrieve a forgotten password, so if you forget the password you will have to reconstruct the Workbook.

If you want to make sure that the Workbook has been encrypted you can check by going to the Prepare selection again. If the Workbook has been encrypted there will be an orange/gold color around the icon as shown in the example above.

You can also check other workbooks in the same way.

Remember: Even Microsoft says that there is no way to retrieve a forgotten password, so if you forget the password you will have to reconstruct the Workbook.

The Document Inspector in Excel 07

Document Inspector

You can inspect your document to see what kind of information is associated with your Workbook.

1. Comments and Annotations
     a. If you have used any collaboration tools (we will talk about these later) it will check for this        information. Such as Comments, Track Changes.
2. Document Properties and
Personal Information a. Document properties also known as Metadata (Data about data. Such as the Author of the document, the date that the document was created, and the location on a computer or network that the document was created).
3. Custom XML Data
     a. XML (Extensible Markup Language, a form of code that the newer versions of Microsoft Office use that is Human readable and Machine readable. It serves to decrease the file size and reduce the possibility of corruption of the newer files that are created.) There are some portions of this that the file does not really need for the operation of the file and it can be removed without degrading the file in any way.
4. Headers and Footers
     a. Information saved in the Header and Footer Sections you can remove here.
5. Hidden Rows and Columns
     a. If you have hidden Rows or Columns that no one should see if you are sharing the information in this Workbook this will remove these hidden items.
6. Hidden Worksheets
     a. Much like the hidden rows and columns, although this will delete hidden Worksheets.
7. Invisible Content
     a. These are invisible object that you may have; no one can see them because they have been formatted to be invisible. This will remove them for you if you want.

After you have run the inspection you will get a second dialog box that appears. This will give you the opportunity to decide if you want to remove certain sections. As seen in the photo below. You will have a Remove All button next to the sections that have found information in them.

Once you click the remove all you can also Reinspect the document by clicking Reinspect, or you can close the dialog box.

Hint: 

Remember to save this workbook under another name otherwise you will lose all the information that you removed from your original Workbook. Then the only way to retrieve that information after it has been removed is to re-enter it in the Workbook.

The Prepare Choices in Excel 07

Properties: 

As shown in the picture below, under Document Properties, this dialog box shows;
1. The Author (typically the name that was put in at the installation of Microsoft Office.
2. Title (here you can enter a title for the document).
3. Subject (here you can enter a subject matter).
4. Keywords (here you can add keywords to help if you need to search for the file and cannot remember where you saved it, or the name of the file).
5. Category (here you can add a category name).
6. Status (here you can add a status to the Workbook, Complete, In Progress, or whatever you desire).
7. Comments (Here you can add comments).

After all the information is in simply click the X on the tan bar to close the dialog box.

Print Using the Microsoft Symbol Button in Excel 07

Print

Print: Will open a dialog box that you can choose the printer that you want to use. All or specific pages that you want to print. Print Selection, Active Sheets, Entire Workbook, Ignore Print Areas, or Table. The Number of Copies you want.

Quick Print

Quick Print: Will send the information directly to the primary printer.

Print Preview

Print Preview: Will allow you to see what the Spreadsheets will look like when printed so you can make adjustments without using paper

Save and Save As in Excel 07

Save

Save and Save as will act the same the first time that you save a brand new workbook. After that the Save button will overwrite the existing document without asking if you wish to do so.

Save As

Will allow you to save a copy of the workbook anywhere you want to on your hard drive or network.
Excel Workbook: saves the workbook in Microsoft Office 07 format. No previous version of Office can open this without downloading a patch.
Excel Macro Enabled Workbook: saves a Macro Enabled workbook in Microsoft Office 07 format. We will discuss what Macros are later.
Excel Binary Workbook:
Excel 97-2003 Workbook: saves a copy of the workbook in a format that Microsoft Office 97 to 03 can open. This is a good format if you have friends that do not have Microsoft Office 07.
The Adobe PDF choice is on my system because I also have Adobe CS4 installed.
OpenDocument Spreadsheet: saves a file that can be opened with Open Office, this is a freeware version of Office and can be downloaded at http://www.openoffice.org/ .
PDF or XPS: will allow you to save as an Adobe PDF file or an XPS file. The PDF file is more commonly used for downloads on the internet as they are smaller in size than an Office file. They also have the distinction of being a read only file so it is harder for people to modify this type of document. You may have to download the patch for this if you have not used this option yet. Of you click on this option it will automatically determine if you have used it before or if the patch has been installed. If the patch has not been installed it will send you to the download site. Save the patch to your computer and install it, and now you are ready to publish this type of file.

Hint: If you want to modify the file in the future remember to save it as an Office Document as well. If you do not then you will have to recreate this document.

A Closer Look at the Menu Items New

New

Left Column

As you can see there are three main parts to the dialog box that appears after you press New. The left side gives you several choices that you can choose from. This has two headings in the column, Templates and Microsoft Online.
Under the Templates heading there are 4 choices
1. Blank and Recent
2. Installed Templates
3. My Templates…
4. New From Existing…
Under the Microsoft Office Online Heading there are 30 categories, each has more options listed.
1. Featured
a. Will vary depending on what templates are being featured at the time.
2. Access Databases
a. May be blank.
3. Agendas
a. Will show Icon views of Agenda Templates.
4. Books
a. Academic Books (show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
b. Address and Phone Books (show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
5. Brochures and Booklets
a. Brochures (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
6. Budgets
a. Business Budgets (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
b. Forecasts (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
c. Home Budgets (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
7. Calendars (These hyperlinks may change as to the years involved.)
a. 2012 Calendars (Will show as a hyperlink in the center column)
Excel 2007 by Shawn Ritter 2 Copyright 2012
i. When pressed it will show Icons for the templates you can choose.
b. 2011 Calendars (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
c. 2010 Calendars (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
d. Academic Year Calendars (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
e. Multiple-Year Calendars (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
f. Previous Year Calendars (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
g. Other Calendars (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
8. Cards
a. Identification Cards (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
b. Name and Place Cards (Will Show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
c. Note Cards (Will Show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose.
9. Charts and Diagrams
a. Business Charts (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose .
b. Floor plans and seating charts Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Process Diagrams (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
d. Smart Art Graphics (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
e. Other Diagrams (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
10. Faxes
a. Will show Faxes templates
11. Flyers
a. Real Estate Flyers (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
b. Posters (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Signs (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
12. Forms
a. Academic Forms (Will show as a hyperlink in the center column)
Excel 2007 by Shawn Ritter 3 Copyright 2012
i. When pressed it will show Icons for the templates you can choose
b. Applications (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Business Forms (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
d. Community Forms (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
e. Employment Forms (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
f. Evaluations (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
g. Math and Science Tables (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
h. Medical and Healthcare Forms (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
i. Personal Forms (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
j. Quizzes and Tests (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
k. Scorecards (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
l. Sign-in and Sign-up Sheets (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
m. Sports Forms (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
n. Surveys (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
o. Tournament Brackets (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
13. Inventories
a. Will Show Icons for Inventories
14. Invoices
a. Bids and Quotes (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
b. Estimates (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Finance Charges (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
d. Packing Slips (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
e. Purchase and Sales Orders (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
Excel 2007 by Shawn Ritter 4 Copyright 2012
f. Sales Invoices (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
g. Service Invoices (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
h. Work Orders (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
15. Labels
a. Mailing and Shipping Labels (Will show as a hyperlink in the center column)
i. Business Mailing Labels (Will show as a hyperlink in the center column)
1. When pressed it will show Icons for the templates you can choose
ii. Home Mailing Labels (Will show as a hyperlink in the center column)
1. When pressed it will show Icons for the templates you can choose
b. Office Labels (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Other Labels
16. Letterhead
17. Letters
a. Emails (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
18. Lists and to-do Checklists
a. Academic Lists (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
b. Business Lists (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Community Lists (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
d. Home Lists (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
e. Menus (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
f. Trackers (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
19. Memos
a. Will show Icons form Memos in the center column
20. Planners
a. Will Sow Icons for Planners in the center column
21. Plans and Proposals
a. Academic Plans (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
b. Business Plans (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Bylaws, Policies, and Rules (Will show as a hyperlink in the center column)
Excel 2007 by Shawn Ritter 5 Copyright 2012
i. When pressed it will show Icons for the templates you can choose
d. Home Plans (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
e. Instructions (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
f. Medical and Healthcare Plans (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
22. PowerPoint Presentations and Slides
a. Business Presentations (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
23. Projects
a. Other Projects (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
b. Project Calculators (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Games(Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
d. Office 2007 Document Themes (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
24. Receipts
a. Will show Icons for Receipts in the center Column
25. Records
a. Academic Records (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
b. Financial Records (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Home Records (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
d. Human Resources Records (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
e. Journals (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
f. Ledgers (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
g. Logs (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
h. Medical and Other healthcare Records (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
i. Other Records (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
26. Reports
a. Analysis Worksheets (Will show as a hyperlink in the center column)
Excel 2007 by Shawn Ritter 6 Copyright 2012
i. When pressed it will show Icons for the templates you can choose
b. Expense reports (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Financial Reports (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
d. Project and Status Reports (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
e. Other Reports (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
27. Schedules
a. Academic Schedules (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
b. Business Schedules (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Itineraries (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
d. Timelines (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
e. Other Schedules (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
28. Statements
a. Will show Icons for Statements in the center Column
29. Stationary and Specialty Paper
a. Handwriting Practice Paper (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
b. Lined and Grid Paper (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
c. Music Paper (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
d. Other Specialty Paper (Will show as a hyperlink in the center column)
i. When pressed it will show Icons for the templates you can choose
30. Time Sheets
a. Will show Icons for Time Sheets in the center column

The Middle Column

1. Has a search option
2. Has an Icon option

The Third Column / Right Side

 Shows a brief preview of the document

The Office Symbol in Excel 2007

Starting from the top left of the Ribbon. The Microsoft symbol is actually not only for decoration, it is like the “File” menu from older versions of Microsoft Office. If you left mouse click on the button it will bring up a menu that you can choose certain functions.

1. New, for creating new Excel Workbook. CTRL+N.
2. Open, Opens saved documents, CTRL+O.
3. Save, Saves an Excel Wordbook, CTRL+S.
4. Save As, you can change the Name and Location of the file, while keeping the original file unchanged. Or you can change the type of file that you want to save it as, such as a PDF (adobe) file instead of the Microsoft Excel File (XLSX).
5. Print, you can choose the Printer you wish to print to, if you have more than one printer.
6. Prepare, This allows you to view or add to the properties of the Workbook. Remove certain information, Protect the Workbook, and run a compatibility checker.
7. Send, Allows you to send as an email attachment or fax.
8. Publish, Allows you to publish the Workbook to different arenas
9. Close
10. Excel Options, Lets you customize your version of Excel.
11. Exit Excel, of course exits the current Workbook.

How to tell at a Glance What Version the Workbook has been Saved in

This icon belongs to Office 2007. If you take a good look at the small green Excel part of the icon you will notice that the upper right hand corner has been rounded. All previous versions of Office have all square corners as shown in the picture to the right.

Other New Features in Office 07

1. The toolbars have been replaced by Ribbons.
2. You can save as a PDF file by downloading a patch.
3. You can use more than three Conditional Formats.
4. Conditional Formatting presets have been added.
5. New Functions have been installed.
6. Quick Formatting for Tables have been added.
7. Quick Formatting for Charts and Graphs have been added under the Insert Tab.
8. On the Formulas Tab Functions Libraries have been added for quick use.

A look at the Main Workbook in Excel 2007

A look at the Main Workbook...
What is a Workbook?
Good Question, the workbook is Excels main document; it houses the Spreadsheets also sometimes called Worksheets.
The example below shows the Workbook, the main container of Excel. Inside of the Workbook there are three Spreadsheets. Three is the number of default Spreadsheets as designated by Microsoft.
A quick overview of the Microsoft Workbook Window, they will be explained in more detail later. For now I will give an overview.
Starting at the top left;












1. The Office Symbol, this is also a Command Button
2. The Quick Access Tool Bar (One of the two remaining tool bars left)
3. The Title Bar
4. Three Command Buttons
5. Back to the Left side of the screen, The Ribbon Headers
6. Groups
7. Title of the Group
8. Address Bar
9. Functions Dialog Bar
10. Select All Button
11. Now to the Spread Sheet, Column Headers (A, B, C…)
12. Running down the left side, Row Headers (1, 2, 3, …)
13. Cells
14. Move Buttons for the Spreadsheets
15. Tabs for the Spreadsheets
16. Slider bar For the Tabbed Spreadsheet
17. Status Bar