บทเรียน Excel

Make large datasets easier to read with alternating row colors in just a few clicks.

Learn how to count non-blank cells in Excel using COUNTA(), COUNTIF(), COUNTIFS(), SUBTOTAL(), and SUMPRODUCT() with LEN().

Learn how the dollar sign locks cell references in Excel formulas so your calculations don't break when copied. Master the difference between relative, absolute, and mixed references.

Learn how to name ranges in Excel using three methods, understand naming rules and scope, manage names effectively, and apply best practices to make your formulas readable and maintainable.

Learn how to insert signatures in Excel using images, drawing, text, and digital certificates. This guide covers signature lines, anchoring and protection options, and fixes for common signature issues.

Learn how to use Excel Format Painter to copy formatting quickly, apply it across cells and sheets, and avoid common mistakes.

Learn how to create dependent drop-down lists in Excel using named ranges and dynamic arrays, fix common problems, best practices, and build error-free lists.

Learn how to add checkboxes in Excel for interactive to-do lists, trackers, and dashboards. This guide covers native and legacy methods, formulas, and conditional formatting.

Learn how to use Find and Replace in Excel to clean data, fix errors, and make bulk changes without breaking formulas or formatting.

Learn how to use AutoSum in Excel to quickly sum columns and rows. This guide covers shortcuts, common functions, troubleshooting, and working with filtered data.

A beginner-friendly guide to using Claude inside Excel. You’ll learn what it actually does, where it's most helpful, and how to use it safely in real spreadsheets without breaking anything.

Understand how Excel gridlines work, when they appear, and how they are different from borders. Learn to create clear worksheets on screen and in print.