บทเรียน Excel

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.

Discover simple ways to insert bullet points in Excel using keyboard shortcuts, formulas, symbols, and formatting tricks. Learn how to create clean, organized lists even inside a single cell.

Discover how to perform a sensitivity analysis in Excel, a popular “what-if” method used to identify the most relevant inputs in a model outcome.

Learn how to use the Fill Handle in Excel to copy formulas, extend data patterns, customize AutoFill options, and troubleshoot common issues with step-by-step guidance and examples.

Learn different methods to rearrange your spreadsheet by moving single or multiple columns in Excel. Discover practical shortcuts, hidden tricks, and expert tools to speed up your workflow.