Beginner to Pro - Excel Tutorial

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.

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.

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.

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 Excel's AutoFill to populate formulas across rows and columns. Practice applying sum, average, max, and count with drag, shortcuts, and clear contents.

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.

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.

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.

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.

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.

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.

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.