Microsoft Excel Basic to Advanced: A Complete Learning Path

Create and open new workbooks in Excel, using blank or prepared templates like personal monthly budget, and save or access them via OneDrive with browse and sign-in options.

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 how to use the and and or functions in Excel to test multiple conditions, build logical tests, and return true or false for sorting and calculations.

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.

Create valid dates in Excel with the date(year, month, day) function, understanding its syntax and how it returns a serial date from year, month, and day components.

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.

Learn to use the count function in Excel, including Count, CountIf, and CountBlank, with range basics, criteria, and practical data examples.

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.

Learn how the average function computes the mean by summing numbers and dividing by count, forming the central value. Explore averagea, average if, and if to handle criteria.

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.

Master the power function in Excel to raise a number to an exponent using the formula tab, with examples like five raised to six, square, and cube.

Learn how to use the mod function in Excel to compute remainders after division by a divisor, with practical examples and formula bar usage.

Explore how the int and trunc functions in Excel remove decimals and control digits, including negative numbers. Compare int's rounding with trunc's non-rounding truncation, with digits and date examples.

Explore how max and min identify the largest and smallest values in a range of cells in Excel. Compare with maxa and mina for booleans and different data types.

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 mid function in Excel to extract a specific number of characters from a text string by setting the start position and length, with examples.

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 split text in Excel using the text to column tool, choosing delimited or fixed width methods to separate data into columns by commas, spaces, or delimiters.

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 how to use and customize grid lines in Excel, including view and print options, and adjust line style to improve data readability.

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.

Explore how the exact function compares two text strings for an exact, case-sensitive match, returning true or false, and apply it to text, numbers, and dates.

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.

Learn how to use the vlookup function in excel to search the leftmost column and return a value from a specified column, with exact or approximate matches.

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.

Master exact match and approximate match in Excel using Vlookup, understanding when to require exact values and when to accept nearest ones in large datasets.

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 use the detect language formula in Google Sheets to automatically identify languages in data, test with examples in Spanish, Italian, and Japanese, and apply to your worksheet.

Learn to convert numbers to words in Excel using a VBA module by inserting code in Visual Basic editor and applying number2words to currency formats like dollar, peso, and rupee.

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.

Explore how charts and graphs in Excel visualize data, using recommended charts, a clustered bar chart, and various styles to reveal trends, comparisons, and outliers.

Master pivot tables in Excel to analyze a large data set quickly, create pivot tables from a table or range, and customize fields for sales, orders, and inventory insights.

Learn to use Excel sort function to order data by ascending or descending by column, using array and index arguments, with sort order parameter (1 for ascending, -1 for descending).

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 merge and separate data in Excel using flash fill and formulas to combine first and last names and split one column into multiple fields.

Learn how to freeze panes in Excel to keep the top row and first column visible while scrolling, using the view tab options to tailor your worksheet.

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 rename and color worksheets in Excel using simple right-click steps and tab color options to organize data efficiently.

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.

Group multiple worksheets in a workbook by ctrl-clicking the sheets to form a group. Make edits across the grouped tabs to apply changes to all sheets.

Learn how to protect and unprotect a worksheet in Excel using right-click, the review tab, or the home format options, with password 1234, to prevent edits.

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.

Keep the first row and first column visible while scrolling by using the split worksheet feature, so headers stay in view across long data 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.

Add and customize headers and footers in Excel via the insert tab, configure top and bottom sections, and insert page numbers, date, or file path that repeat on every page.

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.