ภัทร์วดี มาศภูมิ
ปริญญาตรี คณะวิทยาการคอมพิวเตอร์ มหาวิทยาลัยราชภัฏธนบุรี
Profile (PDF)Joined IT Genius Institute: 01 กุมภาพันธ์ 2563
Many teams still track work in Excel files passed around by email or chat groups, so nobody knows who holds which task, what is nearly due or what has been stuck for weeks. Organisations on Microsoft 365 already have Microsoft Planner, and Planner now brings…
Many organisations already have SharePoint as part of Microsoft 365, and every team created in Microsoft Teams comes with its own SharePoint site. Yet most sites are still just a place to keep files, with no home page that speaks to the team, no central lists…
Numbers in Excel are only valuable when readers can understand them and make decisions from them. Many people calculate correctly but still cannot answer the key questions: what happens to profit if sales rise by 10 per cent, what next quarter is likely to…
Many organisations keep sales, budget and register data in Excel, but when they try to report on it in Power BI they find several subjects crammed into one sheet, merged cells, numbers stored as text, dates mixing Buddhist and Gregorian years, and fixes that…
Video has become a core medium for organisations and businesses, from product clips and promotional videos to teaching materials and vertical clips for social media. Yet many beginners can only string clips together: sound levels jump around, there are no…
Once you are made a Microsoft 365 administrator for your organisation, the work ranges from adding users and licences, syncing accounts from Active Directory and configuring email, Teams and SharePoint, to handling the calls when users cannot send email,…
Executives have limited time and must decide from a great deal of data. A good report states its conclusion from the first slide and uses figures and charts as evidence that can be understood in a few seconds. Yet many reports are still full-page tables of…
A good diagram helps a team understand a process, an organisation structure, a database or a network at a glance. Yet many people still draw diagrams line by line in PowerPoint or Excel, so changing one step means redrawing the lines, the symbols are not…
Many organisations still have documents scattered across staff laptops, email attachments and folders where nobody knows which copy is the latest. After moving to Microsoft 365, many teams are still unsure which files belong in OneDrive and which belong in…
Collecting feedback, registrations or test results on paper, or in files emailed back and forth, wastes time gathering and retyping data. Microsoft Forms lets you build surveys, quizzes and polls in minutes. People can answer on a computer or a phone, results…
Preparing data in Excel often takes longer than the analysis itself: copying sales files from several branches together, trimming spaces and fixing dates column by column, or turning a report exported from another system into a proper table, and then doing it…
Data teams in many organisations still work across scattered tools: raw data lives in one place, ETL jobs in another, the data warehouse in a third system, and Power BI reports pull the same data again and again. The result is conflicting copies of data,…
Email and calendars are still the tools people use most at work, yet many people use Outlook only to send and receive mail. Inboxes fill up with thousands of messages, mail is sorted by hand every morning, old messages cannot be found and meetings are booked…
Many organisations have switched on Microsoft 365, yet most staff still use only email, Word and Excel the old way. Files travel back and forth as attachments, several versions get mixed up, meetings are arranged in private chats, and people are unsure…
Excel is used in almost every job, from keeping lists and working out expenses to summarising monthly sales, yet many users still retype figures by hand, copy formulas that give wrong results or spend too long setting up pages for printing. Getting the…
Sales and online marketing produce new data every day: sales by product, sales by channel, advertising spend and how many visitors become buyers. That data only helps decisions when it is shown as charts that answer the right question. Many people can create…
Reports that must be updated every week or month often eat up time copying data, rebuilding summary tables and redrawing charts, while managers still have to open several sheets to see the big picture. A dashboard brings the key figures, charts and filters…
Many organisations keep their core data in Excel, from customer and product registers to staff records and sales. As the data grows and several people enter it, the same problems keep appearing: numbers stored as text, duplicates, inconsistent spelling,…
Once you can write basic macros, real work soon gets harder. Data runs to tens of thousands of rows, so macros that loop cell by cell become slow; files have to be combined from many folders; totals must be summarised by unique customer code; PivotTables and…
Plenty of office work in Excel is repeated every day or every week: opening files from several departments, copying data into one place, filtering the rows you need, saving a new file and emailing it to your manager. It takes time and invites mistakes, yet…
