Microsoft Excel 2026: Beginner to Excel Pro in only 6 hours

Open your first workbook and save it using the save icon or the file tab, choose save as and the Excel workbook format, with a name and a desktop location.

Explore the workbook structure, including the ribbon, tabs and groups, the name box, the formula bar, and the file tab, to organize data across sheets.

Enter data in a worksheet, format cells as currency, date, or number, and edit, insert or delete rows and columns, while the formula bar shows the true content.

Learn how to use page layout, print options, and header and footer in Excel 2024, including setting paper size, print preview, borders, automatic page numbers, and exporting to pdf.

Explore a food sales dataset to practice Excel functions, create tables, and use formulas. Download a copy of the data to apply skills in upcoming lessons.

Learn to search and replace data in Excel using find and select, find all, and replace, to locate, navigate, and update cells across large datasets.

Post notes or comments to add information to a cell, clarifying data in shared sheets. Use notes for static information and comments to foster conversations and replies around a cell.

Create and edit hyperlinks in Excel to link cells to web pages, emails, or documents using the hyperlink dialog. Ensure the URL is complete and customize the text to display.

Master Microsoft Excel 2024 from beginner to pro in six hours, and understand that your opinion is important.

Explore Excel autofill and flash fill to automatically complete patterns, dates, and city and region in the same column by dragging, double-clicking, or pattern recognition for time-saving data entry.

Master how to manipulate columns and rows in Excel by cutting, inserting, and deleting cells, then hide and unhide columns to display essential data while preserving calculations.

Create a table in Excel to improve design and functionality, using headers, selecting a data range, and inserting a table from a blank sheet or existing data.

Modify a table’s layout and design in Excel using the table design tab: rename the table, toggle headers and total row, apply functions, and choose banded rows or banded columns.

Learn to sort and filter Excel tables to display and print only the data you need, using date filters, text filters, and multiple sort levels.

Master Microsoft Excel 2024 from beginner to pro in six hours. Build confidence with a structured path designed to accelerate proficiency in essential spreadsheet tasks.

Master basic calculation formulas in Excel, including sum, max, min, and average. Build and validate formulas using the formula bar, equal sign, and cell ranges to see automatic updates.

Lock the price per unit as an absolute reference when multiplying by the number of units, so dragging the formula yields correct total price across rows and columns.

Learn how the if function in Excel flags unit prices as above or below the average, using the syntax if(condition, true, false) and locking the average cell.

Explore how to use Excel text functions—len, right, left, mid, upper, and lower—to measure string length, extract characters, and convert case for practical data tasks.

Master concat and text join in Excel to merge text across ranges, compare their features, choose delimiters to improve readability, and handle empty cells when assembling row data.

Discover how to use the show formulas option in the formulas tab to reveal the raw data behind results in Excel, and how to undo to return to normal view.

Excel 2024 from beginner to pro in just six hours. The course title emphasizes a quick progression through Excel skills.

Learn to personalize Excel by customizing the ribbon and quick access toolbar, add a new group, and use multiple views, zoom, freeze panes, and split to analyze data efficiently.

Learn to view workbook properties in the info pane, manage protection and access, inspect document for issues, accessibility, version history, and hidden columns for secure sharing.

Explore txt and csv import formats in Excel, compare tab delimited and comma separated data, and learn loading options into tables or existing worksheets.

Master how to use the text to columns feature in Excel to split data into multiple columns, choosing between fixed width and delimited options, and removing delimiters like dollar signs.

Clean and prepare data in Excel by replacing inconsistent values with unknown, formatting decimals, and using text to columns to split by the dollar sign to convert costs to numbers.

Learn to find and remove duplicates in Excel 2024 using conditional formatting to highlight duplicates and the remove duplicates tool to delete duplicate rows.

Explore go-to and go-to-special features in Excel 2024 to quickly jump to cells, locate notes, find formulas, highlight blanks, and visualize data with formatting.

Learn to insert spark lines in a cell to visualize costs and insurance contributions, using negative values, paste special, and the if function, then format as dollars and assess trends.

Master Microsoft Excel 2024 from beginner to pro in just 6 hours with practical, hands-on lessons that cover essential skills and workflow efficiency.