Microsoft Excel for Beginners

Create your first worksheet by entering text, numbers, and dates, then edit data with undo, redo, and save. Upcoming lessons reveal how to manipulate numbers with formulas.

Learn to use Excel to calculate and manipulate numbers by entering formulas, and add two total titles to your worksheet as you prepare to create formulas in upcoming lessons.

Learn to create formulas with speed and accuracy using the fill handle to copy formulas across cells and automatically adjust references. Build yearly totals and a grand total in Excel.

Revisit fast, accurate formula creation using the fill handle in Excel to copy formulas across rows and nearby columns, with automatic adjustments and sum for large ranges.

Master how to create formulas in Excel starting with an equals sign, from simple additions to cell references and the SUM function, and use AutoSum to quickly total ranges.

Learn to edit a basic worksheet to improve readability by applying bold, underline, italics, fonts, titles, borders, and shading. Format numbers as currency or standard numbers to polish your data.

Learn how text is left aligned and numbers are right aligned in a worksheet, and how to adjust alignment in Excel by selecting cells and clicking the alignment buttons.

Select the cells, then apply a thick bottom border to separate sales data from totals, instead of using an underline, and explore other border options in later lessons.

Learn to adjust multiple column widths in Excel by selecting columns E to H and dragging between headings to set a precise width; you can also adjust row heights.

Learn to add a title across multiple columns, center it using the merge and center command, and create a single title in cell D-3.

Learn to calculate the average of a range using Excel's average function, copy the formula with the fill handle, and explore inserting functions for beginners.

Learn how to use the insert function (fx) in Excel to choose the average function, select the range E-6 through G-6, and copy the result with the fill handle.

Use the min function to identify the lowest sales figure. Build simple min formulas by selecting a range and inserting the function, like the max and average formulas.

Learn how to use the average, max, and min functions to compute statistics in a range of numbers, and use the insert function command to help build formulas.

Watch the video solution for practice lesson 5 in Microsoft Excel for beginners, reinforcing core beginner skills through guided problem solving and practical worksheet demonstrations.

Master inserting a new column in Excel by selecting the column to the right of year three heading, right-clicking, and choosing insert, while keeping the Acme Widget Company heading centered.

Learn to add a new column heading with the fill handle, copy formulas down for year 4 sales, keep totals updated, and adjust ranges for highest and lowest sales.

Insert a new row by selecting the row header, right-clicking, and choosing insert; add the southwest region, then auto-fit columns and use the fill handle for totals and averages.

Unhide all columns and rows in one step by selecting the entire worksheet with the select all button, then right-click column headings and row headings to make hidden data visible.

Master excel skills with the format painter, inserting and deleting columns and rows, and cutting, copying, and pasting data; learn tips to insert column headings and unhide columns or rows.

Change tab color by right-clicking and selecting color. Move or copy tabs by dragging; press control to copy with a plus sign, and you can delete the copied tab.

Learn to adjust margins in Microsoft Excel for beginners using presets, identify data boundaries with the dotted line, and remove blank columns to move data left and fit on page.

Center on page horizontally teaches centering data between margins and aligning the title over the data using merge and center, and uses print preview to verify the page.

Learn how to add headers and footers in Excel, insert page numbers and dates, and preview print layouts using the page setup and header/footer options.