Excel Courses for Beginners - Excel Training Courses-What is Excel?

 

Excel Courses for Beginners - Excel Training Courses

Home Tab

The Home tab contains the most frequently used commands, such as those for formatting, clipboard operations, and editing.

·         Clipboard:

 Cut, copy, paste, and format painter.

·         Font:

 Change font type, size, color, bold, italic, underline, borders, and fill color.

·         Alignment:

 Align text left, center, right, top, middle, bottom, wrap text, merge cells.

·         Number:

 Format numbers as currency, percentage, comma, date, time, fraction, scientific, and more.

·         Styles:

 Apply cell styles, conditional formatting, and format as table.

·         Cells:

 Insert, delete, and format cells, rows, columns, and sheets.

·         Editing:

 Find and select, replace, fill, clear, sort, and filter.

Insert Tab

The Insert tab provides options to insert various elements into a worksheet.

·         Tables:

 Insert tables and pivot tables.

·         Illustrations:

 Insert pictures, clip art, shapes, and SmartArt.

·         Charts:

 Create different types of charts like column, line, pie, bar, area, scatter, etc.

·         Links: 

Insert hyperlinks.

·         Text:

 Insert text boxes, headers, footers, WordArt, signature lines, and objects.

·         Symbols:

 Insert equations and symbols.

Page Layout Tab

The Page Layout tab includes commands for arranging and formatting the overall appearance of the worksheet.

·         Themes:

 Apply themes, colors, fonts, and effects.

·         Page Setup: 

Adjust margins, orientation (portrait or landscape), size, print area, breaks, background, and print titles.

·         Scale to Fit:

 Adjust the scale of the worksheet to fit a certain number of pages when printing.

·         Sheet Options:

 Show/hide gridlines and headings, and print options.

·         Arrange:

 Arrange objects, bring forward, send backward, selection pane, align, group, rotate.

Formulas Tab

The Formulas tab is used for working with formulas and functions.

·         Function Library:

 Access a variety of functions categorized into Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, and more.

·         Defined Names:

 Define, use, and manage named ranges.

·         Formula Auditing:

 Trace precedents, trace dependents, remove arrows, show formulas, error checking, evaluate formulas, watch window.

·         Calculation:

 Set calculation options (automatic, manual), calculate now, calculate sheet.

Data Tab

The Data tab contains tools for importing, managing, and analyzing data.

·         Get External Data:

 Import data from various sources like Access, web, text, XML, and more.

·         Connections:

 Manage data connections.

·         Sort & Filter:

 Sort data, apply filters, clear filters, reapply filters, advanced filtering.

·         Data Tools:

 Text to columns, remove duplicates, data validation, consolidate, and what-if analysis.

·         Outline:

 Group, ungroup, and subtotal data.

Review Tab

The Review tab offers tools for reviewing and protecting the worksheet.

·         Proofing: 

Spelling check, research, thesaurus, translation, and new comment.

·         Comments: 

Insert, edit, delete, and navigate comments.

·         Protect:

 Protect worksheet and workbook, share workbook, allow users to edit ranges.

·         Changes: 

Track changes, accept/reject changes, list changes on a new sheet.

View Tab

The View tab helps to control how the worksheet is displayed.

·         Workbook Views:

 Normal view, page layout view, page break preview, custom views, full screen.

·         Show/Hide: 

Show or hide the ruler, gridlines, formula bar, and headings.

·         Zoom:

 Zoom in/out, 100%, zoom to selection.

·         Window: 

New window, arrange all, freeze panes, split, hide, unhide.

·         Macros:

 View, record, and use macros.

This overview should help you understand the different functionalities available in each tab of Microsoft Excel 2007.