Microsoft Excel Beginner to Expert

Create and manage a new worksheet by entering data in cells, zooming to view content, and navigating with the keyboard or the mouse, including how A1 text appears and moves.

Copy and move data regions in Excel using drag, ctrl-drag to copy, and clipboard commands; try various paste options, cut, and cross-sheet copying.

Master Excel selection for large data groups using drag, shift-click, and ctrl-click to select ranges, columns, or rows. Copy, cut, paste, insert, and filter the selected areas.

Learn how to change a worksheet structure in Excel by inserting single and multiple rows or columns, using top column selection, right-click insert, and shift cells down.

Discover faster methods to sum cells in Excel with auto-sum, equals sum, and drag-to-select techniques, including how the total appears below the last cell.

Master how to sum in Excel using AutoSum across selected numbers, rows, and columns. Add an extra row and column and see the total update with one click.

Discover how to calculate averages, maxima, minima, and counts in Excel columns using the average, max, min, and count functions, then select ranges and drag formulas across columns.

Master inserting fixed versus dynamic dates in Excel: press ctrl+; for today's date, use =today for a changing date, and =now for current date and time.

Use the if function to determine commission rates based on sales, apply conditional formatting, calculate commissions, lock references with dollar signs, and add informative comments.

Use sumif and averageif to sum hours or rate by a specific state, like New Jersey, by selecting the state range and quoting the state name.

Name data ranges like January and February, then use the sum function with those names to calculate monthly totals. Manage named ranges and edit them in the Name Manager.

Learn how to format numbers and dates in excel, adding currency, commas, decimals, percentages, and dynamic date time with today and now functions, plus custom date-time formats.

Master font styling in Excel by applying bold, italic, or color; learn to merge and center, wrap text, adjust alignment, background color and text color, and borders.

Learn to adjust columns and row heights, apply text wrapping, and auto-fit widths and heights in Excel. Preview print layout with headers and footers to ensure everything fits and aligns.

Create custom conditional formatting rules in Excel to highlight data, using values above 500, between 500 and 600, and duplicates highlighted in yellow.

Add photos and shapes in Excel by inserting pictures, placing them in cells or across sheets, making backgrounds transparent, and creating shapes with text, alignment, font, and gradient options.

Create a data table with format as table, apply a theme to unify colors across cells and charts, then customize colors and save a personal scheme like olive oil.

Create and save a custom style in Excel, name it Polyp or Olive Oil, and transfer it to other sheets with merge style for consistency.

Explore how to use ready-made templates in Excel, including invoices, balance sheets, budgets, lists, and charts; modify, download, print, and link charts to update data automatically.

Create and use original templates in Excel to standardize company documents for reports and logs. Save templates from the save as menu and organize data by date.

Configure page setup in Excel by setting page size, orientation, margins, and a defined print area to print only the selected cells, then preview and center the result.

Insert headers and footers in page layout view, placing content in the top and bottom areas with left, center, and right sections, including page numbers and file or sheet names.

Discover how to print Excel worksheets, add logos to headers and footers, clear print areas, and use print preview to print or save as a PDF with synchronized orientation.

Freeze panes to keep the header row and names visible as you scroll in Excel, using split and freeze pane options to lock both rows and columns.

Create and manage multiple custom worksheet views to quickly access important data ranges, save selections, and switch between views via the view tab and double-click.

Master hiding and grouping rows and columns in Excel to control what you share or print, using right-click hide or grouping to collapse, expand, and unhide when needed.

Learn to manage worksheets within a workbook: create, rename, color-code, copy, group, and delete sheets, and move data into new workbooks, with safeguards on the last sheet.

Learn to create a cross-sheet summary in Excel by summing the same cell across four worksheets named north, south, east, and west, then consolidate results.

Learn to protect Excel data by applying sheet and workbook protections with passwords, unlock specific cells, and encrypt files so only authorized users can edit while the rest remains non-editable.

Learn to share an Excel workbook, collaborate in real time, manage access, send sharing links, and monitor who edits each cell.

Track changes in a shared worksheet with show changes to see who edited which cells and the previous and new values, then accept, reject, or revert edits.

Insert a new column, then use text to column with space as the delimiter to split a full name into first and last names.

Learn to join data from multiple cells in Excel by combining first and last names into one column using a space and concatenation, convert formulas to values to preserve results.

Learn to sort and filter data in Excel, arranging by last name or hours from A to Z or Z to A, and apply column filters to refine by state.

Create tables in Excel to sort and filter data using the insert tab and table icon, enable headers, and use drop-downs; remove duplicates with table design tools.

Learn to create automatic subtotals in Excel by sorting by department and applying sum, average, max, or min. Navigate levels to display grand totals for clear, professional reports.

Name your data as a range and use the vlookup function to display a product description and total sales from the data set using exact match.

Learn to audit and check errors in Excel using formula auditing tools, tracing precedents and dependents with arrows, and diagnosing divide-by-zero errors to verify data before printing.

Learn to evaluate Excel formulas by tracing B5's value against the average to choose 5% or 10% commission, and verify results using the evaluate formula approach.

Master Goal Seek in Excel to find loan values that produce a target monthly payment, exploring borrow amount, interest rate, or term adjustments.

Use the PMT function with data tables to model loan payments across years and present values. Convert annual rates to monthly, set input cells, and compare single and dual-variable scenarios.