บทเรียน Excel

Learn how to automate repetitive Excel tasks with Excel macros. Create, use, and manage macros to boost productivity and transform your data workflows.

Discover how Excel's INDIRECT() function transforms text into live references. Learn how to use it for dynamic worksheets, stable cell references, named ranges, and more.

Discover how Excel tables go beyond formatting with powerful features like structured references, automatic expansion, filtering, and integration with PivotTables and charts.

Learn how to activate Excel’s built-in dark mode and create a fully dark spreadsheet experience. Discover tips and workarounds for reducing eye strain and creating a workbook that looks nice.

Learn two reliable methods for applying PivotTable conditional formatting and avoid common pitfalls.

Learn how to lock all or specific cells in Excel to prevent unwanted changes. Follow detailed steps to protect formulas, enable editing for selected users, and secure your worksheets with passwords.

Learn how to create, format, and customize Excel pie charts. Discover Excel pie chart options like doughnut charts, pie of pie charts, and exploded pie charts.

Learn how to use the MATCH() function in Excel to locate the position of a value within a range, including its syntax, use cases, and advanced techniques.

Master Excel’s sorting tools to organize your data with precision. Learn how to sort by values, colors, and custom lists for cleaner and smarter spreadsheets.

Build precise loan repayment tracking in Excel with clear formulas and calculations. Create a comprehensive amortization schedule to visualize how payments reduce your debt over time and plan your financial future.

Learn how to unprotect an Excel sheet with and without a password.

Discover how to calculate the compound annual growth rate (CAGR) in Excel. Learn practical applications and advanced techniques to enhance your data analysis skills.