ว่าที่ พ.ต. ณัฐศิระ เยาวสุต
ปริญญาตรี คณะศึกษาศาสตรบัณฑิต มหาวิทยาลัยเชียงใหม่
Profile (PDF)Joined IT Genius Institute: 01 กุมภาพันธ์ 2563
Many Excel tasks are repeated every day or every month: opening a text file exported from a database system, filling in blank cells, filtering and sorting, copying between files, then summarising with a PivotTable and printing only the records you need. Doing…
Many organisations start keeping data in Excel because it is easy, but as the data grows and more people need it, they run into duplicates, inconsistent entries, several versions of the same file and reports that have to be compiled by hand every month.…
Many organisations keep product, customer or supplies records in Excel, but as the data grows the same problems keep appearing: codes lose their leading zeros, text and numbers are mixed together, filtering on several conditions means clicking through one box…
People who use Excel every day tend to hit the same problems again and again. Frequently used commands take several clicks, codes starting with zero lose their zeros, numbers turn into dates, formulas disagree with the calculator, colleagues enter unrealistic…
People who use Word every day tend to hit the same problems again and again. The keyboard switches language when they press Enter, English text comes out larger than Thai, pressing Tab twice indents the whole paragraph, numbering refuses to restart, a blank…
Reports, theses, textbooks and manuals are long documents that must follow strict formatting rules: margins, fonts, chapter numbering, headers that change from chapter to chapter, separate page numbering for the front matter and the main text, a table of…
Once the macros you write are used by several people, the problems change. Users accidentally delete or edit macros, code has to be copied into every file, there is no easy menu to run it, and data still has to be copied from Excel into Word or PowerPoint by…
Once employee, customer or product records in Excel run to thousands of rows, work that used to be done by hand becomes slow and error-prone, such as calculating length of service and overtime, looking up data across tables, summarising totals on several…
