Instructor-led IT courses across web, mobile, data, design and more.
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…
Windows 10 reached the end of support in October 2025, so most IT teams now look after Windows 11 machines first and foremost. Windows 11 itself changes quickly, with new features arriving in monthly updates, an annual release such as version 26H2, and older…
Many presentations are still built as if PowerPoint were an overhead projector: slides full of text, every slide formatted by hand, and the whole file reworked whenever a colour or font has to change. That wastes time, leaves slides looking inconsistent and…
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…
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…
Once Microsoft Teams becomes the main way an organisation works, administrators must be able to say who can create teams, who can record meetings, what people outside the organisation can reach and why some meetings have choppy audio. Leaving the defaults in…
Many organisations use Microsoft 365 every day yet still email attachments back and forth, keep documents on individual laptops and hold online meetings without knowing where the recording or the summary ends up. The result is several versions of the same…
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…
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…
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…
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…
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…
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…
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,…
As an Access database grows, jobs that used to be done step by step become repetitive and error-prone, several users change the design by accident, and a single file shared on the network risks being damaged. Macros and VBA let Access work automatically,…
Once you can build tables, relationships and queries in Access, the next job is making the database easy for others to use and producing results that are ready to print. Forms created by a wizard rarely fit the work, you cannot enter data for several tables…
A good presentation is not measured by how many effects it has, but by how quickly the audience understands the message. Many people have used PowerPoint for years and still lose time aligning text slide by slide, find their Thai fonts change on another…
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…
Most office paperwork is the same kind of document produced again and again, such as external letters, internal memos, announcements, orders, letters to customers and approval forms. Yet many organisations still copy an old file and edit it, press the space…
Many people can already build a plan in Microsoft Project, but the plan stops being useful once the project is under way. Dates do not move when work slips, one person ends up with more work than hours, nobody knows which tasks are on the critical path, and…
Planning a project on paper or in an Excel sheet works while the project is small. Once there are dozens of tasks that depend on one another, several people responsible and a budget to control, moving a single task means correcting dates across the whole…
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…
Word, Excel and PowerPoint are still the core tools of office work, yet many people use them the way they learnt on old versions of Office: spacing documents out with the space bar, working sums out on a calculator and typing the answers into a table, and…
