The Complete Microsoft Excel From Beginners to Expert

Explore the Excel interface, including workbooks, worksheets, the ribbon with core tabs, and the quick access toolbar, formula bar, name box, and status bar.

Move and copy data in an Excel worksheet using drag-and-drop, cut and paste, and copying with the control key and fill handle to rearrange and duplicate data.

Explore how to generate random numbers in Excel using rand and randbetween, including decimals between 0 and 1 and whole numbers between specified limits. Recalculate automatically as you edit data.

Master Excel's round, round up, and round down to control decimals and whole numbers. Understand how digits affect results for finance and data analysis.

Learn to calculate workdays with Excel's WORKDAY and WORKDAY.INT functions, adding or subtracting working days from a start date while excluding weekends and holidays, with customizable weekends via binary codes.

Boost your Excel date skills by using the date if function to compute differences between two dates in years, months, or days, while understanding serial date numbers and common quirks.

Master EDATE and EOMONTH to calculate future and past dates, compute last days of months, and streamline monthly reports and financial projections in Excel.

Explore the choose and switch functions in Excel to simplify decision making, replace nested ifs, and create faster, clearer formulas for day-to-day tasks.

Master left, right, mid, and len functions in Excel to extract characters and clean data from cells. Learn to combine these functions for text manipulation.

Explore four essential Excel text functions—upper, lower, proper, and trim—that standardize case, clean spaces, and format names and titles. Learn to combine them for professional, consistent data presentation.

Learn to extract year, month, day, hour, minute, and second components from dates and times in Excel, using functions for data analysis and time-based insights.

Master Excel sorting with sort and sort by functions to sort data by columns or by values from another range, in ascending or descending order, without altering the original data.

Discover how the filter function extracts data that meets specific criteria in Excel, enabling dynamic, multi-criteria filtering and graceful handling of empty results.

Learn to use the unique function to extract distinct values from a range, remove duplicates, and analyze large data sets, as shown with name and product lists.

Explore index, match, and xmatch functions to retrieve data and perform dynamic lookups, then combine index and match for powerful, flexible lookups with exact matches and wildcards.

Learn how to use the match function for approximate lookups in Excel, finding the largest value less than or equal to a lookup value or the smallest greater value.

Master vlookup, the vertical lookup in Excel, to search the first column and return values from a table array's column using exact or approximate matches and the range lookup option.

Extract customer IDs from text in Excel with right, left, or mid functions and combine with VLOOKUP to pull purchase amounts from another table.

Extract and vlookup in excel: learn to pull last five characters as an id using right or other text functions and then look up purchase amounts from another table.

Explore the hlookup function to perform horizontal lookups in Excel, using the lookup value in the top row to return data from a row via exact or approximate range lookup.

Xlookup, a function replacing vlookup and hlookup, enables searches in any direction with settings like lookup value, return array, if not found, match mode, and search mode.

Create dynamic drop-down lists in Excel by building a dynamic named range with offset and using data validation to automatically update as you add new items.

Master pivot tables to quickly summarize, analyze, and present data by dragging fields into rows, columns, and values, then use filters to refine revenue by salesperson and product.

Learn to apply and customize pivot table styles in Excel, using the design tab and pivot table styles gallery, with light, medium, and dark themes, headers, and custom styles.

Create and customize bar, column, line, and pie charts from simple table data to visualize trends, compare categories, and reveal insights with chart titles, labels, and colors.

Insert and format slicers in Microsoft Excel to filter pivot tables and pivot charts visually, then adjust style, size, columns, and clear filters for interactive data analysis.

Protect worksheets and workbooks in excel by locking specific cells and safeguarding the worksheet versus workbook structure. Unlock cells, apply password protection, test protections, and unprotect when needed.

Insert headers and footers in Excel to add text, page numbers, dates, and file names; include dynamic date and time, and preview the print to produce a professional, organized report.

Print your Excel workbook with confidence by mastering print options and page setup. Choose entire workbook, active sheet, or a selection, adjust margins and orientation, and use headers and footers.