![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfCc7OmzyKkJhCR0amupU_jA2clTI3Au6sUu5KNLAliXrl7_IRO6UT2KY_aMiG4d8HkkEUKzql5-RRjusOlOeYI90HIns2ot5bzhZGCoRCSENgAyYI2yPWAojJ_IgZHpYTkaWfc?key=wdVubBjtEJnFJBrL7o-FEw\")
<\/figure>\n\nSigning up gives you a range of features that can be useful at work. You can try them out in the left-hand window of the website. <\/p>\n\n
The main functions of the tool:<\/p>\n\n
- \n
- Formula generation,<\/li>\n\n\n\n
- Data analytics,<\/li>\n\n\n\n
- The ability to embed the IoT Assistant into the applications you use (i.e. Excel or Spreadsheets).<\/li>\n<\/ul>\n\n
How do I use the formula generation function?<\/h3>\n\n
Click on \u201cGenerate now\u201d under \u201cGenerators\u201d in the left corner of the screen. In the newly opened corner, click on the green \u201cFormulas\u201d button. If you have clicked everything correctly, you should see the following window: <\/p>\n\n
<\/figure>\n\n
Click on the Excel button and select that you want to generate the formula (not interpret it). In this case, just describe the situation or problem you want to solve (or for which you want to generate an Excel formula”). <\/p>\n\n
For example, if we want to generate a formula to calculate the compound annual growth rate (CAGR) of a company, we present our situation in writing: \u201cCalculate the compound annual growth rate (CAGR) for values in column A, using\u201d investment duration \u201cin column B, restricted to entries from the current year in column C.\u201d<\/p>\n\n
<\/figure>\n\n
The answer we get is that we can simply plug it into our Excel spreadsheet and enjoy the precise functionality:<\/p>\n\n
<\/figure>\n\n
We can also get an explanation if the logic of the formula is questionable. Just click \u201cExplain it to me\u201d. So if the subtleties of Excel are harder for you to get to grips with – Formula Bot is a great helper. <\/p>\n\n
Airtable<\/h2>\n\n
“Airtable<\/a>is a platform that combines database, spreadsheet and collaboration software functions. It can be used for a wide range of tasks such as project management, contact databases, task lists, document management and more. Let’s take a look at some of the key components that help you manage your data more efficiently. <\/p>\n\n
Databases<\/h3>\n\n
<\/figure>\n\n
Bases are collections of tables that can be used for a specific purpose. “Airtable offers a range of pre-designed templates, such as “Content Calendar”, “Project Tracking” and “Event Planning”, which can be used to quickly create a database. In addition, bases can be customised and created completely from scratch, and can be stored in a folder on the computer containing an Excel file. <\/p>\n\n
Tables<\/h3>\n\n
<\/figure>\n\n
Tables form the basis of any base, so there may even be several of them. Each table, like the worksheets of a spreadsheet, contains information about a particular element. <\/p>\n\n
For example, a database for social media marketing could include Facebook, Instagram and Twitter tables. They represent the different platforms needed for successful social media marketing and each is different from the others. <\/p>\n\n
Fields<\/h3>\n\n
<\/figure>\n\n
Fields have a similar function to columns in a spreadsheet. Their data is presented in rows in a consistent manner. However, fields are more versatile than simple spreadsheet cells because they can store a variety of information such as file attachments, dates, pictures, checkboxes, etc. <\/p>\n\n
Recordings<\/h3>\n\n
<\/figure>\n\n
Entries are individual elements in the table. The number of entries depends on you, and can be dozens of creative tools or hundreds of customer feedback forms. No matter how many records you need, you can create as many as you need. <\/p>\n\n
Views<\/h3>\n\n
<\/figure>\n\n
Here are the different ways of displaying data. For example, a table with a list of tasks and their due dates, as well as the progress of each task, can be displayed in calendar or Kanban<\/em> format.<\/p>\n\n
The calendar view will provide an overview of the deadlines for each task and the Kanban<\/em> format will show the progress of each task.<\/p>\n\n
“Benefits of Airtable<\/h3>\n\n
- \n
- Collaboration: the app enables efficient task assignment and job sharing.<\/li>\n\n\n\n
- Spreadsheet-like interface: easy to use with attachments, text, checkboxes and links.<\/li>\n\n\n\n
- Templates: lots of ready-made templates to get your project started quickly. <\/li>\n\n\n\n
- Customisability: you can choose the visual elements you like (grid, Kanban<\/em>, calendar), etc.<\/li>\n\n\n\n
- Work automation with IoT<\/a>: automating repetitive tasks.<\/li>\n\n\n\n
- Real-time tracking: provides real-time tracking of changes to tables and records.<\/li>\n<\/ul>\n\n
SheetGPT<\/h2>\n\n
“SheetGPT<\/a>, a tool that allows you to integrate ChatGPT into Google Sheets and Excel to automate many data processing and analysis tasks. SheetGPT is particularly useful for data cleansing, SEO content creation, analytics and even social media content creation. A good solution for both business and personal use to process information faster and more efficiently.<\/p>\n\n
“SheetGPT works by installing its extension and is easy to use, as all you have to do is make a request like ChatGPT. And the tool is free. Find more free examples of IoT tools<\/a>. We will discuss more about how to use SheetGPT in future blogs.
Trying to understand all the subtleties of Excel or Spreadsheets when choosing THAT one formula can be extremely time-consuming, and what’s more, if you have to do a lot of…<\/p>\n","protected":false},"author":3,"featured_media":1882,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[],"class_list":{"0":"post-2536","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-di-in-practice"},"_links":{"self":[{"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/posts\/2536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/comments?post=2536"}],"version-history":[{"count":1,"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/posts\/2536\/revisions"}],"predecessor-version":[{"id":2537,"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/posts\/2536\/revisions\/2537"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/media\/1882"}],"wp:attachment":[{"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/media?parent=2536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/categories?post=2536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/whyai.lt\/en\/wp-json\/wp\/v2\/tags?post=2536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Work automation with IoT<\/a>: automating repetitive tasks.<\/li>\n\n\n\n