Microsoft Excel: Complete Excel from Beginner to Advanced

Format text, numbers, and dates in Microsoft Excel by adjusting fonts, sizes, bold, italic, underline, colors, currency and date formats, decimal places, borders, and create visually appealing spreadsheets.

Adjust row height and column width in Excel to fit text and improve readability. Expand cells, double-click to auto-fit, or set specific sizes to customize your worksheet layout.

Learn how to apply borders, fill colors, font colors, and cell styles to organize data and create a readable table in Excel using the home tab formatting tools.

Use the format painter in Excel to copy formatting such as font, size, color, borders, and fill colors between cells. This saves time and standardizes styling across worksheets.

Explore how Excel formulas work, starting with the equal sign to perform calculations. See how to sum values and use functions to analyze data and automate tasks.

Explore basic Excel functions sum, average, min, max, and count to perform simple calculations, update results dynamically, and analyze data efficiently.

Explore relative, absolute, and mixed cell references in Excel, showing how references adjust when copied and how to apply fixed values like a 10% discount in formulas.

Learn to sort data alphabetically or numerically and apply filters to display only rows that meet criteria in Excel, using the data tab and custom sort options.

Explore how to build dependent drop-down lists in Excel by using data validation to select departments and reveal corresponding employee names.

Identify and remove duplicate entries in a data set using the Remove Duplicates feature in Excel, guiding you through a product list and sales amounts to yield unique values.

Create and customize basic charts in Excel, including bar, pie, and line charts, by building a data set, inserting charts, and tuning labels, legends, and colors.

Learn to create and customize sparklines, mini charts in a cell that visualize data trends, using line, column, and win/loss types with the Sparkline tab.

Master conditional formatting to automatically change cell appearances based on conditions, highlighting trends and outliers with colors, bars, and icons for clearer, dynamic Excel reports.

Master freezing panes to keep headers visible while scrolling large data sets. Learn to split windows into panels to view and compare data across sections simultaneously.

Learn to use Excel's logical functions IF, AND, and OR to test conditions and return values, with examples for passing grades, eligibility for bonuses, and discounts.

Learn Excel text functions such as concatenate (or concat), left, right, length, and trim to clean data, combine names with spaces, extract area codes, and count characters.

Learn to create and format tables in Excel, using structured data ranges with built-in sorting, filtering, and formatting; customize table design, headers, totals, and conditional formatting to analyze data efficiently.

Explore structured references in Excel tables to write cleaner, dynamic formulas using table names and column headers, with practical examples for totals that adjust when the table resizes or renames.

Learn to add total rows to summarize data in Excel tables and use slicers for quick, visual filtering, enabling sums, averages, counts, and selective data views.

Learn to use subtotals and grouping in Excel to summarize data, organize categories, and improve readability with outline options and subtotal settings.

Learn how pivot tables quickly summarize, analyze, and visualize large data sets by dragging fields, creating reports in a new worksheet, and optionally generating pivot charts.

Create pivot charts linked to pivot tables to visualize data dynamically, and learn to customize with slicers, timelines, and chart options for region, product, sales amount, and quantity.

Learn how to use vlookup (vertical lookup), hlookup (horizontal lookup), and xlookup to search tables and return matching values, with practical examples on product prices, stock, and regional sales.