Microsoft Excel Masterclass 2026 — From Beginner to Pro

Explore Excel's font tools in the home tab to change the font family for selected content, using the font section to apply typography options.

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 selecting rows or columns in Excel and applying text formatting by changing font family and adjusting font size with direct input or increment and decrement buttons.

Format text in Excel by applying bold, italic, and underline to cell content, demonstrating how text styling appears and functions within a worksheet.

Apply border settings to selected cells, adding thick outside borders or left and bottom borders, then use draw border and erase border to customize borders, color, and style.

Learn to apply cell background colors and set font colors in Microsoft Excel using the fill color and font color options.

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.

Master horizontal and vertical alignment in Excel by centering, left, right, or top, middle, bottom alignment, and adjust text direction and angles for a single cell or the whole project.

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

Format a selected range as a table, choose presets, and apply table design styles while deciding if the table has headers, then see the style mix with existing formatting.

Format cells in Excel by selecting, then adjust row height and column width, and apply vertical alignment options such as middle alignment for improved readability.

Learn how to delete rows, columns, cells, and entire sheets in Excel, and understand why you can't delete the only sheet without adding another.

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

Master the Excel clipboard by cutting, copying, and pasting cells with various paste options, formulas, and formatting, including keep source formatting, column widths, and values.

Learn to use Format Painter in Excel to copy a cell's formatting by selecting the source, choosing Format Painter, and applying it to the destination.

Insert pictures in Excel by placing them in a cell or over cells from device, stock, or online pictures; use picture format options like remove background, brightness, color, and transparency.

Master drawing shapes in Microsoft Excel using the insert tab. Customize with shape styles, fills, outlines, and effects, and rotate or move shapes freely; add text with edit text.

Learn to insert icons from Excel's stock images, import a chosen icon into your project, and use them to enhance visual appeal and professionalism.

Insert 3D models from the office family, choose between the available models, and use the 3D model tab and 3D rotations to customize the model to fit your project.

Insert smart art from the insert tab, choose a preset, click ok, then use design and formatting tabs to adjust color and text, or convert to another diagram.

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.

Open a data table with regions, products, months, and sales, then use insert and the recommended charts feature to create a chart in a new spreadsheet.

Create charts in Excel by selecting chart types, add them to your project, and customize titles, styles, colors, and formats using the chart design and format tabs for sales reports.

Explore how to print a full data table and chart, configure print settings, and use the page layout tab to set up printing.

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.

Use page layout view to preview margins and white space, adjust margins to fit content within the paper borders, and place charts so they print on a single page.

Switch page orientation between landscape and portrait in your Excel project. Troubleshoot why the orientation isn't being applied.

Choose the right page size for printing by understanding options like A4, A3, and A5, along with other international sizes.

Insert a picture from your computer to use as the page background, and apply it to your project and its pages.

Open the file menu, select print, and print the data you have selected from your spreadsheet.

Explore pivot tables in Excel to view data from multiple angles and draw conclusions from the data.

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 the core functions and formulas inside Microsoft Excel, building a practical understanding of how to use formulas in spreadsheets.

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.

Master how to link cells across sheets in Excel, using functions and formulas to create relationships, copy a cell with the equals sign, and auto-update when the source changes.

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.

Learn how to perform subtraction in Excel by using simple formulas like =G2-F2 to find the difference between actual and target sales, illustrating negative and positive results.

Multiply a percentage by sales to calculate bonuses in Excel, taking 10% of 8500 to get 850. Learn basic multiplication formulas and functions to automate this calculation on sales data.

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.

Learn how the sum function in Excel totals selected cells using the equals sign, the function name, and parentheses, with an example summing cells g2 to g6.

Explore how the min function identifies the lowest value across selected cells, such as G2 through G6, with a result like 8500 for John.

Explore how the max function in Excel returns the highest value from a selected data set, as shown by the example 13,000 for Sarah.

Explore the count function, which tallies numeric cells within a selected range, ignoring empty cells, text, and non-numeric content, as shown in examples like G7 and A1:G6.

Learn how counta includes text values in its tally, not just numbers. See an example from A1 to G6 where counta returns 42, while count counts only numeric data.

Explore the average function in Excel and learn how it computes the mean of a range of numbers. See a practical example that confirms the result.

Explore median, a statistical concept that identifies the middle value by sorting data from highest to lowest, and see how the median function returns the center value in Excel.

Master the concat function to join two strings in Excel, using cell references to combine a name and department and display the result in a single cell.

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 how countif analyzes a range to count how many cells meet a given criterion, with practical examples counting values equal to 9500, 1, 2, and 3.

Explore how vlookup retrieves values by specifying the lookup value, table array, and column index, and compare exact versus approximate matches, including case sensitivity and common errors.

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.