Microsoft Excel - Excel from Beginner to Advanced level

Learn how to copy and paste Excel data, choose paste options (values, formulas, formatting, transpose), and use fill handles to auto fill sequences across cells and sheets.

Learn how to fill a series in Excel using options like fill formatting only, fill without formatting, and fill weekdays, with a clear example table.

Master advanced filling in Excel by using drag to copy or fill series, customize personal lists for days and months, and apply fill across directions.

Master flash fill in Excel using the Ctrl+E shortcut to extract digits, letters, and names from data, train Excel for accurate patterns, and apply capitalization and concatenation.

Learn how to hide and unhide columns and rows, freeze panes (top row, first column, or a selected corner to freeze both), and split panes to compare data.

Learn to customize worksheet views in Excel by creating named views to show or hide columns for different audiences, such as myself, my manager, and the client.

Insert and delete cells, rows, and columns, shift cells, resize width and height, and apply autofit to remove extra space.

Master how to manage and organize worksheets in Excel by inserting, deleting, renaming, copying, moving, hiding, and coloring sheets, and apply synchronized formatting across grouped sheets.

Explore how to compare two sheets in a single Excel file by opening a new window, enabling view side by side, and using vertical arrange for independent or synchronized scrolling.

Learn to customize Excel views by placing two or more workbooks side by side, arranging them horizontally, vertically, tiled, or cascading, and toggling synchronous scrolling for cross-file comparison.

Learn how to use the logical test in Excel, using comparison operators (equal, not equal, greater than, greater than or equal, less than, less than or equal) and starting formulas with = to yield boolean results.

Master the Excel if function by evaluating a logical test to return numbers or text; explore boolean results, yes/no, text in quotes, and today and upper examples.

Explore Excel's nested if function to classify marks into distinction, pass, or fail. Use a main if and inner if to handle three outcomes based on 60 and 40 thresholds.

Apply the and function to ensure a value lies between zero and 100, then use the if function to return pass, fail, distinction, or invalid.

Use the not function to invert boolean values, and apply the iferror function to replace errors with a chosen value, as shown across text, number, and boolean data.

Explore editing tools for formulas in Excel, including showing formulas and tracing related cells. Use formula text and evaluate formula to inspect results, and remove arrows to simplify the view.

Master Excel text functions to clean and organize data: trim, proper, upper, lower, and length; left, right, mid, concatenate; and find, search, replace, substitute.

Explore date functions in Excel, including today, now, day, month, and year functions, and learn to combine and adjust dates by adding or subtracting days, months, and years.

Learn to use networkdays to compute working days in a year with optional holidays; customize date formatting to display day names and adjust for international off days.

Learn how to use the date difference function in Microsoft Excel to calculate the years, months, and days between two dates, including age calculation from a birthdate.

Define a named range in Excel and learn two creation methods: quick name box and name manager. Rename, delete, and reuse ranges to jump to data across worksheets.

Create named ranges for numbers and text in Excel and use them in formulas like sum, min, max, average, count, count blank, and the small and large functions.

Explore basic formulas in Excel, including add, subtract, multiply, divide, and modulus; learn operator precedence with brackets and practical cost examples for minutes and text messages.

Learn to use count, count a, count blank, and count if in Excel to tally numbers, text, blanks, and specific words in a data range.

Explore Excel statistical functions such as sumif, sumifs, countif, and averageif with multi-criteria scenarios. Build confidence using ranges and criteria to compute sums, counts, and averages.

Explore sum product to multiply and sum arrays quickly; use amaranth to round numbers, floor and ceiling to adjust values, and mod, mode, and equation for division results.

Master the vlookup with exact match in excel, using vertical lookup, table array, column index, and range_lookup, plus data validation and named ranges for reliable pricing.

Learn how to use vlookup with approximate match in Excel, understanding the fourth parameter (1 for approximate, 0 for exact) and apply it to sales ranges to determine commissions.

Learn how to use vlookup with trim in Excel to remove spaces, fix table references, and ensure exact match results for reliable price lookups.

Learn h-lookups or edge lookup to retrieve prices from a horizontal table using a row index and exact match, illustrated with mobile and laptop examples.

Master the three Vlookup rules: ensure a unique lookup column, search left to right, and base the lookup on the first column of the table to retrieve prices.

Learn how the Vlookup function performs horizontal and vertical lookups using table arrays, retrieving values like tax, id, first name, and phone number, with exact and approximate matches.

Learn to use the match function inside vlookup to retrieve the full record from a table, using fixed references and exact matches for product codes.

Explore the index function in Excel, retrieving data from a table by row or column, and learn both one-dimensional and two-dimensional lookups using arrays or references.

Master the match function to locate the position of data in a table array by using a lookup value and a lookup array for an exact match.

Discover two methods to protect cells in Excel: protect the whole sheet with unprotected data, or unlock the sheet to guard only selected cells with password.

Discover four ways to protect a sheet in Excel, from password protection to setting permissions for formatting, inserting, and deleting rows or columns, via right-click, format, review, and file options.

Protect the entire Excel file by encrypting it with a password, then remove protection when needed, using the Protect Workbook and Encrypt with password options.

Protect the workbook structure to prevent changes to sheets by using the protect workbook option in the review tab and setting a password.

Learn to create hyperlinks in Excel to jump to a specific cell in another sheet, such as F10, using different methods. Explore linking to files, websites, and updating linked content.

Create a hyperlink to access any specific file on your computer. Choose existing file or webpage, set the desktop location, and click to open the file.

Learn to create hyperlinks in Excel to open web pages, by copying a URL, pasting it into the hyperlink dialog, and linking from cells or shapes with screen tips.

Learn to create and update external files from an Excel hyperlink, enabling one-click access to a text document or other file, edit it, save, and reopen from the sheet.

Explore Excel print page setup, including margins, orientation, page size, print area, breaks, backgrounds, and printing titles across pages; access print preview via file or Ctrl+P and save as PDF.

Learn to apply header and footer in Excel to show page numbers, date and time, file name, and sheet name on all pages, with first page and odd/even page options.

Learn to sort data in Excel tables using the sort tool, arranging numbers, text, dates, and colors from smallest to largest, including multi-column and color-based sorting.

Apply advanced filtering, extracting data from a table using list range and criteria range, copying results to another sheet, with multiple criteria including date after 2015 and less than 1000.

Master how to filter data in Excel tables using three methods: manual filtering, keyboard shortcuts, and ctrl shift l. Apply date, text, and number filters with sorting and clear options.