Excel Tutorials For Beginners to Experts 2026

Select a cell, type, and press enter to accept data. Edit with double click or F2; use Alt+Enter for a new line, and Ctrl+Enter to fill across a highlighted range.

Learn how to use auto fill to quickly extend months, days, or consecutive numbers by dragging the fill handle, and apply Flash Fill to split names and automatically fill surnames.

Explore how to enter dates in excel using slash or dash formats, learn different date entry options, and also enter times as data.

Undo and redo actions in Excel using the quick access toolbar and keyboard shortcuts like Ctrl+Z and Ctrl+Y, including multi-action options from the undo and redo drop-down menus.

Learn how to insert, edit, and delete comments in Excel using the review tab or the shift+f2 shortcut. Show or hide comments and use right-click options to manage them.

Navigate backstage view to create a new workbook, open existing workbooks from OneDrive or your computer, and save or save as with keyboard shortcuts and the quick access toolbar.

Start formulas in Excel with an equals sign and select cells by mouse, arrow keys, or cell addresses. Use plus or the sum function, and edit formulas in formula bar.

Copy formulas to adjacent cells using the fill handle or by copying the cell and pasting special formulas; use right-click to paste special formulas to extend downward.

Learn how Excel applies the hierarchy of operations—parentheses, exponent, division, multiplication, then sum and subtraction. Discover practical tips for percent formatting, copying formulas with shortcuts, and using the fill handle.

Learn how absolute references keep a row or column constant when filling cells, using the dollar sign and F4 to toggle between relative and absolute references.

Master autosum in Excel to quickly sum numbers across rows and columns, using the home tab, drop-down options, or quick analysis. Explore using average and max functions with autosum.

Master font formatting in Excel by adjusting font type and size, applying bold, italic, underline or double underline, borders, fill color, and font color via the format cells dialog (Ctrl+1).

Adjust column width and row height in excel by selecting columns or rows, dragging to resize, and using best fit or the column width and row height options.

Master excel alignment skills by adjusting horizontal alignment left, center, and right, vertical alignment top, middle, and bottom, wrapping text, indenting, merging cells, and rotating text via format cells.

Master the number command group to format numerical data with number, currency, accounting, and percentage formats, adjust decimals, and apply zip, phone, or social security number formats.

Format cells as date or time in Excel, choose built-in or custom date formats from the number category, using d, m, y; use now to display current date and time.

Apply conditional formatting to highlight data with data bars, color scales, and icon sets. Create, edit, and manage rules, use greater than 25, and customize formats for cells.

Learn to analyze data in Excel with tables by inserting, sorting, filtering, and displaying a total row, using format as table and design tab options.

Explore how to insert pictures, shapes, and SmartArt in Excel to create visual worksheets. Learn to resize, format text, and include screenshots to build engaging diagrams and graphical lists.

Learn how to insert and delete cells in Excel by adding rows and columns, using right-click menus and keyboard shortcuts like Ctrl plus and Ctrl minus.

Learn to hide and unhide rows and columns in Excel 2013 using the home tab format, right-click menus, and shortcuts such as Ctrl+0, Ctrl+9, and Ctrl+Shift+Down for unhiding rows.

Learn to move, copy, and paste data in a worksheet using cut and paste, drag and drop, and clipboard options from the home tab, with shortcuts Ctrl-X, Ctrl-C, and Ctrl-V.

Use Excel's find and replace to locate occurrences across a sheet. Open the dialog with Ctrl+F or Ctrl+H and replace text or formatting, one by one or with replace all.

Master page setup in Excel by adjusting margins, orientation, and page size; set print areas and breaks, apply header and footer, and scale data to fit on one page.

Master page break preview and page layout in Excel 2013, learn to insert and remove page breaks, adjust zoom, and customize header and footer for printing.

Learn to print an Excel workbook using the print pane and preview, choosing active sheets, entire workbook, or a cell range, with options for copies, margins, and orientation.

Explore Excel's recommended charts feature to automatically generate pre-configured charts from your data, using the insert tab to preview chart types that best match your data.

Learn to insert and move charts in Excel by selecting header-inclusive data, choosing chart types (clustered column, line, pie), previewing with quick analysis, and moving charts to new sheets.

Master chart formatting shortcuts in Excel to add chart elements, apply predefined styles, and adjust colors and filters. Access hidden components, and quickly filter or hide rows and columns.

Switch chart types to fit your data using the design tab and change chart type. Select the new type and layout, adjust the combo group, and modify the secondary axis.

Format chart elements in Excel using the design tab, quick layout, and chart styles. Change colors, edit the chart title, adjust plot areas with shape fill and effects.

Discover how to add a trendline to a data over time chart in Excel, choose from linear, logarithmic, polynomial, power, or moving average, and customize the period and name.

Insert and customize sparklines in Excel to fit miniature charts into a single cell. Emphasize points with markers, adjust line weight, and clear sparklines using quick analysis tools.

Freeze panes to keep headers visible while scrolling, using the view tab to lock the top row or columns, and use split to create independent panes for comparison.

Learn to use the outline feature in Excel 2013 to view large data by collapsing and expanding rows and columns, using the data tab, show detail, and clear outline.

Link data across worksheets and workbooks with a dynamic formula that updates when the source changes, and learn to switch between workbooks while tracking workbook, sheet, and cell references.

Learn to manage external references in Excel by using the Edit Links tool, updating data from source workbooks, and breaking links to remove external references.

Explore the Excel IF function, its syntax with logical tests and optional arguments, and how to return values when conditions are true or false using common operators.

Explore how the VLOOKUP function retrieves data from the leftmost column of a table, returning values from the specified column, with exact or approximate match options.