No-code platforms are tools that allow non-coders to develop software and apps. They exist to allow businesses to reduce the cost and timescales of deploying business applications.
If you're old enough to how a power user could develop business software using Microsoft Access, you can think of no-code as the modern day "Access" that works in the cloud.
Typically a no-code user can create tables and lookups, create data entry forms, reports and screens that show data. These can then be accessed by employees via the cloud or an app.
No-code can be considered as a significant step up from spreadsheets. A no-code solution can be less error prone and be easier to use for staff.
There is the question of whether staff should create no-code systems, or whether you should hire external experts. For example, if you're staff are busy building no-code apps, then who is generating revenue for your business?
The popularity of no-code means that there are no-code agencies emerging, so there should be no shortage of external help.
A lot of companies now claim to offer no-code solutions, jumping on the buzzword bandwagon. For example, Webflow could be seen as a no-code tool because you can build a website without code. However, before no-code became popular, Webflow was simply a cloud based CMS. This adds a little confusing to the no-code space, because so many are claiming to be a no-code provider.
Popular examples of what we would call "true" no-code providers include Mendix, Outsystems, Bubble, Adalo, GridFox and Microsoft PowerApps.
Overall, no-code tools are definitely worth experimenting with, either internally or via an external no-code consultancy. You could start by replacing a google sheet with a more usable and robust no-code app. Or you could prototype an idea using lo-code tools before involving an external app developer.