Technology How To

Microsoft Online Training Central

Microsoft Excel 2007 Online Training

The New Ribbon for Microsoft Excel 2007

With the new Ribbon installed on Microsoft Excel 2007, many of the options have different locations than the previous versions of the program. Within these tabs, the user can still access the old Microsoft Excel dialog boxes by clicking on the boxed arrow located at the bottom right of each tab option box.

Tab Contents for Microsoft Excel 2007

Home
•Clipboard- includes cut, copy and paste
•Font- edit font size and style
•Alignment- select alignment of text in spreadsheet field
•Number- format how the numbers in the cells are displayed
•Styles- conditional formatting, tables and cell styles all allow for professional spreadsheets
•Cells- insert, delete or format cells
•Editing- find, select, group and arrange data within cells

Insert
•Tables- insert basic table or pivot table
•Illustrations- insert clip art, picture from file, shapes or NEW Smart Art
•Charts- create any type of chart to represent your data
•Links- insert hyperlink
•Text- insert text box, header, footer, Word Art, symbols, etc.

Page Layout
•Themes- select from previously installed themes for your data
•Page Setup- edit margins, size, print area, orientation, etc.
•Scale to Fit- Stretch or shrink size of data to fit printed pages
•Sheet Options- select whether gridlines and headings are visible
•Arrange- Align and arrange inserted objects

Formulas
•Function Library- insert preset functions for data inputs
•Defined Names- Name cells so you can refer to them in formulas by that name
•Formula Auditing- includes all existing formula options including cell referral
•Calculations- specify when formulas are calculated

Data
•Get external data- retrieve data from the web, from Access, or from text
•Connections- Displays all data connections for the workbook
•Sort and Filter- sort and filer data based on specific criteria
•Data Tools- separate text into columns, remove duplicates, consolidate data, etc.
•Outline- group data for collapsible cells, ungroup cells, insert subtotal cells

Review
•Proofing- use spell check, research, thesaurus, etc.
•Comments- Add new, edit and delete comments for slides
•Changes- Keep track of and protect changes within the workbook

View
•Workbook Views- select from many different viewing formats
•Show/Hide- ruler, gridlines, formula bar and headings
•Zoom- in and out
•Windows- Add more windows to compare changes to workbook
•Macros- record new and view already existing macros

Conditional Formatting
By using the Conditional Formatting tool within Microsoft Excel, you can highlight interesting or unusual cells, point out important trends within data, or place icons to make your spreadsheet look appealing. Any style of display that you desire to place within your spreadsheet is possible through Conditional Formatting.