Microsoft Excel Basic to Advanced: A Complete Learning Path

Explore the tabs and ribbon in Excel, customize the ribbon and create a new tab with groups for clipboard, formula, and tables, and add commands for quick access.

Identify and fix common Excel errors, including invalid arguments, division by zero, and name or reference errors, plus not available values. Learn practical fixes: correct data types and separators.

Explore the not function in Excel to reverse a logical value, turning true into false and false into true, with syntax and practical examples using score data.

Master the xor function in Excel, implementing exclusive or to return true for exactly one true argument and false when both arguments are the same.

Learn how to use the switch function to simplify complex nested if statements by evaluating a single expression and returning a matching result, with student and project ids as examples.

Master the cell function in Excel to retrieve a cell's formatting, location, and content using info type and a reference, including addresses, column and row, color, and format.

Explore how to use the if function in Excel to evaluate logical tests, assign fast, normal, and slow categories based on speed thresholds, and compare it with the IFS approach.

Explore how to build nested if functions in Excel to categorize values into low, medium, high, or unknown, using logical tests and multiple if statements.

Master the if function in Excel to calculate letter grades from a grading scale, creating a grid and applying logical tests to output A, B, C, and F.

Use the Excel if function to calculate letter grades from student scores, applying nested tests for A, B, C, D, and F with 90, 80, 70, and 60 cutoffs.

Learn to use the filter function in Excel to filter data in a worksheet, enable filtering from the data tab, and display item-specific results such as item A or B.

Learn how to use the end-of-month (eomonth) function in Excel to compute the last day of a month from a start date, including adding or subtracting months for due dates.

Learn how to use Excel date functions to extract year, month, and day from start and end dates, and apply the edate function.

Master the eomonth function to add months to a start date in excel, generating an output date and showing how changing month values updates results.

Convert text dates to serial numbers with the date value function to enable date calculations and analysis in Excel, including finding days between dates and formatting dates.

Use today to display current date and now to display current date and time; both are volatile functions with no arguments, recalculate on open, and formatting can show only time.

Convert time values to hours, minutes, and seconds in Excel using time 24 and formulas to display and drag down results.

Master the round function in Excel, including round up, round down, and MROUND, with examples of rounding numbers to specific digits and to nearest ten, hundred, and thousand.

Master the sum function in Excel, including sum, sumif, sumifs, sumproduct, and sumsquare, with range selection, criteria, and auto sum tips for data analysis.

Explore how the subtotal function in Excel computes sum, average, count, max, and min, and compare it with sum under filters using practical data examples.

Learn how to use Excel's find and replace features to locate and refresh data with ctrl f and ctrl h. See practical examples for names, emails, and symbols.

Master Excel's length function (LEN) to determine the number of characters in a text string, including spaces, with practical examples and step-by-step use of formulas.

Master the repeat function in Excel to repeat text and drive charts and analysis. Use conditional formatting with formulas, custom symbols, and rounding to visualize scores and trends.

Learn how to use the text function in Excel to convert numbers and dates to text, apply custom formats, and display full day names and month names.

Learn to use the trim function in Excel to remove excess spaces from a text string, including leading and trailing spaces and line breaks, by referencing the cell. See results.

Learn to use the index function to retrieve values from a range by row and column, leveraging array and reference arguments for precise lookups.

discover how the match function in Excel finds the position of a value in a range, supports exact and approximate matches, and streamlines large data analysis.

Master Vlookup for exact and approximate matches in Excel, using range_lookup with 0 or 1, and learn to apply commissions examples with absolute references and the if function.

Explore how the Xlookup and lookup functions retrieve data from a horizontal table using lookup value, table array, row index, and range lookup in Excel.

Explore the Xlookup function in Excel, a powerful tool that searches in any direction and returns data from any column in this course.

Learn to create clickable hyperlinks in Excel using the hyperlink function, linking text to places in the document, within the workbook, external documents, emails, or web pages with friendly name.

Learn how to import data from the web into Excel using Get and Transform data, paste a URL, and load web tables such as countries by vehicles per capita.

Learn to build a dynamic drop-down list in Excel that automatically updates from another cell using a named range and data validation, easing data entry.

Learn to build a dependent drop-down list in Excel using data validation and the indirect function. Create country and street lists that update the second dropdown based on first choice.

Apply the filter function in Excel to filter a data range by item name, using the data tab to show results for item A and item B.

Learn how to use split panes to keep the first row and the first column visible while you scroll, so headings stay in view, and how to remove the split.

Learn to add and delete worksheets in a workbook using the insert sheet option, the home tab commands, and right-click or keyboard shortcuts.

Learn to quickly hide and unhide worksheets in Excel using right-click commands and the home tab's format visibility options, helping you manage your workbook layout efficiently.

Learn how to move or copy worksheets in a workbook using right-click, the move or copy option, and the create a copy feature to relocate or duplicate sheets across workbooks.

Learn to protect an Excel workbook to prevent structural changes, with steps from the review tab, set a password, and restrict inserting, deleting, renaming, or moving sheets.

Learn to share an Excel workbook with multiple users using Google Sheets, assign editors or viewers, and collaborate in real time while removing sensitive data and organizing a clear structure.

Explore page settings in Excel to adjust margins, page layout, portrait or landscape, paper size, and page breaks for polished printouts and client-ready worksheets.

Explore how to use the page break preview in Excel to control print layout, view page breaks, and customize the printable area for accurate multi page printing.

Learn to print efficiently by using print selection or print active sheet, print the entire workbook, and select the printer, copies, and adjust orientation, margins, scaling, and fit options.

Learn how to set and manage the print area in Excel, use print preview, add to print area, print specific selections, and clear the print area for efficient printing.