Microsoft Excel Mastery: Beginner to Pro Success

Master resizing rows and columns in Excel to improve readability, using drag to resize, auto fit, wrap text, and exact column width from the home format options.

Explore basic font formatting in Excel, including changing font type and size, applying bold, italics, and underline with shortcuts, and using color fills and custom RGB to style headings.

Explore formatting numbers in the home tab, applying currency and accounting formats, adjusting decimals and thousand separators, and converting values to percentages and date formats.

Master basic cell alignment in the Excel home tab, including centering and vertical alignment. Apply wrap text, merge center, and shrink to fit using the format cell box (Ctrl+1).

Apply preset formatting options from the home tab to style headings, header rows, and text colors, then explore color themes and more colors to quickly match a chosen theme.

Discover advanced cell formatting in Excel, including borders, shading, colors, and patterns. Learn to use the format cell box (Ctrl+1) and fill tab, and see how conditional formatting enhances visuals.

Sort by sales value (highest in the last quarter) using the stock list example. Apply multi-level sorting and filters to highlight top items and refine by price.

Learn to prepare worksheets in Excel by using workbook views, page break preview, and page layout to fit data on one sheet, adjust margins, scale, and add headers or footers.

Rename worksheet tabs to clearly label stock lists and annual summary, color-code them, and learn to move, copy, delete, or protect worksheets for consistent organization.

Master autofill and inputting data in Excel by dragging to extend dates and formulas across rows and columns, and use paste special and shortcuts to copy formulas down and right.

Master the flash fill feature in Excel to quickly separate first and last names and fill data across columns, using the home tab's editing group.

Create drop down lists in Excel with data validation, selecting priorities like low, medium, or high from a source table to standardize inputs across cells.

Learn to transpose data in Excel by flipping rows and columns using paste special and transpose option, linking the new table back to the original with a transpose array formula.

Import data from the web into Excel using the from web option, then load and format it as a table, splitting the type and description by delimiter.

Master named ranges in Excel through three creation methods, manage them with Name Manager, use them in formulas and drop-down lists, and build dynamic ranges and tables.

Explore Excel formulas and operators, including addition, subtraction, multiplication, division, and exponent with parentheses and cell references, plus the equals sign and text joining with concatenate.

Learn to add data in Excel using the sum and sumif formulas, the Alt plus equals shortcut, Autosum, and criteria-based totals such as greater than 2018.

Learn to calculate population per km squared by dividing data in Excel, copy the formula down with the fill handle, and format results with one decimal place and thousands separators.

Master absolute and relative cell references in Excel, learn how to lock columns or rows with dollar signs, and apply mixed references in formulas as you copy across and down.

Master absolute and relative cell references in Excel using the F4 shortcut to toggle dollar signs for column and row, demonstrated with VLOOKUP steps.

Learn to use sum, average, count, and counta in Excel, build formulas across ranges, utilize autosum, copy results, and handle common errors.

Explore Excel's formula auditing and error checking tools, including show formulas, trace dependents and precedents, and error evaluation. Learn manual and automatic calculation options with calculate now and calculate sheet.

Learn how to use the if function in Excel to perform a logical test, return true or false results, combine with other functions, and apply discounts based on bottle quantities.

Discover how the iferror function, introduced in Excel 2007, cleanly handles errors in vlookup results and returns zero when errors occur.

Learn the Vlookup function in Excel, its four parts, and how to use an exact match to return prices per bottle from a table, with absolute references.

Master approximate lookups with vlookup to assign discounts based on bottle quantities. Use an ordered table, column two, and true matching, with iferror to return a zero value.

Explore the and function as a logical test in Excel, which checks multiple conditions and returns true when both coursework and exam marks are more than 60%, to pass.

Explore the or function in Excel, a logical tool. Determine pass status from coursework and exam scores against the pass mark, using true if any condition is met.

Master the not function in Excel, a logical tool that inverts a logical test and pairs with the if function to evaluate the passmark.

See how Xlookup is a flexible alternative to Vlookup, returning values from any table column. Learn about optional parameters, not found handling, and wildcard and match modes.

Master XLOOKUP and named ranges to clarify what you look up in a workbook, replacing VLOOKUP and HLOOKUP with readable, named ranges and table data.

Learn how the trim function removes extra spaces at the start and end of a cell using =trim(cell), and how copy down and paste as values clean imported data.

Learn to use the subtotal function in Excel to clean data, select total types, exclude hidden rows, and apply subtotals and averages across a dataset.

Master Excel's round, round up, and round down to format numbers to specific decimals or to the nearest ten, hundred, or thousand, including two decimals and whole-number rounding in formulas.

Learn how to use Excel's max and min functions to find the largest and smallest values in a range, ignoring empty cells, with practical scoring examples and cross-column use.

Master the text function to convert numbers to text, format dates as month and year or with two-digit year, display currency with the pound symbol, and concatenate values with text.

Master the large and small functions in Excel to find the nth largest or smallest value in a data range, and order an array from largest to smallest by position.

Use today and now to insert current date and date-time, format with presets or custom formats, and apply conditional formatting to highlight overdue items.

Master Excel text casing by applying the upper, lower, and proper functions with simple formulas to convert cells to uppercase, lowercase, or capitalize each word.

Master Excel text extraction with left, right, and mid functions to pull days, times, and years from strings, using standard-length fields and practical date-time examples.

Learn how to locate a character in a cell with the find and the search functions in Excel, including start positions and the caption's case sensitivity differences.

Combine the FIND and MID functions in Excel to extract the five-character middle segment that follows a dash, showing how to handle varying start positions using LEN.

Master a custom sort list in Excel to order suppliers by size (large to small or small to large) using the data tab, custom lists, trim, and multi-level sorts.

Learn to use sumif to calculate annual spend by supplier, then sort with a custom list from large to small, and fix a sheet reference bug that disrupts sorting.

Learn how to use the rank function in Excel to determine each number's position in a list, with optional ascending or descending order, absolute referencing, and the rank average option.

Create dynamic array driven drop-down lists with unique and sort to list managers, then use filter to return employees by manager, enhancing lookups with xlookup when needed.

Master the dynamic array filter function in Microsoft 365 to filter large tables by region, customer, or product using simple parameters, with table formatting enabling automatic expansion.

Master pivot tables in Excel with drag-and-drop analysis of sales data; create, format, filter, and visualize revenue and orders across customers and products.

Learn to create and customize private charts in Excel with drag-and-drop data, from data tables to revenue by customer, including chart types, formatting, and filters for insightful visuals.

Save a chart as a template to preserve fonts, colors, legend and axis formatting, then insert it via templates to apply the exact style to new data.

Celebrate your journey from beginner to pro with Excel mastery and unlock your professional potential in finance, marketing strategies, and operations.