Microsoft Excel: Step By Step Excel For Complete Beginners

Open Excel, create a new blank workbook, and save it as a named file using save as, with auto save and the default book seven name plus undo and redo.

Explore the Excel ribbon—the brains of Excel—and its main tabs—home, insert, page layout, formulas, data tools, and help—and learn to customize the ribbon and add new tabs for beginners.

Master the name box and formula bar to identify the active cell, view and edit cell formulas, and insert functions, with tips to resize the formula bar for long formulas.

Learn to manage Excel workbooks by adding and renaming sheets, color-coding tabs, and using zoom to adjust view, while noting circular references.

Learn to save using save or save as, rename and navigate directories, and choose CSV export or an Excel file to support macros and compatibility.

Navigate a large Excel sheet quickly by using the End key to jump to the bottom, then use down or right arrows to reach data.

Learn how to move rows and columns in Excel, including selecting, dragging with the cross and arrows, and using shift right to move or copy, with undo tips.

Use auto sum to quickly add a range; the total updates when you insert a row. Insert the average function, select the range, and press enter to see the average.

Create a simple data table in Excel with headers and monthly data, apply a table style, adjust column width, and convert back to a range.

Format a table manually in Excel to control appearance, using shading, merged headings across five columns, center across the table, font size 28, thousands separators with no decimals, and borders.

Select the entire table, name the print area for quick reuse, and set rows and columns to repeat so headers print clearly across pages.

Select rows two and three to repeat at the top and column B to print on every page. Use page layout options to adjust scaling, orientation, and grid lines.