Excel 2007 Introduction

Discover the three primary functions of Excel: a spreadsheet for numeric data and calculations, a charting tool for graphical displays, and a simple flat file database with sorting and querying.

Learn the core spreadsheet vocabulary in Excel 2007, including workbooks, worksheets, cells, cell ranges, addresses, and functions, with a focus on writing formulas and using the sum function.

Launch Excel 2007 from desktop, taskbar, or start menu by locating Microsoft Office in all programs and opening Excel 2007.

Navigate excel interface using the ribbon and tabs, customize the quick access toolbar for features like page break preview and new workbook, and manage sheets, name box, and formula bar.

Open a workbook in Excel 2007 by using the Office button to access the open command, navigate drives and folders, and select a file such as sales by districts to open.

See how a spreadsheet displays labels and numbers, and use the formula bar to reveal the underlying formula that creates the cumulative total.

Explore how to use the zoom slider to view large spreadsheets more efficiently, zooming in and out to fit more data on screen, without affecting print settings.

Explore the three Excel 2007 views—normal, page layout, and page break preview—to manage margins and page breaks, with the View tab as a quick switch.

Learn fast navigation techniques for large spreadsheets by using the scrollbar, the thumb, page up/down, arrow keys, and control+arrow to jump across data ranges to the edges.

Learn to create and manage a new workbook in Excel 2007, enter data, navigate and rename multiple worksheets, use autofill, delete ranges, undo or redo actions, and save the workbook.

Enter text and numbers in Excel 2007 by selecting cells with the cell selector, building a skeleton spreadsheet with labels, and using enter and arrow keys to speed data entry.

Learn how autofill in Excel 2007 uses the fill handle to extend sequences like months, days, and dates, copy text with increments, and choose custom fill options.

Learn to use undo and redo in Excel 2007 to reverse multiple actions, via the left arrow on the Quick Access Toolbar, and the right arrow for redo while editing.

Learn how to delete a worksheet in Excel 2007 by right-clicking the sheet and selecting delete, then heed the warning that deleted data cannot be recovered.

Use the office button to save or save as; for the first save, choose save as to name and locate the file, then save updates the current workbook.

Learn to build simple formulas and apply the order of operations in Excel 2007, using auto sum and functions. Explore date arithmetic and relative vs absolute referencing.

learn how to enter simple formulas in excel 2007 by starting with the equal sign, totaling data automatically, and editing formulas in the formula bar to stay updated.

Master using Excel functions such as sum, max, and min by entering formulas with equals and parentheses, selecting ranges with the mouse, and exploring the insert function dialog.

Learn to use autosum to quickly total values by clicking the autosum icon in the home tab; Excel builds the sum formula and autofill copies it, adjusting references.

Explore using the auto sum button to total data fast in Excel 2007, then compute the quarter's average with the average function by selecting the range B3 through B6.

Learn to create formulas in Excel 2007 using basic math for tasks without functions, calculate 10 percent of totals, fill down, and save or open files via the Office button.

Use Excel's auto calculate on the status bar to view quick totals, averages and counts for a selected range without adding formulas; customize options by right-clicking the status bar.

Learn how to use relative and absolute cell addressing in Excel 2007, calculate percentages of totals, and reliably copy formulas with absolute references such as $C$13.

Format a worksheet in Excel 2007 by adjusting column width and row height, inserting or deleting rows and columns, hiding them, and applying numeric and text formats, borders, shading.

Insert and delete rows and columns in Excel 2007 by selecting the target rows or columns, using the insert or delete commands, or right-clicking for quick shortcuts.

Learn to apply numeric formats in Excel 2007, including currency, thousands separators, percent, and decimal precision, using the home ribbon and the format cells dialog box.

Learn to apply character formatting in Excel 2007: change font and size, apply bold, italic, underline (including double underline), font color, and features like strikethrough, superscript, and subscript.

Master horizontal and vertical alignment in Excel 2007, using merge and center to span across selected cells, adjust row height, and enable wrap text for long notes.

Discover how to apply borders and shading in Excel 2007, customizing border styles, thickness, and color, applying interior shading, and using quick table formats to enhance data presentation.

Apply cell styles in Excel 2007 to quickly create consistent formatting with heading levels (heading 1, 2, 4), shading, and subtotals, enhancing readability.

Apply themes across Excel and other Office 2007 apps to keep your spreadsheet in sync with Word and PowerPoint, changing the whole look on the fly.

Explore managing large worksheets with Excel using zoom, split and freeze panes, and unfreeze. Learn to tile workbooks, synchronize scrolling, and hide or arrange multiple windows.

Learn to freeze panes in Excel 2007 to keep headers visible while scrolling, and unfreeze panes when needed; explore freezing the top row, left column, or both.

Open multiple workbooks, arrange them side by side with tiles, horizontal, vertical, or cascade layouts, and manage hidden workbooks by switching and unhiding windows.

Protect the sheet in Excel 2007 by locking cells to guard totals and formulas, including office-use fields, with optional password protection.

Learn to insert and remove page breaks in Excel's page layout tab. Use dashed indicators to preview breaks and reset default breaks for half by 11 pieces of paper.

Use Excel's page break preview to view and adjust page breaks by dragging blue lines, choosing to fit all data on one page through scaling, while noting readability may suffer.

Manipulate page breaks and use print preview to see how the spreadsheet fits on a page. Explore page setup and scaling options, including paper size, to preview print output.

Switch from portrait to landscape orientation and adjust margins in page setup to fit wider spreadsheets, preview with print preview, and set print titles for first page in excel 2007.

Discover how print area confines printing to a specific region, such as columns a through d, instead of the entire spreadsheet, and learn to clear or set print area.

Set up print titles to repeat row 1 across every page, using the sheet tab to select the row and confirm for readable printouts.

Use the header and footer tab in page setup to add path and filename, page numbers, and logos with left, center, and right panels.

Enable printing of gridlines and any comments from the sheet tab, using the gridlines and print preview options to view and print with the correct formatting.

Use the Excel print dialog box to print the current sheet by default, with options to ignore the print area or print the entire workbook.

Launch the Excel 2007 program, explore screen parts, and learn the terminology. Enter text, values, and formulas, use relative and absolute references, autofill, formatting, and print preview.