Excel 2007 Overview Guide - Part 3 - The Ribbon (Data, Review, View & Contextual Tabs)


Uploaded by spreadsheetrepublic on 15.02.2011

Transcript:
Welcome back to Part Three of my Excel 2007 Overview Guide.
Let's now move on to look at the Data Tab.
The Get External Data Section contains a range of tools to help you import data into Excel 2007.
You can import data from Microsoft Access;
From tables on websites;
From Text files;
and from other sources, such as XML, SQL, etc.
You can also easily select from a range of data sources that you most commonly use.
The Connections Section allows you to manage and refresh any external data connections you may have.
The Sort & Filter Section enables you to manage your data within Excel 2007.
You can sort selected data with the lowest values at the top, or vice versa.
Sort your data based on criteria that you specify.
Apply a Filter to your data, allowing you to select what data you want to be displayed from drop down menus.
Clear, or reapply filters or data sorts.
As well as, enabling you to apply more advanced filters to your data.
The Data Tools Section contains a range of tools that will help you manipulate your data.
You can separate text contained in one cell into multiple columns.
Find and delete duplicate rows within your data.
Set limits on what data can be entered in cells.
Combine multiple groups of cells into one.
As well as, carrying out more advance data analysis tasks.
The Outline Section enables you to manage how data is displayed in your spreadsheet.
You can group, and ungroup selected cells.
Display subtotals and totals for grouped cells.
As well as, commands to expand, and collapse grouped data in your spreadsheet.
The popup menu option in the Outline Section allows you to tailor the position and look of summary fields in your data.
Let us look at the Review Tab now.
The Proofing Section contains tools that enable you to proof read your spreadsheet.
You can check for spelling errors.
Search for information online.
View a Thesaurus entry for the currently selected cells.
As well as, viewing a basic translation of the entry in the currently selected cell.
The Comments Section allows you to apply comments to cells. These act like electronic 'Post-It' notes for your spreadsheet.
You can add a new Comment in the currently selected cell, or delete a Comment.
You can move between Comments in the spreadsheet.
As well as, displaying all Comments, or just hiding the currently selected Comment.
The Changes Section contains a range of tools that allow you to protect your spreadsheets from unauthorized editing.
You can set up a password to protect your Worksheet, or the whole Workbook.
If you are using Excel 2007 on a networked PC you can allow multiple users to edit the file.
You can also restrict which cells other users can edit.
As well as, tracking changes made by others, and protecting those tracked changes from being deleted.
Now, let us have a look at the View Tab.
The Workbook Views Section allows you to select from a range of different views of your spreadsheet.
By default Excel 2007 will use the Normal View, but you can also select the Page Layout View,
which gives you an idea of what the page will look like once printed,
or the Page Break View, which shows you where page breaks are in your spreadsheet, and allows you to click and drag these breaks.
Custom View will allow you to set up the Worksheet View, and then save these custom options for use at a later date.
If you want to view your Worksheet without the Ribbon, then click on Full Screen.
Double click on the Title Bar if you want the Ribbon to reappear.
The Show/Hide Section contains a range of tick box options that
determine whether you want to view the Ruler, Gridlines, Headings, etc. on the screen.
The Zoom Section enables you to set a predetermined or custom Zoom level with which to view your Worksheet.
You can also quickly move back to 100% Zoom.
As well as, zooming into your current selection.
The Window Section contains a range of tools relating to viewing Worksheets in different ways.
With New Window you can open a new window in Excel 2007 that will contain another copy of your current Workbook.
Arrange All allows you display all open Workbooks on the screen at once.
Freeze Panes enables you to keep sections of your Worksheet on the screen at all times, even when scrolling to other areas of the Worksheet.
You can view multiple sections of your Worksheet with the Split command.
You can hide the current Workbook with the Hide command, and bring it back with Unhide.
View Side by Side allows you to compare two Worksheets next to each other; you can scroll both documents together with
Synchronized Scrolling, you can also reset the Worksheets to their previous position.
You can save the current window layout by using the Save Workspace command.
As well as, switch between open Workbooks.
The Macros Section allows you to create, run or delete Macros, usually used by advanced users.
When dealing with certain objects in Excel 2007, for example charts or inserting a shape or image,
Contextual Menu Tabs will appear on the Ribbon that will be relevant to the task you are working on.
These tabs will only appear while the object is selected, as you can see as I Insert a Shape into this Worksheet.
Once you deselect the shape, the Contextual Menu Tabs will disappear.
That is the end of Part Three of my Excel 2007 Overview Guide.
In Part Four we look at the Formula Bar, the Home Menu, the Quick Access Toolbar and the Status Bar.