Posted by
Andy Brown
on 14 August 2025
In this video you will learn how to choose between AI tools like ChatGPT, Claude and Copilot, as well as the importance of writing effective prompts
Posted by
Andy Brown
on 15 August 2025
In this video you'll learn about what sort of prompts give good and bad results in AI tools. You'll then learn using the COARSE acronym to help you write good prompts, and you'll be able to follow a couple of case studies in creating good prompts.
Posted by
Andy Brown
on 15 August 2025
In this video you'll learn how to have conversations with your AI tools, including repeating questions, pausing responses and initiating Q&A conversations.
Posted by
Andy Brown
on 18 August 2025
In this video you'll learn about providing different inputs to AI tools like ChatGPT, including images, PDF files, Office 365 documents (such as Excel workbooks) and spoken word instructions.
Posted by
Andy Brown
on 18 August 2025
In this video you'll explore some of the ways in which you can get output from your favourite AI assistant (whether this be ChatGPT, Claude, Copilot, Gemini or any other) including as bulleted lists, tables, images, in HTML or JSON format, or even as poetry or song!
Posted by
Andy Brown
on 19 August 2025
This video explains why (sadly) you can never hope to fully understand how AI tools like ChatGPT, Copilot, Gemini and Claude work, while going through concepts like tokens and embedding which are comprehensible! The video then looks at some of the problems AI tools all share, before finishing by showing how you can tweak the temperature and Top P values for your queries (and what these two concepts mean).
Posted by
Andy Brown
on 20 August 2025
In this video you'll learn how to use placeholders and variables to make your prompts reusable, and how to save prompt templates to avoid continually reinventing the same ChatGPT, Claude, Copilot or Gemini AI wheel.
Posted by
Andy Brown
on 15 September 2025
This video shows how (as is often the case) your favourite AI tool is capable of so much more than you might have expected. Not only can the likes of ChatGPT translate instantly and flawlessly between any pair of languages (including computer programming ones), but you can also speak to an AI tool in any language (and have it tactfully correct your errors).
Posted by
Andy Brown
on 16 September 2025
This tutorial shows 3 less obvious ways in which you can use AI tools like ChatGPT, Copilot or Claude more efficiently. "Few-shot prompting" allows you to ask questions by giving examples; "Recursive criticism" allows you to get an AI tool to improve its own answers; and "Prompt refinement" will let you get an AI tool to generate questions to ask it.
Posted by
Andy Brown
on 17 September 2025
This tutorial shows how you can create images using your favourite AI tool (including a review of which tool that should be, such as ChatGPT, Firefly, Gemini or Midjourney). The tutorial shows how you can specify the size and style of your image (and how you can use inpainting to make changes to part of it once it's created) before finishing with a quick look at video generation using ChatGPT's Sora facility.
Posted by
Andy Brown
on 17 September 2025
This tutorial shows how you can get AI tools like ChatGPT. Gemini, Claude or Copilot to generate the HTML and CSS needed for web pages, as well as how you can debug problems with HTML, CSS and client scriopt like JavaScript and JQuery.
Posted by
Andy Brown
on 18 September 2025
This tutorial shows how you can use AI tools like ChatGPT, Claude, Gemini and Grok as assistants to help you to write, debug, improve and reformat code. The tutorial is careful to show both the pros and cons of using AI as a programming assistant when you're coding in Excel VBA.
Posted by
Andy Brown
on 22 September 2025
If you spend any time programming in Python, enlisting the help of an AI tool like ChatGPT, Copilot, Gemini or Claude will save you huge amounts of time. This tutorial shows how to install Python (for new users), then how to use AI tools to write, debug, refactor and critique code, before ending by showing how you can use AI to help you pick the right modules to import and use.
Posted by
Andy Brown
on 26 September 2025
AI tools are made for writing and tidying up SQL. Even without knowing your underlying database structure, tools like ChatGPT and Claude can help you to format and generate SQL queries, but you can also choose to share your database schema with your AI tool to give it the ability to write perfect queries interrogating your database. This tutorial shows how you can use AI tools to format, generate, debug and optimise your SQL queries and stored procedures.
Posted by
Andy Brown
on 27 September 2025
As this tutorial shows, Copilot 365 allows you to include 365 data in your search results. So you can analyse the posts in Teams channels, review your emails or produce insights on your Excel data without worrying about whether you're running the risk of your data leaking.
Posted by
Andy Brown
on 29 September 2025
This tutorial shows how you can create custom GPTs in ChatGPT dedicated to answering specific types of questions. Examples might include a GPT to recommend courses of action based on a set of procedures you've uploaded, a GPT to facilitate a particular task (like converting a file or writing a query in SQL) or a frivolous GPT to give sarcastic answers to any question!
Posted by
Andy Brown
on 19 September 2025
ChatGPT agent mode is (as this tutorial explains) like having your personal robotic assistant on hand 24/7. Not only can agent mode spend up to an hour researching topics on your behalf, it can even book flights, make purchases and send emails (given permission).
