Excel Beginner to Advanced

launch the Excel application and install Excel 365 to access the latest features. pin the Excel app to the start menu or taskbar for one-click launch.

Explore the Excel interface, learn to open a blank workbook, and navigate the title bar, search bar, ribbons, tabs, name box, and the formula bar across worksheets.

Discover how to get help in Excel with screen tips, color, bold, italic, and decimal controls, use F1 and the search bar, and tell me more to open help files.

Explore how tabs, ribbons, and menus organize commands in Excel, with screen tips, contextual menus, and the mini toolbar, and learn to toggle the ribbon and enter full-screen view.

Learn to customize Excel's quick access toolbar by storing frequent commands, moving it above or below the ribbon, and adding or removing options like spelling, sort, and conditional formatting.

Explore Excel's backstage area, the admin hub for managing workbooks: create, open, save (with a name), print, share, export formats, protect with passwords, view metadata and version history, recover workbooks.

Explore workbooks and worksheets in Excel, detailing the grid of 1,048,576 rows and 16,384 columns, the 17 billion cells limit, and naming, renaming, inserting, moving, copying, and tab colors.

Learn how to save workbooks in Excel, using autosave on OneDrive, the Save button, and Ctrl+S; choose file types and manage auto-recovery.

Navigate and select cells, rows, and columns in Excel using keyboard shortcuts and mouse techniques, including Ctrl+arrows, Ctrl+Shift+arrows, and Ctrl+click for noncontiguous ranges.

Learn to enter numbers, text, dates, and times in Excel by selecting a cell, typing, and pressing enter; edit data with double-click, F2, or the formula bar.

Apply number formats in Excel to improve readability, including number, percentage, currency, and accounting, by using the home tab's number group. Formatting does not change the underlying numbers.

Learn to apply date and time formats in Excel, including short and long date formats, and 24-hour or am/pm 12-hour time, with locality changes and formatting applied to input.

Format headings with blue backgrounds and Arial bold text, apply borders, and set date and US dollar currency formats while using auto fit to adjust cell heights and widths.

Discover how to use the format painter in Excel to copy formatting from a source cell to multiple locations, including headings, and deactivate with the escape key.

Master inserting and deleting rows and columns in Excel with right-click, the Home tab, and shortcuts, and use go to special to remove blank cells and to hide or unhide.

Learn to cut, copy, and paste in Excel using keyboard shortcuts Ctrl+C, Ctrl+V, and Ctrl+X. Copy cells, paste to the desired location, and cut multiple values for efficient editing.

Master paste special in Excel to paste values, formulas, formats, validation, notes, and more; use transpose and arithmetic options like multiply and divide.

Learn how to delete and clear cells in Excel, including deleting contents, shifting or removing rows or columns, and using clear all, clear formats, clear contents, and clear hyperlinks.

Learn how to align text and numbers in Excel, including horizontal and vertical alignment, orientation, wrap text, indent, manual line breaks with Alt+Enter, and merge cells for headings.

Learn to create Excel formulas using the equal sign and formula bar, reference cells (not hard coded numbers), and apply operators +, -, *, /, exponentiation, and parentheses.

Discover how Excel applies the bodmas order of operations—brackets, orders or indices (exponentiation), division and multiplication, then addition and subtraction—via formula examples and the evaluate formula tool.

Master formula auditing in Excel using F2 and F5 to trace links. Disable editing in cells on double-click to jump to linked cells and return with F5 and enter.

Learn three efficient methods to enter data and formulas in Excel: enter, ctrl+enter, and tab, and how to customize after pressing enter move selection in file options.

Master absolute and relative cell referencing in Excel, copy formulas with the fill handle or Ctrl+D, and fix references with $ and F4 for reliable tax calculations.

Excel's golden rule says put changing inputs like growth rate in a cell and reference it in formulas to keep forecasts updating; hard code only fixed values like 12 months.

Learn how Excel functions, predefined formulas, syntax, and arguments work, using the sum function to total cell ranges and inserting functions with the fx tool.

Master mixed cell referencing in Excel, toggling with F4 for flexible references, and copy formulas across with precision for tables and forecasts.

Explore circular references in Excel formulas, identify them via the status bar and formulas tab, and resolve them by enabling iterative calculations with up to 100 iterations.

learn how to clean unorganized data in excel using text to columns, choosing delimited or fixed width, and selecting comma or other delimiters to sort data.

Learn how flash fill in Excel recognizes patterns to split names, create emails as first name dot last name at company domain, and format dates and numbers with ctrl e.

Learn how to use autofill in Excel to quickly fill cells with months, days, numbers, and custom lists by dragging the fill handle, creating patterns, and using the series options.

Create drop-down lists in Excel using data validation to restrict cell entries to items from a chosen list, applying the rule via the data tab and list source.

Sort data with Excel's custom sort, first by volume from largest to smallest, then by price per unit, expanding the selection to keep all columns intact.

Learn how to use the select special tool in Excel to locate cells by criteria, including formulas, constants, blanks, objects, conditional formatting, and data validation.

Learn to freeze panes in Excel to keep headings visible while scrolling, freeze the top row or the first column, and unfreeze as needed.

Apply conditional formatting in Excel to highlight cells by criteria, greater than, less than, or between, with data bars, color scales, and icon sets; use formulas and manage rules.

Learn to build an Excel number format separated by semicolons, with thousand separators and red negative numbers, using hash versus zero placeholders to control positive, negative, zero, and text displays.

Master custom formatting in Excel to display values like a PE ratio with a trailing x while keeping underlying numbers usable in calculations; explore date, forecast, and fiscal year formats.

Learn to insert, edit, and remove hyperlinks in Excel to navigate between sheets and to external files, web pages, or emails. The lesson covers converting text to a link.

Master find and replace in excel to update data and cell formulas across a worksheet or workbook, including exact-match options and updating cross-workbook references.

Learn to use find and replace to update workbook-wide formatting in Excel. Build formatting from a selected cell, replace with dark blue fill, and apply changes across all sheets.

Learn to remove the automatic green arrows in Excel by ignoring the error per cell or by disabling background error checking in Excel options under formulas.

Apply filters in Excel to refine data by date, text, and number fields using the data tab, with examples like after a date and greater than prices.

Create dynamic names in Excel to automatically update headings and currency units across financial models by linking headings to an input sheet and concatenating fixed text with cell references.

Learn how to create and use named ranges in Excel, define names, apply them to formulas, manage scope with the name manager, and improve readability and reliability across sheets.

Learn to set a print area in Excel by selecting the sheet region. Use the page layout tab to set the print area, view the border, and preview with margins.

Explore 3D formulas in Excel to consolidate data across multiple worksheets by summing across region 1 to region 3, capturing values like D3 (and D4 for cost of sales).

Learn essential data manipulation shortcuts in Excel, including copy, paste, cut, and paste special options. Explore values, formulas, number formats, multiply, transpose, flash fill, autosum, and insert or delete cells.

Learn Excel data selection and navigation shortcuts, including control arrow and shift combinations to move, select ranges, and jump to ends or entire rows and columns.

Discover practical formatting shortcuts in Excel to quickly apply number, date, time, currency, and text formatting using keyboard combos like Ctrl+1, Ctrl+B, and Ctrl+Shift+% with context-aware formatting options.

Explore essential Excel editing shortcuts: use F2 to edit formulas, F4 to toggle absolute references, Ctrl+Enter to fill a range, Alt+Enter for multi-line cells, and F9 to evaluate formulas.

Master essential Excel shortcuts for files: Ctrl+O to open, Ctrl+N for new, Ctrl+W to close, Ctrl+S to save, and F12 to save as; also Ctrl+Tab to switch workbooks.

Master the sum function in Excel to add numbers across ranges or cell references, ignore text, and speed totals with Autosum and the Alt + = shortcut.

Explore how the average function in Excel computes the mean of a range, ignoring empty cells, text, and logical values, while including zeros.

Learn the count function and related functions in Excel, counting numbers, non-blank cells, and blanks, and view quick results like sum, max, min, and average on the status bar.

discover how the min function finds the smallest number and the max function finds the largest, using exam scores where mary's 49 is the minimum and james's 91 the maximum.

Learn to use the large and small functions in Excel to find the nth largest or nth smallest value in a list, using the array and k arguments.

Master ranking in Excel by using the rank function and the new rank_eq and rank_avg, sorting scores descending, and handling duplicates with the same rank or averaging to 3.5.

Explore how the aggregate function in Excel performs 19 operations, including max and sum, with seven options to ignore hidden rows, errors, and subtotals.

Master the round function in Excel: round(number, digits) controls decimal places and integers, using digits >0 for decimals, digits =0 for integers, and negative digits for tens, hundreds, and thousands.

Explore how the Excel index function retrieves a value from a specified row and column within a range or array, including handling multiple arrays with the area argument.

Learn how to use the match function in Excel to find the position of a lookup value within a range, with exact, approximate, and wildcard match options.

Explore the xmatch function in Excel, comparing it to match, and learn exact, approximate, wildcard, and regex matches, plus binary search and reverse search modes.

Learn to combine index and match in Excel to perform lookups, offering advantages over vlookup for lookups where value is on the right, using two matches and one index formula.

Multiply numbers or ranges with the product function and learn its simple syntax, then use sumproduct to multiply corresponding arrays and sum the results.

Explore the Excel if function: perform logical tests with true/false results, use nested ifs for multiple grades, and apply practical examples like tax calculation and balance sheet checks.

Learn how to use the IFS function in Excel to handle multiple conditions with logical tests and values if true, including a default value when all conditions are false.

Learn how the Excel choose function selects a value by index and build a switch for high, medium, and low inflation scenarios in financial models using a data validation drop-down.

Explore how to use sumif, averageif, and countif in Excel to sum by criteria, compute averages, and count occurrences, using range, criteria, and the corresponding sum or average ranges.

Explore how to use Excel's sumifs, averageifs, countifs, minifs, and maxifs to compute results across multiple criteria, with syntax, cell references, and hard-coded values in sales scenarios.

Explore Excel's database functions, including d sum, d average, d count, d counter, d max, d mean, and d product, for criteria-based calculations with and/or logic.

Explore common Excel error types and how to handle them with error functions like iferror and ifna, wrapping lookups like vlookup to return friendly messages or blanks.

Master Excel text functions to clean and manipulate data. Learn char, trim, exact, concat, text join, lower, upper, proper, left, right, mid, len, find, search, replace, substitute, and text formatting.

Learn to view dates as serial numbers, convert text with date value, extract day/month/year/weekday, and perform date arithmetic with today, edate, end of month, days, and date diff.

Explore vlookup and hlookup in excel, mastering vertical and horizontal lookups, exact and approximate matches, wildcards, multi-column results, and error handling with iferror and if.

Discover how to use Xlookup in Excel for vertical and horizontal lookups with exact and wildcard matching, separate lookup and return arrays, and flexible search modes from first to last.

Learn Excel formula auditing with error checking, evaluation steps, and handling hash name errors; use the watch window and trace dependence and precedence across sheets.

Apply goal seek to determine the breakeven point by setting the net income to zero and changing units sold via data and what-if analysis.

Perform sensitivity analysis in Excel with one- and two-way data tables to see how price and cost per unit affect net income and revenue, and identify risk areas.

Sort data by region, then apply subtotals to units and sales using the sum function. Create multi-level subtotals by region and salesperson, with a grand total and summary below.

Convert a data range into an Excel table to organize data, automate formatting, sorting, filtering, and dynamic chart or pivot updates, using structured references and table-aware formulas.

Learn how to consolidate data across workbooks in Excel using the consolidate command, with the sum function, shared structure, and dynamic links that update when source files change.

Learn how to insert a chart in Excel by selecting data, choosing a chart type from recommended or all charts, and changing types to suit your data.

Learn to edit Excel charts with chart design and format tools, adding axis titles and data labels, switching rows and columns, and adjusting data ranges.

Learn to format Excel charts by adjusting chart area, fills, borders, and grid lines. Customize bar colors, data labels, axis scales, and gap width for a professional look.

Create a column stacked chart in Excel showing net sales, COGS, and net income as columns with gross margin as a line on a secondary axis.

Create a donut chart in Excel to visualize 2024 sales for three products. Customize fonts, colors, donut hole size, axis labels, legend position, and data labels.

Learn to create a 2D stacked area chart in Excel, select year headings, customize colors, and format the chart with Arial font, no fill or border, and a blue title.

Create a combined area and line chart in Excel to show revenues and gross margin, using a secondary axis and switching the gross margin series to a line (smooth line).

learn to create bullet charts in Excel to compare actual versus target values, using a clustered column approach, secondary axis, and formatting to visualize net profit margins.

Explore sparklines, tiny in-cell charts that show trends in Excel data, and learn to insert, customize line, column, or win-loss types.

Explore how to create treemap charts in Excel to visualize revenues across countries and cities, using hierarchy charts to compare UK, USA, France branches and city-level data like London.

Explore pivot tables in Excel to summarize and analyze data with interactive, drag-and-drop fields. Group data by categories, years, and months, filter results, and build charts for quick insights.

Create pivot tables in Excel from sales data by dragging fields to rows, columns, and values; set regions as columns and sales reps as rows, format numbers with thousand separators.

Discover how to format pivot tables in Excel by applying built-in designs or creating custom styles, adjust layout options and subtotals, and explore pre-built layouts like compact, outline, and tabular.

Modify pivot tables by refreshing data, adjusting value fields, and rearranging rows to analyze sales by region, sales rep, and product, using filters and slicers.

Learn to use slicers to filter pivot tables, replacing outdated filters with a user-friendly visual approach by inserting slicers for fields like customer and region, and selecting multiple items.

Master the getpivotdata function in Excel to retrieve sales totals from pivot tables using data field plus optional field and item criteria, including date handling.

Explore Power Query in Excel to gather, clean, and reshape data from multiple sources, automate ETL tasks, and load results into Excel, Power Pivot, or Power BI.

Explore how to use Power Query in Excel to import data from web, PDF, and folders, transform and clean data, and load it with dynamic updates and pivot ready results.

Explore PowerPivot in Excel to build data models from multiple sources, use DAX to create calculated columns and measures, and publish pivot tables to SharePoint.

Explore PowerPivot in Excel to build a data model, import data from databases and text files, create relationships, and summarize revenue with pivot tables and DAX measures.