Beginner to Pro - Excel Tutorial

Explore the Excel home screen, starting a blank workbook, browsing templates and tutorials, using the more templates button, and managing recent workbooks with the open tab and search bar.

Explore the Excel interface by opening a blank workbook, navigating the quick access toolbar with autosave, the home ribbon, and the formula bar and name box for precise cell work.

Customize the quick access toolbar in Excel. Add items like sort ascending and quick print, and use right-click or the ribbon for faster access.

Explore the status bar at the bottom with page break, page layout, and page preview, then examine the blank workbook sheet and the view tab for overall work context.

Explore Excel worksheets and workbooks, learn how to add, rename, delete, and navigate sheets, use the name box to identify the active cell, and note performance with many sheets.

Learn to save an Excel workbook with the file menu or quick access toolbar, name the file, choose a location, and select a file type such as xlsx.

Open a saved Excel workbook by using the file button, open tab, and recent files, then browse folders, cloud locations, or search to locate and open your document.

Learn to use common Excel shortcuts to navigate, edit, and save workbooks with familiar control keys like ctrl+c, ctrl+v, and ctrl+x, reinforcing quick, efficient spreadsheet work.

Enter data into Excel spreadsheets by clicking cells and watching the green box and grid lines; quickly highlight ranges with drag, shift-click, or arrow-key navigation.

Enter text and numbers in an Excel budget workbook, format cells, use formulas to total costs like rent, inventory, marketing, utilities, and payroll, and create quarter budgets with monthly totals.

Enter numeric and currency values in Excel and learn to distinguish numbers from text by right- and left-aligning cells, while aligning decimals with the formula bar.

Learn how to enter dates in Excel, add the year, and see dates convert to numeric values; explore short, long, and custom formats like Jan-2020.

Master cell references in formulas by using the name box to locate B3, linking formulas to that cell, and selecting non-contiguous ranges with shift and ctrl.

Learn how to create basic Excel formulas using the equals sign, perform arithmetic with cell references, and keep totals automatically updating as data changes.

Demonstrates how relative references adjust when copying formulas across rows and columns, then shows absolute references using dollar signs to lock a cell for correct calculations.

Use the sum function to automatically add a range of cells in Excel, updating totals when values change. Type =sum(range) or press Alt + = to insert it.

Discover how to use Excel's min and max functions to find the smallest and largest values in a range, and enter the formulas to analyze totals and percentages.

Master Excel's average function to compute the average of a cell range, including non-contiguous selections, by entering =average and selecting the desired cells.

learn how to use the count function in Excel to tally how many cells are in a selected range, with dynamic updates when you add or remove data.

Learn to use basic Excel functions such as sum, max, average, and count, master relative and absolute references, and resolve adjacent cell errors by ignoring them to clean your data.

Learn how to use Excel's AutoSum function with the = shortcut, the formulas tab, and the insert function to quickly sum single or multiple ranges.

Learn to use Excel's AutoFill to populate formulas across rows and columns. Practice applying sum, average, max, and count with drag, shortcuts, and clear contents.

Move and reorganize data in Excel using cutting, copying, and pasting across sheets. Adjust formulas when transferring data between sheets and resolve division by zero errors.

Learn to insert and delete rows and columns in Excel, auto-update totals and formulas, and use quick shortcuts like right-click, Ctrl+Plus, Ctrl+D, and the Home tab.

adjust column width and row height by dragging borders and use double-click auto-fit to size columns to their longest entry, preventing data from being hidden or showing pound signs.

Learn how to hide and unhide columns and rows in Excel to control data visibility, keep formulas intact, and show only the relevant totals for sharing.

Learn to rename worksheets in Excel by right-clicking the sheet tab, typing a new name, and organizing pages like budget costs and copy and paste for quick, clear data.

Delete a sheet in a workbook; deletion is permanent, no undo. Save a copy first, then remove one or more sheets by right-clicking the bottom tab and confirming the warning.

Learn how to move and copy Excel sheets, add or delete sheets, rename copies, and preserve formulas to build year-based budgets.

Learn to apply Excel font formatting by adjusting font size, color, and cell backgrounds, deleting rows and columns, highlighting headers, and styling a business budget to stand out.

Learn to format in excel by changing background and font colors, align headers, and highlight totals with paint bucket colors to distinguish costs and sums.

Add borders to a table to clearly separate costs from totals, using top, thick bottom, and left borders to enhance readability and emphasis.

Highlight the cost, totals, and min/max/average cells and convert them to currency or accounting formats to display dollars with two decimals and clean thousand separators.

Turn decimals into percentages in Excel by applying a percentage format to a grand total based column, using absolute references, and adjust decimal precision for accurate rounding.

Master the format painter in Excel to copy exact cell formatting—from background color to borders and fonts—across multiple cells for consistent totals, min, max, and averages.

Create and apply cell styles to update headers, fonts, colors, and dates or number formats across a workbook, then save a custom header style that propagates changes.

Merge and center the title across six columns (A through F) to create a clean, centered budget header and improve table formatting and readability.

Explore how to use conditional formatting in Excel to highlight values over 500, or within a range like 200 to 900, and manage rules.

Insert images and shapes into an Excel spreadsheet from saved files, online pictures, or cloud accounts like OneDrive. Resize and place images to enhance data storytelling without clutter.

Insert shapes from the Excel insert tab, draw a square or arrow to highlight percentages or other data, and explore the shape format tab to adjust fill and outline.

Format shapes using the shape format tab to edit corners and outlines, adjust weight, and highlight percentages in budgets with colored arrows.

Discover how to use SmartArt in Excel to create dynamic visuals. Insert SmartArt, edit text, adjust colors and layouts, and use visuals to simplify complex processes for presentations.

Create a simple column chart in Excel to visualize monthly costs such as rent, utilities, payroll, and inventory, and see how charts update automatically with new data.

Explore chart design options in Excel by adjusting colors and styles, adding axis titles and data labels, toggling grid lines and legends, and applying a trend line to enhance readability.

Modify a chart by dragging its data source to include January and February, remove March, and remove rent as outliers, and watch the chart update automatically in real time.

Learn how to move an Excel chart to its own sheet using the chart design tab, name the new sheet, and view the chart larger for clearer analysis.

Create a pie chart by selecting data, swapping rows and columns, and focusing on one row or one column to compare costs like rent and utilities.

learn to use print preview in excel, adjust page orientation, margins, and output options, and choose between printing charts, tables, or whole pages, including front and back or one-sided.

Explore changing print properties and preview in Excel by switching between portrait and landscape, adjusting margins and paper size, and applying scaling to fit data on page or across pages.

Explore how page layout view helps you preview and control page breaks, fit tables and graphs to pages, and optimize print settings with landscape orientation.

Learn to add headers and footers in Excel, customize page numbers, and use sheet names and file paths in headers for printed outputs.

Select the cells to print, set the print area in the page layout tab, and preview to print only that table. Clear the area to print the full sheet again.

Discover how Excel templates work, open and use pre-existing templates, and create your own. Learn to plug in numbers, reuse budgets, and modify templates to keep formulas and charts intact.

Explore how to use existing Excel templates, from budgets to weekly chore schedules, and see how built-in formulas, charts, and alerts update your numbers in real time.

Learn to create a reusable Excel template from a budget sheet by removing hard coded data, preserving formulas, and saving as an xltx template for monthly or quarterly reuse.