Instructor-led IT courses across web, mobile, data, design and more.
The graphics organisations use every day, from logos, icons, business cards and brochures to product labels and social media illustrations, need to stay sharp at every size and be easy to edit. Adobe Illustrator creates vector artwork that scales without…
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 people can write basic Python but stay stuck with short scripts. When they need programs that run several tasks at once, talk over a network, send email, store data in a database or share code with a team, they are no longer sure how to write them.…
Once a Django site has real users, more data and several roles using it, the work changes from making pages work to making the system fast, secure, finely permissioned and easy to maintain. Django has built-in tools for all of this, from caching, sessions,…
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,…
Advertising banners are something marketing teams and business owners make almost every week: website banners, social media ads, Stories images and promotions for chat channels. Each channel needs a different size and aspect ratio, the copy has to be readable…
Today's web applications need to respond quickly, feel as smooth as a mobile app and be easy to extend as the system grows. React is one of the most widely used libraries for building user interfaces because it splits a page into reusable components, and it…
RESTful APIs are the main way mobile apps, single-page web apps and other systems talk to a back end. A good API needs careful thought about endpoint structure, JSON format, validation, error handling, security and testing. Laravel provides tools for all of…
Building an online shop yourself involves more detail than most people expect: a storefront where products are easy to find, a cart that always adds up, a checkout that never gets stock wrong, online payments, and a back office where the owner manages…
Web applications keep getting more complex. Writing everything in plain PHP often leads to duplicated code, no structure the whole team understands, and rebuilding the basics such as login, form validation and security for every project. Laravel is a widely…
PHP still powers a large share of the web, but the language has changed a great deal from PHP 8.0 to PHP 8.5, the current release, with shorter syntax, a stricter type system, enums, readonly properties, property hooks and the pipe operator. Meanwhile every…
Many organisations still use Crystal Reports every day for invoices, receipts, sales reports and reports from ERP or accounting software. Common tasks include fixing reports that someone designed long ago, adding conditions users can choose themselves, or…
Exchange Server 2016 and 2019 reached the end of support on 14 October 2025, so organisations that want to keep email on their own servers need to move to Exchange Server Subscription Edition (SE), the only version that still receives regular security updates…
PostgreSQL has become the main database for many organizations, both for new systems and for systems migrated from Oracle, SQL Server or MySQL. Getting it installed and running is only the start. What keeps a system alive is tuning it for the hardware,…
