Microsoft Excel Masterclass 2026 — From Beginner to Pro

Master how to select cells in Excel to apply formatting and edits efficiently, using cell-based selection instead of text selection found in Word or PowerPoint.

Explore alignment tools in Excel by examining how cell alignments relate to their positions in the worksheet, and learn how to apply alignment settings to improve readability.

Explore the styles section, select parts of a table, and apply heading styles using presets to customize formatting.

Learn how to insert cells, rows, and columns, and delete rows or columns using the Home tab in Microsoft Excel.

Learn to capture screenshots from the insert tab by clipping a screen region and inserting it into your project, using the same picture formatting settings as ordinary images in Excel.

Use page layout to set different themes and preset phones and colors. Changing a theme updates colors, phones, sizes, and families, and applying an effect affects the entire project.

Explore building pivot tables in Excel for data analysis, using recommended pivot tables, managing row labels, dates, customers, product categories, and revenue with filters, columns, and values.

Discover how Excel addresses cells and ranges using column letters and row numbers, such as h3 and h13, and learn to specify ranges like h6 to h13 before using functions.

Learn to add salaries in Excel by using equals and plus to combine John's and David's salaries from specific cells, and extend this to total the month's salary.

Explore how to perform division in Microsoft Excel using the slash operator, demonstrated with a simple 12 by 3 example that yields 4.

Build and merge advanced Excel formulas using cell references and parentheses to calculate take-home pay by combining salary with sales-based bonuses and a percentage bonus.

Explore how Excel functions differ from formulas, and learn to select cells, clear them with delete, and begin using the functions feature.

Master the if function in excel by testing logical conditions and returning a value if true or false, using examples like g2 versus f2 with quoted results.

Explore Excel functions with sum if by calculating Diana's total revenue across purchases, using a range, criteria, and sum range, and review pivot table context.

Explore the now function in Excel, which uses empty parentheses and requires no value inside it. Pressing enter displays the current date and time.