Microsoft Excel for Beginners to Advanced

Open a new Microsoft Excel worksheet and customize your viewing background by changing the Office theme to dark gray in Excel options.

Explore the Excel user interface and the spreadsheet area, learn how to interact with cells, zoom in and out, and copy and paste sheets.

Explore the Excel user interface by examining the ribbons area, identify the home ribbon and its sections, and learn how to save and search within a workbook.

Learn to enter text and numbers in an Excel spreadsheet using a fruit shop example to track monthly sales of apples and bananas.

Learn to select cells in Excel by clicking, quickly reach the end of a range with Ctrl and arrow keys, and choose multiple cells with Shift and arrow shortcuts.

Master insert and delete operations in Excel by using the Home ribbon's Cells insert and delete buttons, or right-click menus to add or remove rows and columns.

Learn how to format cells in Excel, adjusting font, alignment, and number formatting in a new worksheet, using the home ribbon tools and the format painter.

Learn to format cells in Excel with font styles, fill colors, borders, and the format painter to quickly apply consistent formatting from headers to data.

Explore alignment formatting in Excel, learning how to align text left, center, or right, adjust indent, rotate orientation, wrap text, and use merge and center for headers.

Apply number formatting in Excel by using the Home ribbon options to format numbers as currency or percentage, adjust decimals, and convert to different currencies.

Learn how to hide and unhide sheets, color tabs, and rename tabs in Excel using right-click or the home ribbon, with practical tips.

Learn to edit cell content in Excel by entering edit mode with F2, double-clicking, or the formula bar, then use find and replace to abbreviate a name quickly.

Position multiple contents within a single cell in Excel by using the Alt+Enter technique, enabling bananas, mangoes, and oranges to appear under apples.

Learn to enter and change repeated cell content quickly in Excel using the control and enter technique and find and replace (Ctrl+H) to update values.

Master copy and paste and cut and paste in Excel using ribbon buttons and keyboard shortcuts (Ctrl+C, Ctrl+V, Ctrl+X), with cell selection and clipboard feedback.

Learn five autofill methods in Excel, including copy cells, full series, full formatting, fill without formatting, and flash fill formatting, using the bottom-right corner to drag down.

Sort cell content in Excel by ascending, descending, and alphabetical order, with options to expand selection so related data moves together, using the data ribbon or right-click.

Learn to apply and remove filters on cell content in Excel using the filter button or Ctrl+Shift+L, to view specific months like April and August and hide nonmatching rows.

Insert pictures from device, stock images, or online pictures, plus shapes and icons, into a spreadsheet, then resize with handles, rotate, and apply borders, fills, and glow with the ribbons.

Insert a text box or word art in an Excel worksheet, then resize and rotate it. Apply color and outline, and use font and alignment options to center the text.

Learn to use the review ribbon in Microsoft Excel to perform spell check and proofing, and access the thesaurus, correct misspellings, and replace words with suggested alternatives.

Learn how to use Excel's review ribbon to add comments and notes on cells, edit or delete them, and distinguish conversation-friendly comments from simple notes.

Learn to protect the sheet and workbook, lock and unlock specific cells, set and confirm passwords, and verify protection from the review ribbon in Excel.

Explore the view ribbon to switch between normal view, page break preview, page layout, and custom views. Save display and print settings, and add headers and footers for printing.

Learn to use the view ribbon in Excel to freeze panes and keep headers visible, open a new window, and arrange windows in tiled, vertical, horizontal, or cascade layouts.

Learn basic calculations in Excel, including addition, subtraction, division, and multiplication, using the calculation syntax, equals sign, and the formula bar, with the function library.

Explore how to use the min and max formulas in Excel to find the minimum and maximum values in a range of cells, demonstrated with fruit data.

Master sum and average formulas in Excel to compute totals and means from selected cell ranges, using AutoSum and manual entry, with quick verification and basic counts.

Explore product, quotient, and power formulas in Excel to automate calculations and apply these functions to ranges and cells for faster, accurate results.

Explore how to use the count, count a, and count blank formulas in Excel, including counting non-empty cells and blanks within a selected range, with practical examples.

Learn to use the index formula to fetch values from a data array via row and column numbers, and make it dynamic with drop-down data validation.

Discover how the match formula returns the position of a selected item within a list, using a dropdown and an exact match to identify items like tablet, speaker, and laptop.

Learn to use vlookup and hlookup formulas for vertical and horizontal lookups, handling four arguments, exact match, and dynamic column indexing.

Learn to use the left and right formulas in Excel to extract characters from the start or end of text strings, with examples using Jan, zero one, and zero two.

Master the if formula in Excel by building a logical test to return pass or fail based on scores, and apply conditional actions like rewriting for failures.

Explore how the and formula in Excel checks that all conditions are true and integrates with if to assign grades A, B, or C from marks out of 100.

Learn how the or formula in Excel checks any condition and returns true, otherwise false, with a pass example showing true outcomes when any cell says pass.

Learn how to use Excel's round, round up, and round down formulas to round numbers to specific digits, with practical examples on student scores.

Master the square root formula in Excel using the sqrt function to return a number's square root, shown with sample scores and dragging down to fill results.

Learn to use the subtotal formula in Excel to sum values for filtered data in a list. Filter by names and see subtotal return the sum for the visible records.

Master the transpose formula to convert vertical data to horizontal ranges in Excel, entering as an array with Ctrl+Shift+Enter and pasting as values to preserve results.

Master common Excel formula errors by identifying name errors from typos, value errors from invalid inputs, and division errors from dividing by zero.

Master minifs and maxifs in Excel to find the youngest and oldest workers by gender and working or studying occupation, using age, gender, and occupation criteria.

Learn to use sumif and sumifs to add values by single or multiple criteria, such as summing ages for females or female workers by gender and occupation.

Learn to use the averageif and averageifs formulas in Excel to average ages by gender and occupation, with ranges, criteria, and result verification.

Explore the Excel aggregate formula to compute averages and sums across a range, while ignoring errors. Learn to apply the ignore error option and handle zero values.

Use the choose formula in Excel to map an index number to a value, such as car codes to colors (1 blue, 2 silver, 3 red).

Learn how to combine text in Excel using the ampersand operator and the concat function, including adding spaces between names like Peter Parker, Bruce Banner, and Tony Stark.

Learn how to use the iferror formula in Excel to handle division by zero, returning a blank when errors occur and keeping averages accurate across blank cells.

Learn how the indirect function returns the reference specified by a text string. Build dynamic sheet references with concatenation to pull Apple or Banana from selected sheets A1.

learn how to audit formulas in Excel by tracing precedents and dependents, showing formulas, evaluating formulas step by step, and checking for errors to ensure correct results.

Learn how conditional formatting customizes Excel cells based on conditions. Navigate the home ribbon and conditional formatting dropdown to explore highlight cells rules, data bars, color scales, and icon sets.

Learn to use highlight cells rules in conditional formatting to format numbers greater than a threshold, using randbetween to generate values and applying color formats.

Learn top bottom rules in conditional formatting for Excel, exploring the top ten and bottom ten items, adjusting to five, and applying formatted highlights in a worksheet.

Explore conditional formatting in Excel with data bars and color scales. Illustrate how data bars visualize small to large values and how red-yellow-green scales create a heat map.

Learn to apply icon sets in Excel conditional formatting, using green ticks, yellow exclamations, and red crosses with 67% and 33% thresholds for values 1–20.

Learn to create conditional formatting rules in Excel, including a two color scale based on min and max values, and rules that format only cells that contain between two numbers.

Explore what charts are as visual representations of data that convey information and insights. Navigate the insert ribbon and charts area in Excel to start creating charts.

Learn to create bar and column charts in Excel, define x and y axes, customize titles, labels, and data series for clear visual comparisons across weeks.

Learn how to create a line chart in Excel, define x and y axes for weeks and oranges sold, add axis titles, apply data labels, and customize markers and colors.

Master combo charts in Excel by combining a clustered column for weekly actuals with a line target, using weeks 1–10 and a 200 bananas target.

Create and customize pie and donut charts in Excel, adding data labels, adjusting legends and titles, and resizing the donut hole for clearer insights.