Microsoft Excel Tutorial - from Beginner to Advanced

Learn the basics of Microsoft Excel, from navigating the ribbon and worksheets to entering data in cells, selecting ranges, and creating simple formatted tables with merge and center.

Organize data in Excel by applying correct data types (currency, number, date), using conditional formatting and data bars, and mastering filter, sort, and autofill techniques.

Learn to apply Excel formulas to a database using sum functions, range references, and built-in options. Explore manual sums, auto sum, auto average, and insert function for efficient data analysis.

Explore how to use relational operators in Excel with the IFF function to produce numeric, string, and boolean outputs, and learn the proper syntax for true and false results.

Create a pivot table in Excel from an original data table, place it in a new or existing worksheet, and organize filters, columns, rows, and values.

Learn how to clean and manipulate text in Excel using functions like trim, len, upper, lower, proper, and concatenate to format data, count characters, and assemble names.

Explore the three cell reference types in Excel—relative, absolute, and mixed—and learn how to build formulas, fix cells with dollar signs, and drag to fill tables.

Master text to columns in Excel to split a single column into multiple fields using delimiters such as space, comma, or tab, or apply fixed-width rules.

Discover how to use Excel's paste special to paste formatting, values, or keep column width, and enable speak cells to speak data row by row or by column.

Learn to create, edit, delete, and import custom lists in excel, and use advanced fill to copy a single value across multiple cells.

Learn to use flash fill and the series feature in Excel to quickly generate patterns and extract digits, and apply step and stop values to create numbered series without formulas.

Explore how to build nested if statements, use the and function for multiple conditions, and handle errors with the if error function in Excel's logical functions.

Add and manage comments in Excel to clarify data for readers and improve readability. Create and switch between custom views to tailor worksheets for clients or managers.

Learn to create and customize charts in Excel from a data table, using bar and 2d column charts; apply chart elements and filters to highlight January.

Explain date functions in Excel, including now, today, date value, and time value, and cover key mathematical functions such as abs, sign, sqrt, and mod for data calculations.

Rotate cell text with orientation and format cell alignment, then print efficiently by setting print areas, adjusting page layout, margins, orientation, and optional background images.

Learn to apply and customize headers and footers in Excel using the page layout tab, with left, center, and right sections for page numbers, date, and time in print preview.

Apply data validations in Excel via the data tab to enforce text length, show input messages, and use warning, stop, or inform alerts to prevent invalid entries.

Learn to record a macro in Excel, name and describe it, assign a shortcut, run it across sheets with relative referencing, save it in this workbook, and manage macros.

Explore creating and running macros with relative referencing in Excel, enable the developer tab, and edit macro code in the VBA editor to repeat actions across sheets.

Learn to write and run macros in Excel by recording, editing, and coding in VBA, using both front-end and back-end methods, with partial and full macro writing.

Discover how to create and use a name array in Microsoft Excel via the name box and defined names, access across sheets, and apply it in sum and counta.

Learn to use vlookup to search a value in a vertical table and return the related data. Explore the four parameters and exact versus approximate range lookup with practical examples.

Explore how the VLOOKUP approximate match parameter works, compare it with exact match, and learn its rules - ascending table order, left-to-right lookups, and the table array basics.

Master how to consolidate data in Excel across multiple sheets using the consolidate function, with static data consolidation and dynamic links to source data.

Explore Excel's count functions, including count, counta, and countblank, to tally numeric data, nonempty cells, and blanks with clear examples.

Learn how single criteria statistical functions in Excel—sumif, countif, and averageif—use criteria ranges and optional sum or average ranges to compute results based on conditions.

Explore how to use multiple criteria statistical functions in Excel, including sumifs, countifs, and averageifs, by combining multiple criteria with criteria ranges and data ranges.

Master index and match for precise lookups, including exact and conditional matches, and compare them with edge lookup and vlookup, hlookup, to handle vertical and horizontal tables.

Explore protection rules in Excel, learn how to lock and unlock cells, hide formulas, and protect worksheets and workbooks with passwords.

Learn to create hyperlinks in Excel using existing files or web pages, place links in the workbook, and add new document or email links with screen tips.

Master normal and advanced sorting in Excel, using major and minor criteria, color sorts, and custom sort options to organize dates, numbers, and text.

Learn to apply basic filters in Excel, distinguish filtering from sorting, use date, text, and number filters, and extract filtered data with copy-paste.

Master advanced filters in Excel to copy filtered data to another location. Define source data and criteria ranges, ensure headers match, and apply single or multiple criteria for precise results.

Create charts in Excel with keyboard shortcuts, then customize the y-axis and tick marks; adjust x-axis labels using select data for accurate year‑wise charts.

Learn to create and customize pie charts and combo charts in Excel, focus data, explode slices, hide data, add data labels, use secondary axes, and apply trend lines for forecasting.

Learn to create spark line charts in Excel to visualize a single data column using line, column, or win/loss styles, with high, low, first, and last points and axis limits.

Learn to create a pivot chart in Microsoft Excel, compare it to a normal chart, and analyze dynamic data through product, quantity, and sales with filters and sorting.

Learn to apply conditional formatting in Excel to highlight numbers, text, and dates using rules such as greater than, less than, between, equal to, and duplicate or unique values.

Learn how to apply conditional formatting in Excel to dates and numbers, using date occurrences, top/bottom rules, above/below average, and visual tools like data bars, color scales, and icon sets.

Master conditional formatting in Excel by using icon sets and cell icons, then customize data bars and color scales with min and max values for sorting insights.

Learn how to implement advanced conditional formatting with formulas in Excel, using a formula to determine which cells to format and highlighting matching records across columns or rows with criteria.

Discover how to customize pivot tables in Microsoft Excel by grouping by year and month, adjusting design and appearance, and applying filters for targeted insights.

Master pivot table customization in Excel by adjusting grand totals, report layouts, subtotals, item labels, blank rows, and field settings, then changing data sources and filters.

Master filtering pivot tables with item and year slicers, including multi-select and clear filters when headers are hidden. Customize slicer appearance, headers, and connections to multiple pivot tables.

Connect a single slicer to multiple pivot tables and use timelines to filter date data by month, year, or quarter, using report connections and copying pivot tables.

Create single and dependent dropdown lists in Excel using data validation and named ranges, then drive options with indirect, using country-city and leafy-roots examples.

Create a summary report in Excel using pivot tables or formulas to display total sales, item counts, and average sales per item.

Learn to connect Excel slicers to charts by converting data to a table, inserting a slicer for months, and filtering multiple charts dynamically.

Compare the data range and table in Excel, convert data to a table, and use the design tab to apply headers, filters, styles, and remove duplicates, with pivot table summaries.

Insert and link documents in Microsoft Excel using hyperlinks and the true objects feature, creating from file or new, embedding Word, PowerPoint, or Acrobat as icons or inline.

Discover how to insert and manage embedded objects in Excel, including PDFs, Word documents, and PowerPoint presentations, with options to link to file or display as icon.

Master 24 control shortcuts in Microsoft Excel, from select all to undo, including bold, copy, find, replace, flash fill, go to, insert table, and quick analysis.

Explore Microsoft Excel function keys from F1 to F12 to edit, navigate, and chart efficiently; learn F2 edit, F3 name range, F11 chart, and F12 save.

Explore alt key shortcuts and old key shortcuts in Excel 2016. Navigate file, home, insert, and data tabs, and learn copy, paste, cut, and shortcuts from previous versions.

Master shift plus function key shortcuts in Excel: shift-f2 for comments, shift-f3 for functions, shift-f5 for find, shift-f10 for context menu, shift-f11 new sheet, and shift-f12 save.

Master Ctrl plus function keys in Excel to hide or show the ribbon, access the print menu, define named ranges, manage windows, toggle between workbooks, and save worksheets.

Master alt and shift shortcuts in Microsoft Excel, including alt+down arrow for dropdown lists, alt+space for the control box, alt+enter for multiline cells, and shift+arrow or enter for navigation and selection.