บทเรียน Excel

Master the `SEQUENCE()` function to supercharge your spreadsheet skills. Learn how to create dynamic lists, automate calculations, and unlock new Excel possibilities.

Learn how to insert a check mark in Excel using symbols, shortcuts, formulas, and checkboxes. Discover formatting tips, automation tricks, and counting techniques for efficient spreadsheet tracking.

Master Excel time formulas to calculate durations, handle time over 24 hours, and format time values for clear, accurate reporting.

Learn how Excel's wildcard characters enhance flexibility in search, replace, and formula logic. Discover practical examples using *, ?, and ~ in filtering, VLOOKUP(), and more.

Learn how to read, write, and style Excel files using openpyxl. Discover practical examples for working with modern Excel formats (.xlsx) and advanced features.

Learn how the SUBTOTAL() function dynamically summarizes filtered or grouped data. Understand its syntax, explore practical examples, and compare it with similar functions.

Discover XMATCH, a powerful Excel function to find the relative position of an item that matches a specified value.

Say goodbye to complex nested IF() logic. Learn how to build readable formulas using the IFS() function instead.

Learn why the #NAME? error occurs in Excel formulas and discover practical steps to troubleshoot, fix, and prevent it for smoother spreadsheet workflows.

Learn how to add numbers in Excel using built-in tools. Explore multiple methods for quick calculations, including formulas, keyboard shortcuts, and table formatting.

Learn how to divide numbers, cells, and columns in Excel using simple formulas and tools. Discover how to handle errors, use functions like QUOTIENT and MOD, and ensure results sum to whole numbers when needed.

Learn how to speed up your work in Excel with Flash Fill. Discover practical examples, usage tips, limitations, and troubleshooting strategies to get the most out of this smart feature.