Excel 2007 is Microsoft Office Suite's software program for preparing spreadsheets and for creating mathematical formulas and calculations used in business analysis or any other activity where numbers are involved. In this article, you will learn how to use the new 2007 version of Excel with a description of each tab and the commands and actions grouped within each of those tabs. You can use Excel to do simple calculations, mathematical functions and complex formulas for activities such as preparing a balance sheet, compiling numerical representations of any kind of performance activity, business intelligence and analytics and a whole lot more.
- Home Tab: This tab contains sub-tabs for ‘clipboard', ‘font' settings, ‘alignment', ‘number' formatting, ‘styles', ‘cells' and ‘editing'. The clipboard allows users to make changes by cut, copy and paste actions and also copy formatting from one place to another in the spreadsheet. Font settings allow you to experiment with different fonts, colors, text sizes, etc. Alignment can be used for merging and centering actions, wrapping text within a cell space, etc. The number sub-tab provides the options for formatting numbers, adding decimal places, percentage values, etc. The cells tab allows the user to create tables, highlight values and prepare cells in different designs and formats. Editing allows you to sum up totals of a selected number of values, sort and filter cells as per your requirements. The cells' tab lets you add or delete cells, find and replace selected text or numbers or replicate into other cells.
- Insert Tab: This tab has 5 sub-groups - tables, illustrations, charts, links and text. The tables group contains commands for preparing pivot tables from data inserted in the spreadsheet or general tables for organizing and analyzing spreadsheet data. Illustrations' allows you to insert a variety of pictures, clip-art, shapes and smart-art into the spreadsheet. Charts contain options for inserting charts of different kinds - column, line, bar, pie, area, scatter and several more charts. Links allow users to link spreadsheet data with web pages, email addresses, pictures or programs. The text grouping is comprised of commands to create text boxes, addition of headers and footers, signature lines, objects or symbols into the spreadsheet.
- Page Layout: This tab contains five sub-tabs - themes, page setup, scales, sheet options and arrangements. The themes sub-tab gives you access to commands for altering the overall design and look of the spreadsheet, font size and color changes as also cell text colors and sizes. The other four sub-tabs provide numerous options to format and align spreadsheet pages in terms of height, width, fitting for printing options, gridlines addition or deletion and movement of individual worksheets within a file in selected orders.
- Formulas & Data tabs: These tabs contain functions and formulas of numerous types and requirements depending on the user. There are also commands for checking calculations, correcting errors, tracing precedent and decedent origins of selected data, addition of data from external sources, grouping and un-grouping of cells, data validation, advanced sorting and filtering of data, etc.
- Review & View tabs: The review tab contains commands for checking language, spellings, grammar, etc. It also allows users to add comments make changes and track them and options for protecting the spreadsheet and limiting access to other users as required. The view tab provides options for appearance of the spreadsheet, printing preference and creating macros.
The 2007 Excel definitely shows improvement over previous versions, not only in terms of appearance and look, but also in the various options, designs and themes which allow users to create all kinds of spreadsheets - from simple ones to complex data compilations in a simple and attractive manner.