บทเรียน Excel

See how INDEX() and MATCH() are used to look up values within a table or range of cells Compare INDEX() and MATCH() to VLOOKUP().

Master Excel drop-down lists with step-by-step tips for setup, troubleshooting, and advanced techniques like cascading and searchable lists.

Learn how to convert numbers into formatted text in Excel using the TEXT() function. Customize dates, times, percentages, and more with format codes for clear, user-friendly spreadsheets.

Learn how to create a bar graph in Excel with this beginner-friendly guide. Explore chart types, formatting tips, dynamic features, and troubleshooting techniques.

Learn how to create a bar graph in Excel with this beginner-friendly guide. Explore chart types, formatting tips, dynamic features, and troubleshooting techniques.

Discover how to use the Excel UNIQUE() function to instantly remove duplicates and extract distinct values from any list. Learn how to apply it to both rows and columns.

Easily separate text into columns or rows in Excel using the TEXTSPLIT() function.

Learn how to seamlessly integrate Tableau with Excel to transform static spreadsheets into powerful, interactive dashboards. Boost insights, streamline analysis, and improve your data-driven decisions.

Learn how to use Excel’s MEDIAN() function to find the middle value in a dataset. Compare it with AVERAGE(), handle common quirks, and apply it your own work.

Learn how to use Python in Excel to run advanced analytics, create visuals, and apply machine learning within your existing spreadsheet workflows.

Calculate the last day of any month with Excel's EOMONTH() function. Use it to streamline financial schedules, reporting periods, and monthly workflows.

Unlock matrix multiplication in Excel with the MMULT() function. This guide explains how to use MMULT(), its syntax, and you will learn its applications in data analysis.