Complete Excel Course - Beginner to Expert

Explore Excel basics: navigate a workbook with multiple worksheets, name tabs, organize related data in one file, reference cells with the name box and formula box.

Learn basic math in Excel, including addition, subtraction, multiplication, division, and exponents, guided by the order of operations and parentheses. Start formulas with the equals sign and use evaluate tools.

Learn how to build formulas by placing inputs in separate cells and referencing them, using relative and fixed references, copying formulas down, and evaluating operations for clear, updatable calculations.

Master fixed and relative cell references in Excel by learning how to lock rows or columns with F4, copy formulas across rows and sheets, and manage mixed references.

Master formatting basics in Excel by using the format cells dialog box to adjust alignment, font, borders, fill, and protection, including center across selection and wrap text.

Discover the number tab in the format cells dialog and apply general, currency, date, time, percentage, fraction, scientific, text, and custom formats, understanding serial values and conversion to numbers.

Learn custom formatting in Excel by decoding format codes, using placeholders such as 0 and #, and applying color, date, time, and accounting formats.

Learn to apply custom formatting in Excel to display percentage changes from a variance formula, using green for positives and red for negatives, with symbols and left-aligned formatting.

Master formatting a balance sheet by applying fonts, colors, borders, currency formats, thousands separators, and variance calculations to present data clearly.

Explore built-in cell styles in the home tab, apply formats like input cells, warnings, and headings, and learn to create, save, and import custom styles across workbooks.

Explore conditional formatting in Excel, using formulas to highlight cells by criteria, manage relative and fixed references, apply multiple rules, and create practical color-coded visuals.

Explore conditional formatting in Excel using built-in rules and custom formulas, highlight dates, top values, duplicates, and visualize data with data bars, color scales, and icon sets.

Learn to sort and filter data in Excel by numbers, text, and dates, including multi-level sorts and custom lists, while keeping related rows intact in a table.

Filter data in Excel using the filter dropdown, color-based filtering, and multiple criteria. Apply equals, or, and, between, top values, and date filters with the date picker.

Use Excel's advanced filter from the Data tab to apply complex criteria, multiple conditions, and optional copy to another location, including unique records and wildcards.

Hide and group data with outline and subtotals to control visibility, compare hidden versus filtered results, and use subtotal and aggregate for accurate calculations.

Master text to columns in Excel to split one column into two or more, using delimited or fixed width options, dash or space delimiters, and destination placement.

Explore how flash fill detects patterns to extract city, name, email, and postcode with a single example. Apply it across data to format, join fields, and adjust case without formulas.

Learn how to use data validation in Excel to restrict entries, create dropdown lists, enforce data types and ranges, apply formulas, and compare validation with conditional formatting for quality control.

Connect to external data in Excel using the Data tab and get data from a workbook to link to another workbook, so refresh updates the destination when the source changes.

Connect Excel to a text file, import data from text or CSV, and preview column separation by spaces or tabs. Refresh updates when the source changes, loading as a table.

Connect Excel to a website and other data sources with Power Query, import and transform web data, and keep it dynamically updated for reporting.

Learn to pull live stock prices and geography data in Excel using stock codes. Bring in fields like price, volume, population, GDP, and life expectancy, then compute portfolio value.

Consolidate data across multiple months using the sum function to create a dynamic master table that matches and totals by car names from separate tabs.

Explore scenario manager in Excel to perform what-if analysis by changing inputs and observing outputs such as net profit and investment value across best, medium, and worst cases.

Explore Excel data tables (one-way and two-way) to vary inputs like interest rate and loan terms and observe outputs such as annual repayment, total payments, and total interest.

Explore goal seek in Excel to work backwards from a desired output to identify the required inputs, using examples like age calculation and mortgage payments.

Use Excel solver to maximize weekly profit under labor, storage, and unit constraints. Define production variables, set the objective, enforce integers and non-negativity, and interpret binding constraints.

Learn to forecast time series in excel by plotting actual population data against forecast values, interpreting upper and lower confidence intervals, and adjusting forecast horizons to see uncertainty.

Master named ranges in Excel to replace cell references with meaningful names like income and expenses, or radius; apply in formulas, data validation, conditional formatting, and indirect lookups.

Explore how booleans convert to 1 and 0, apply logical operations in Excel with true/false, and use these values in functions like the sum product function and logical tests.

Explore how Excel tables automatically format, expand, and update charts, pivot tables, and formulas using references with table names and square brackets, and learn naming, styling, and data validation benefits.

Explore how formulas differ from functions in Excel, focusing on the sum function, its arguments, optional parameters, and the advantage of range referencing and named ranges.

Learn to use logical functions in excel, including true, false, and, or, xor, not, and if, along with nested function, data validation, and conditional formatting to build robust, adaptive spreadsheets.

Discover common Excel errors, from division by zero and #NAME? to value and reference errors, and learn to diagnose them using function dialogs, lookup basics, and formula evaluation.

Learn to use the indirect function to convert text to cell references and create dynamic, cross-sheet references for budget versus last year with data validation and dependent dropdowns.

Explore basic functions on ranges in Excel, including sum, product, average, max, min, rank, median, quartiles, percentile, count, and concatenate, plus expanding ranges for cumulative totals.

Explore how the Excel offset function shifts a starting reference by rows and columns to create dynamic ranges, enabling summaries with sum or average that auto-update as data changes.

Learn to use countifs, sumifs, and averageifs to count, sum, and average data across large ranges with multiple criteria like nationality and position, using wildcards and named ranges for clarity.

Use the sumproduct function to multiply corresponding values across ranges and sum them, using double negatives to convert booleans into ones and zeros for conditions.

Master essential Excel math functions, from absolute and sign to rounding, mod, quotient and int, plus pi, power and random generators for forecasting and analysis.

Explore essential Excel text functions—left, right, mid, len, search, find, replace, substitute, text, value, clean, trim, lower, upper, proper, and repeat—for transforming and analyzing strings.

Explore Excel's lookup functions—VLOOKUP, HLOOKUP, and LOOKUP—to match values with four arguments, understand exact versus approximate matches, and troubleshoot issues like fixed references and text versus numbers.

Learn how to use index and match in Excel to replace vlookups, return positions and values, and perform exact, approximate, right-to-left, and two-way lookups with real-world examples.

Master the Excel index function for single and two-way lookups, using match for exact results. Create dynamic ranges with offset or index and named ranges, and apply them to charts.

Explore the formula auditing tools on the formula ribbon tab, using evaluate formula to step through calculations, trace precedents and dependents, and monitor with the watch window.

See how dates in Excel are serial numbers, while time is a fraction. Apply date and time functions to convert, compare, and calculate days, workdays, today, now, and end-of-month.

Explore subtotal and aggregate in Excel to sum visible or hidden data, compare with sum, and learn how aggregate handles errors and filtered values for flexible calculations.

This lecture explores the Excel choose function, contrasts it with index, and demonstrates listing arguments individually, using month-to-quarter mapping, table lookups, and array syntax for flexible lookups.

Convert text wages to numbers, set wage brackets, and use the frequency function with control-shift-enter to reveal a histogram-like distribution of players by earnings, including percentages.

Explore Excel financial functions from depreciation with the d.b. function to loan payment tables, nominal and effective interest, and investment evaluation using pv, fv, npv, and irr.

Explore the least common Excel functions highlighted, including address, column/columns, row/rows, expanding ranges, vlookup, formula text, hyperlink, and transpose, plus cube and information functions for external data.

Explore how old array formulas in Excel handle ranges versus single values, using trim, sum, and sumproduct, and how control shift enter converts ranges into arrays.

Explore 2018 array updates in Excel 365, including spill formulas and the nine new functions, with practical uses of the filter function on Academy Awards data.

Explore Excel's sort and sortby functions, reference the entire dataset via the pound operator, and sort by column or by name.

Explore randarray and sequence in Excel: define rows and columns, set minimum and maximum, and observe dynamic arrays that spill with the pound operator and adjustable increments.

Learn how the unique function returns a distinct list from an array, using award categories, and compare with pivot tables.

Explore the single function in Excel, alongside the sequence function, and learn how to reference a range, use the intersection operator, and spill results with the at symbol.

XLOOKUP simplifies lookups by handling exact and approximate matches, works left or right, and replaces VLOOKUP with a flexible single reference, including not found handling.

Explore Excel's XMATCH, a new function that replaces MATCH and is similar to XLOOKUP, working with INDEX for two-way lookups using exact-match defaults and an optional search mode.

Learn how array-based results extend both new and old Excel functions, using frequency to bucket wages and apply array operations like sumproduct with spill-friendly results.

Learn to create a searchable dropdown list in Excel using dynamic arrays, the SEARCH and FILTER functions, and a spill range, with data validation and a table that updates automatically.

Learn to use pivot tables to quickly analyze large datasets, set up proper data with headings and consistent types, and create dynamic reports with rows, columns, and values.

Explore pivot table techniques with practical examples, adjusting value field settings to display sums, counts, percentages of grand total and of parent, plus running totals and top five items.

Learn to use manual sort, multiple filters, and pivot table options to refine pivot tables with label and value filters, and customize display and printing settings.

Explore drill down in pivot tables by double-clicking a line to reveal detailed rows from the original data, such as gold medal winners for basketball or other fields.

Build a pivot table from sport data, display count of medals by sport, exclude grand total, and apply conditional formatting with data bars to highlight standout values.

Group dates in pivot tables by month, quarter, and year to summarize rainfall data, calculate sums, and show percentages of the year by month.

Explore how to insert and customize slicers to filter pivot tables visually, link slicers across multiple pivot tables and charts for interactive dashboards.

Insert a timeline in a pivot table to filter data by date, set granularity to months, quarters, days, or years, and link it to multiple pivot tables via report connections.

Master pivot table formatting and design using the analyze and design tabs, field settings, and names to create clear, customizable reports with proper layouts.

Create calculated fields in a pivot table to compute attack divided by defense and attack as a percentage of total. Format the results and manage solve order when needed.

Explore building a pivot table and using the GetPivotData formula to extract the top five Australian locations by highest average max temperature, with precise location and temp criteria.

Link pivot tables to pivot charts to visualize data, update automatically when the underlying Excel table is refreshed, and explore chart types, slicers, and data sources.

Learn to quickly summarize large datasets with pivot tables by dragging fields into rows, columns, and values, without formulas, and convert data to an Excel table for auto updates.

Discover PowerPivot, an Excel add-in for building a data model from multiple sources, linking tables with common keys, and creating cube and KPI reports that update from original data.

Explore creating Excel charts from pokémon data set, Dragonball Zi, and video game sales datasets using insert tab, select data, axis labels, and dynamic titles linked to cells.

Create dynamic ranges for Excel charts using offset and index formulas, and implement named ranges to auto-update charts as you add new data.

Master chart design in Excel by previewing styles, changing color scales, and selecting layouts. Add data labels, grid lines, legend, and trend lines while exploring chart elements and formatting options.

Explore chart formatting in Excel: format the chart area, title, axis, legend, and series; apply fills, borders, 3D effects, gradients, text options, and data labels.

Explore advanced chart formatting in Excel, including adding shapes and text boxes to charts, using format options and right-click shortcuts, saving templates, and aligning multiple charts for dashboards.

Compare column and bar charts in Excel, learn how to insert charts, set horizontal category labels and series, and reduce data ink and unnecessary grid lines.

Create line charts to visualize time series data, select data ranges, and configure axes and legends. Add dynamic series and trend lines to reveal growth patterns over time.

Learn how to create and customize pie charts to visualize category splits, add data labels and legends, and experiment with pie of pie and exploded slices.

scatter charts plot two numerical values on x and y axes, while bubble charts add a third dimension with bubble size. examples use attack, defense, and speed to illustrate visualization.

Learn how to create a histogram in Excel by grouping wages into buckets using the histogram tool, converting text to numbers, and formatting the chart for clear data visualization.

Explore box and whisker, tree map, sunburst, funnel, surface, and radar charts in Excel, with examples of distribution, hierarchical data visualization, and population insights.

Visualize visited countries on an Excel map chart by marking Y and coloring by population. Adjust map size, color schemes, and the population-based shading to compare visits.

Learn how to build a project timeline in Excel using a 2D stacked chart, with start dates and duration, to visualize concurrent tasks and overall progress.

Master combo charts in Excel by plotting invoiced sales and gross margin on a secondary axis; use a line for margins, apply 0–1 scaling, visualize break-even, 80/20 rule.

Learn to use sparklines—tiny charts inside cells in Excel—to visualize regional sales trends with line, column, and win/loss styles, including data ranges, high/low highlights, and color customization.

Select a country from a data validation dropdown to display its flag using nine named ranges and a mapping formula, with indirect referencing to the corresponding flag cell.

Enable the camera tool in the Excel ribbon, add it to a new tab, and insert a dynamic photo of cells; then customize with framing, borders, shadows, and reflections.

Design engaging infographics by turning icons into a 3d stacked column chart using green and red segments to show power levels against a target with dynamic data labels.

Create a speedometer gauge in Excel using a donut or pie chart rotated to 270 degrees. Hide the 100 percent portion and color segments red to green.

Build a dynamic Excel dashboard from a Pokemon data set by turning data into a table, creating pivot tables and charts, and adding slicers for interactive filtering.

Select a default theme to control colors, fonts, and effects for charts and shapes, customize each element individually, and save it as the current theme so objects use it automatically.

Master page setup in Excel to print sheets by adjusting orientation, margins, fit-to-page, print area, and repeat titles, with gridlines and headings options.

Customize headers and footers in Excel to display page numbers, worksheet names, file path, date and time, and confidentiality notes.

Preview and print in Excel using the print dialog, set page breaks, and choose entire workbook, a selection, or a table. Configure orientation, margins, and scaling to fit one page.

discover three basic spreadsheet views: normal, page break preview, and page layout, and see how they affect printing, margins, headers, and footers.

Create a new window to view a copy of your workbook, then arrange windows in tile, split, or cascade, work side by side, and choose synchronous or independent scrolling.

Explore page layout and page setup options, view modes like normal and page layout, print preview, zoom, and freeze panes to manage printing appearance and navigate large data sets.