--- id: video/eDi32pS8eMo type: video title: Use a reporting skill to create complex Spreadsheets in Business Central (Advanced Spreadsheets) summary: "Advanced Spreadsheets and Reporting app for Business Central: AI reporting skills let an agent build dashboards in spreadsheets connected to BC data. The app includes 15 generic skills, is free in a sandbox, and needs your own API key (ChatGPT, Claude or others) for the agent." tier: community language: en tags: - advanced spreadsheets - reporting skills - ai agent - dashboard - templates - bring your own key - executive summary system: reporting review: state: reviewed by: opus at: "2026-10-07T23:18:26.239Z" flags: [] generated: at: "2026-10-07T23:18:26.281Z" pipeline: 0.2.0 prompts: extract-video: 1 summarize-video: 2 input_hash: 0ba7415ce586bd63ca4d784554219d7a0eb65d2f7c4cb2b7860cda8b25a6fbda evidence: - kind: video url: https://www.youtube.com/watch?v=eDi32pS8eMo&t=13s title: Use a reporting skill to create complex Spreadsheets in Business Central (Advanced Spreadsheets) date: "2026-09-21T19:14:15.000Z" commit: null t: 13 quote: here is the advanced spreadsheets and reporting app for Business Central, which is an app where you build spreadsheets that are connected with Business - kind: video url: https://www.youtube.com/watch?v=eDi32pS8eMo&t=37s title: Use a reporting skill to create complex Spreadsheets in Business Central (Advanced Spreadsheets) date: "2026-09-21T19:14:15.000Z" commit: null t: 37 quote: now with ai what we actually use is something called a skill and the skill is let me show you is a - kind: video url: https://www.youtube.com/watch?v=eDi32pS8eMo&t=47s title: Use a reporting skill to create complex Spreadsheets in Business Central (Advanced Spreadsheets) date: "2026-09-21T19:14:15.000Z" commit: null t: 47 quote: the app comes built with I think there's 15 different generic skills, uh executive summaries, a GL exception dashboard, driver bi uh ratio dashboard, - kind: video url: https://www.youtube.com/watch?v=eDi32pS8eMo&t=75s title: Use a reporting skill to create complex Spreadsheets in Business Central (Advanced Spreadsheets) date: "2026-09-21T19:14:15.000Z" commit: null t: 75 quote: You can build your own skill. You can go in and you can edit uh the bundle skills here to to fit what you - kind: video url: https://www.youtube.com/watch?v=eDi32pS8eMo&t=161s title: Use a reporting skill to create complex Spreadsheets in Business Central (Advanced Spreadsheets) date: "2026-09-21T19:14:15.000Z" commit: null t: 161 quote: the agent is is working with the spreadsheet just as you would links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] video_id: eDi32pS8eMo channel: yt-hougaard source_name: Erik Hougaard url: https://www.youtube.com/watch?v=eDi32pS8eMo published_at: "2026-09-21T19:14:15.000Z" duration_s: 302 captions: derived audience: - functional consultant - administrator - end user - decision maker chapters: - t: 0 title: Introduction to advanced spreadsheets and reporting app - t: 37 title: Skills concept and built-in templates - t: 99 title: Creating a new spreadsheet with the agent - t: 161 title: Watching the agent build the dashboard - t: 228 title: Preview and modern templating approach - t: 259 title: How to access and use the app features: - name: Advanced Spreadsheets and Reporting App status: unclear t: 13 verified: false status_source: video - name: AI-powered Reporting Skills status: unclear t: 37 verified: false status_source: video - name: Built-in Skill Templates status: unclear t: 47 verified: false status_source: video - name: Agent-driven Spreadsheet Building status: unclear t: 112 verified: false status_source: video - name: Bring Your Own Key Support status: unclear t: 275 verified: false status_source: video objects_mentioned: [] quotes: - t: 13 text: here is the advanced spreadsheets and reporting app for Business Central, which is an app where you build spreadsheets that are connected with Business check: exact - t: 37 text: now with ai what we actually use is something called a skill and the skill is let me show you is a check: fuzzy - t: 47 text: the app comes built with I think there's 15 different generic skills, uh executive summaries, a GL exception dashboard, driver bi uh ratio dashboard, check: exact - t: 75 text: You can build your own skill. You can go in and you can edit uh the bundle skills here to to fit what you check: exact - t: 161 text: the agent is is working with the spreadsheet just as you would check: exact --- # Use a reporting skill to create complex Spreadsheets in Business Central (Advanced Spreadsheets) > Advanced Spreadsheets and Reporting app for Business Central: AI reporting skills let an agent build dashboards in spreadsheets connected to BC data. The app includes 15 generic skills, is free in a sandbox, and needs your own API key (ChatGPT, Claude or others) for the agent. [Watch on YouTube](https://www.youtube.com/watch?v=eDi32pS8eMo) · Erik Hougaard · 2026-09-21 · 5:02 · tier community · reviewed (checked by Opus) ## Overview Erik Hougaard demonstrates the Advanced Spreadsheets and Reporting app for Business Central, where spreadsheets are connected to Business Central data. Instead of saving templates manually, users pick a skill, which is a set of instructions for the AI, and say what the report should contain. The demo creates a new spreadsheet with the agent and shows it building a dashboard with KPI boxes, financial charts and analysis sections. The agent works with the spreadsheet the way a user would. The video closes with how to get and use the app, including the bring your own key requirement. ## Key points - The app builds spreadsheets connected with Business Central data. - It ships with about 15 generic skills, including executive summaries, GL exception dashboard, ratio dashboard, budget versus actual and benchmarking dashboards. - A skill is a set of instructions for the AI to build a report or dashboard; you no longer necessarily have to save a template, though templates are still supported. - You can build your own skills or edit the bundled skills to fit your needs. - You can give the agent specific instructions or let it use the skill defaults. - The demo shows the agent building an executive summary dashboard with KPI boxes, revenue actual versus budget, a profit bridge, financial position and an analysis section. - The app is free to use in a sandbox. ## Chapters - [0:00](https://www.youtube.com/watch?v=eDi32pS8eMo&t=0s) Introduction to advanced spreadsheets and reporting app - [0:37](https://www.youtube.com/watch?v=eDi32pS8eMo&t=37s) Skills concept and built-in templates - [1:39](https://www.youtube.com/watch?v=eDi32pS8eMo&t=99s) Creating a new spreadsheet with the agent - [2:41](https://www.youtube.com/watch?v=eDi32pS8eMo&t=161s) Watching the agent build the dashboard - [3:48](https://www.youtube.com/watch?v=eDi32pS8eMo&t=228s) Preview and modern templating approach - [4:19](https://www.youtube.com/watch?v=eDi32pS8eMo&t=259s) How to access and use the app ## Features | Feature | Status | At | |---|---|---| | Advanced Spreadsheets and Reporting App | status not stated, demoed | [0:13](https://www.youtube.com/watch?v=eDi32pS8eMo&t=13s) | | AI-powered Reporting Skills | status not stated, demoed | [0:37](https://www.youtube.com/watch?v=eDi32pS8eMo&t=37s) | | Built-in Skill Templates | status not stated | [0:47](https://www.youtube.com/watch?v=eDi32pS8eMo&t=47s) | | Agent-driven Spreadsheet Building | status not stated, demoed | [1:52](https://www.youtube.com/watch?v=eDi32pS8eMo&t=112s) | | Bring Your Own Key Support | status not stated | [4:35](https://www.youtube.com/watch?v=eDi32pS8eMo&t=275s) | ## Quotes - [0:13](https://www.youtube.com/watch?v=eDi32pS8eMo&t=13s) "here is the advanced spreadsheets and reporting app for Business Central, which is an app where you build spreadsheets that are connected with Business" - [0:37](https://www.youtube.com/watch?v=eDi32pS8eMo&t=37s) "now with ai what we actually use is something called a skill and the skill is let me show you is a" - [0:47](https://www.youtube.com/watch?v=eDi32pS8eMo&t=47s) "the app comes built with I think there's 15 different generic skills, uh executive summaries, a GL exception dashboard, driver bi uh ratio dashboard," - [1:15](https://www.youtube.com/watch?v=eDi32pS8eMo&t=75s) "You can build your own skill. You can go in and you can edit uh the bundle skills here to to fit what you" - [2:41](https://www.youtube.com/watch?v=eDi32pS8eMo&t=161s) "the agent is is working with the spreadsheet just as you would" ## Disclaimers in the video - [4:35](https://www.youtube.com/watch?v=eDi32pS8eMo&t=275s) other: The app is free to use in a sandbox. In order to use the agent, you have to bring your API key from ChatGPT or Claude or whatever is your taste Presenters (as heard): Eric.