Learn Excel Step by Step: Beginner to Confident User

Master the building blocks of Excel—cells, rows, and columns—and practice navigating with cell addresses like a1, c4 to build confidence in the grid.

Learn to click, select, and move around the Excel grid with mouse and keyboard, master selecting ranges, rows, and columns, and practice navigation and basic formatting.

Enter your first data into Excel by creating a blank workbook, saving it, and typing text, numbers, dates, and prices in cells, laying the foundation for later formulas and charts.

Master how Enter and Tab navigate data in Excel: use Tab to move horizontally across cells and Enter to move downward, with Excel remembering the starting column of each row.

Save your Excel work by using save and saveAs, naming files, and choosing a location such as the desktop to keep work safe, organized, and easy to find.

Edit and delete data in Excel with confidence by mastering single-cell edits, in-cell changes, and formula-bar edits, plus safe clearing or deleting of cells, rows, or columns.

Discover how Undo and Redo provide a safety net in Excel, reducing fear and empowering you to try, edit, and recover actions with Ctrl-Z and Ctrl-Y.

Learn to zoom in and out and use view controls to tailor your Excel sheet for comfort. Explore normal, page layout, and page break preview views with zoom to selection.

Learn how to navigate and scroll Excel worksheets, move between cells with arrow keys, page up/down, and home and end, and use the horizontal scrollbar for large data sets.

Learn how to safely close and reopen an Excel file, save changes, use recent and browse options, and troubleshoot common closing issues.

Gain confidence in Excel by learning step by step, celebrating tiny wins, and maintaining consistency; you already have a foundation, and with steady practice you will master Excel.

Learn to select rows, columns, and ranges in Excel, practicing step-by-step moves to copy, format, delete, sort, and filter data.

Learn how bold, italic, and underline formatting in Excel improve readability, with practical steps using the Home tab font tools and shortcuts to emphasize headings, notes, and totals.

Learn to format spreadsheets with font size and font color to improve readability and emphasis. Use sizes for titles and headings, and color coding—green for completed and red for pending—purposefully.

Learn how to use cell background color, or fill color, to highlight data and create readable, organized tables. Apply soft, professional color coding to guide attention and categorize information.

Master how borders—lines around cells—structure tables, separate sections, and improve readability in Excel, then apply bottom, top, left, right, and outside borders for clean, print-ready spreadsheets.

Master left, center, and right alignment to place text inside cells, making your spreadsheet readable and balanced while consistently separating text, numbers, titles, and category labels.

Format in Excel with wrap text and merge cells to keep data readable and professional; use merge & center, merge across, merge cells, and unmerge.

Learn to adjust column widths and row heights in Excel to keep text visible and avoid overlap. Use drag to resize, auto-fit, and set exact widths for clean, professional tables.

Master excel number formatting by applying text, number, and currency formats to control data display. Learn to adjust decimal places and currency symbols in cells.

Format your Excel data with professional formatting to create neat, readable tables. Learn alignment, borders, currency formatting, header styling, and printing-ready layouts to build confidence.

Learn how Excel distinguishes text from numbers, treating text as labels and numbers as values, and master data entry and formatting to support formulas and calculations.

Learn how to use Excel's autofill feature to continue patterns by dragging the autofill handle, quickly generating days, months, numbers, and text with accuracy.

Master copying, cutting, and pasting in Excel using CTRL-C, CTRL-X, CTRL-V or right-click options to duplicate, move, and organize data while preserving originals until pasted.

Master inserting rows and columns in excel to create space and adjust layout, including inserting above the selected row and to the left of the chosen column.

Delete rows and columns in Excel, understand delete vs. clear, see how data shifts, learn multi-row and multi-column deletions, and use Ctrl+Z for undo during hands-on practice.

Learn how to move data in Excel using cut and paste or drag and drop, moving single cells, rows, columns, and entire tables to reorganize and clean your sheets.

learn to sort data in excel using a to z and z to a, apply ascending and descending orders, and organize names, numbers, and salaries efficiently.

Learn how to sort numbers and dates in Excel, including smallest to largest and oldest to newest, and troubleshoot common issues like text dates and locale settings.

Learn to use excel filters to show only the rows you need and hide the rest without deleting data, applying text, number, and date filters with practical examples.

Create a simple contact list in Excel, with headers for full name, phone numbers, email, city, and job titles, and practice formatting, sorting, and filtering.

Learn how to create formulas in Excel, starting with the equal sign and using cell references to perform and update calculations automatically.

Type the equals sign to start an Excel formula and let Excel calculate results in cells and the formula bar. Practice addition, subtraction, multiplication, and division.

Learn to use the sum function in Excel to automatically add numbers, build formulas with the equal sign, and employ auto-sum for quick totals across ranges like A1 to A5.

Learn to use the average function in Excel to find the middle value of numbers, with the equal sign, cell ranges, and examples like salaries, scores, ages, and expenses.

Learn how to use Excel's min and max to identify the smallest and largest numbers in a data range, with examples using salaries, scores, temperatures, and dates.

Discover how COUNT counts only numbers and COUNTA counts anything non-empty in Excel, with hands-on data examples like names, salaries, and empty cells.

Learn to autofill with formulas, drag the fill handle to copy patterns, and calculate totals using sum and average functions.

Edit formulas confidently in Excel by learning three quick methods: in Excel, in the formula bar, or by double-clicking; avoid deleting the equals sign and observe how changes update results.

Learn to avoid Excel formula mistakes. Master issues like missing equal signs, extra spaces, wrong cell references, wrong sum range, and text in formulas, plus decimal separators and regional settings.

Learn to use essential Excel formulas such as sum, average, min, max, count, and counta to perform quick, accurate math on budgets, salaries, and attendance.

Learn the power of functions in Excel and why they exist. Use sum, average, min, max, and count to save time on real data.

Explore Excel's if function, which makes decisions by testing a condition and returning a value if true or false; learn its structure and practical examples with score tables and autofill.

Use the if function with text in excel, applying quotation marks to label data like full time, part time, approved, not approved, and local or foreign.

Master COUNTIF to count cells that meet a condition, using range and criteria to answer questions like how many hr entries or values above 100.

Learn the sumif function to add numbers only when conditions are met, using range, criteria, and sum range to answer questions like total apple sales.

Learn how to use the SUMIF function in Excel by identifying required range and criteria, and when to include an optional sum range. Compare same versus different ranges with examples.

Master date and today functions in Excel to track deadlines, schedules, and birthdays. Explore date structure (year, month, day), dates as numbers, and simple arithmetic for project planning.

Master the CONCAT function in Excel to join text from multiple cells, add spaces or punctuation, and build full names, sentences, and product descriptions.

Discover how the rank function finds a number's position within a range, with descending and ascending order, plus absolute versus relative references for practical student scores and sales examples.

Learn how relative references adapt when copied and how absolute references lock cells with dollar signs, using F4, with examples like A1, B1, tax rates, and discounts.

Build a student grades sheet in Excel to analyze data, calculate totals and averages, apply if formulas for pass or fail, and use countif, sumif, averageif, rank, and a dashboard.

Turn any data range into an Excel table to gain automatic filtering, formatting, and smart formulas that auto-copy down, while learning keyboard shortcuts like Ctrl+T and practical table styling.

Turn your boring data into a table to make Excel faster and smarter, with automatic formatting, filtering, sorting, built-in formulas, and dynamic expansion.

Learn how to apply Excel table styles to make your data clean and professional by choosing ready-made designs that control header colors, shading, borders, and fonts.

Learn how to use filtering in Excel tables to hide irrelevant rows, display specific departments, statuses, or salary ranges, and clear filters with ease.

Sort data inside an Excel table with one click, using A to Z or smallest to largest, and keep each row together for safe, organized data.

Discover calculated columns in Excel tables, write a single formula in one row, and let Excel automatically fill the entire column for salaries, totals, scores, and commissions.

Create an inventory table in Excel, convert data to a table with headers, apply table styles, add a calculated total value column, and use sort and filter to manage items.

Explore how charts visualize data in Excel, turning numbers into pictures with bars, lines, pies, and columns. Learn to select data, insert charts, and compare trends for clear reports.

Learn how to create and customize a clustered column chart in Excel, using tables, the insert tab, data labels, and chart titles to compare values clearly.

Explore how to use bar charts in Excel to compare categories with horizontal bars, create a clustered bar chart from tables, and add data labels for clear comparisons.

Learn how to create a line chart in Excel to show change over time. Connect data points, distinguish timelines and values, and title the chart for clear trend communication.

Master pie charts in Excel by selecting a category and numeric data, inserting a 2D pie chart, and configuring outside data labels to show percentages for three to six categories.

Format Excel charts to look clean and professional by adjusting colors, fonts, labels, and chart elements. Convert data to tables, then add data labels and a title to boost readability.

Add chart titles and axis labels in Excel to make your charts tell a clear story, with concise titles, properly labeled axes, bold font, and dollar-sign formatting.

Learn to change colors and styles in an Excel chart to improve readability, highlight key months, and format individual data points in a clustered column chart.

Choose the right chart in Excel for different data, using column or bar charts to compare values, line charts for trends, and pie charts for parts of a whole.

Learn to turn raw numbers into clean, professional sales charts in Excel by building a clustered column chart with data labels and axis titles, formatting currency for monthly sales.

Discover how pivot tables in Excel summarize large data sets with drag-and-drop simplicity, showing totals by product, month, region, or employee using rows, columns, values, and filters.

learn how to create pivot tables in excel to summarize data quickly without formulas, using a beginner-friendly, step-by-step approach that drags fields to rows, columns, filters, and values.

Master pivot tables by understanding rows, columns, and values—the core areas that list items, group data across the top, and calculate totals, enabling dashboards and professional reports.

Learn how filters in pivot tables show only the data you need, with arrows to pick regions and value filters like greater than for cleaner dashboard views.

Learn to summarize data instantly with pivot tables in Excel by dragging fields to rows and values for totals, averages, and counts, without altering the original data.

Learn how pivot charts visualize pivot tables in Excel, create and customize charts with types like column, bar, line, and pie, and keep charts synced with pivot tables.

Format pivot tables to look professional by applying styles, banded rows and columns, number formats, and layout options such as tabular form, while managing grand totals.

Learn how to refresh pivot tables in Excel to reflect data changes, using one-click refresh, refresh all, and table conversion to auto-expand data ranges for accurate reporting.

Master common pivot table mistakes: convert data to a proper table, refresh after changes, fix text vs numbers, and set correct value field settings.

Master pivot tables from scratch to analyze data professionally, arrange rows and columns, add filters, and refresh dashboards, turning you from beginner to confident Excel user.

Remove duplicates in Excel to clean data quickly using the data tab’s remove duplicates tool, selecting relevant columns and headers, with backup copies to prevent data loss.

Learn to use Excel's find and replace to quickly locate and replace data across a sheet, using Ctrl-F, Ctrl-H, and Home tab options for efficient, error-free data cleaning.

Split messy data into clean columns with text to column, a delimited tool that uses comma, space, dash, or tab as separators in Excel.

Master flash fill in Excel, a pattern recognizing tool that completes data like names and phone numbers without formulas; activate via ctrl-e, data tab, or auto-detect in beginner lesson.

Learn to use freeze panes in Excel to keep headers and first columns visible while scrolling, using top row, first column, or both from the view tab.

Master Excel keyboard shortcuts to work faster and with fewer mistakes. Practice common shortcuts like ctrl-c, ctrl-v, ctrl-x, ctrl-z, ctrl-y, ctrl-s, ctrl-a, and navigation keys such as ctrl-home and ctrl-end.

Adjust page layout and printing settings in Excel to ensure clean, one-page prints. Learn to use orientation, margins, scale to fit, print area, header and footer, and print preview.

Clean a messy list in Excel by removing duplicates, correcting formats, and using text to columns and Flash Fill. Learn why clean data yields accurate results in reports and analyses.