Patient Health Questionnaire API in Excel
In this video, we created a PHQ-9 questionnaire together with the scoring function in Excel. Once we have done that, we turn this model...
top of page
Search
Raymond Tam
- Jan 5, 2021
- 1 min
Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 3
In this video, we will explain how we get the different states (winning, draw, losing) we use or pattern matching in the Tic Tac Toe game...
107 views0 comments
Raymond Tam
- Dec 30, 2020
- 1 min
Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 2
In this video, we will continue building the Tic Tac Toe game in Excel with an unbeatable AI player with Excel Functions. We were using...
63 views0 comments
Raymond Tam
- Dec 22, 2020
- 1 min
Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 1
In this video, we will build a Tic Tac Toe game in Excel with an unbeatable AI player with Excel Functions. We will also use AlchemyJ...
217 views0 comments
Raymond Tam
- Dec 15, 2020
- 1 min
Overcoming large number limitation in Excel
Do you know that Excel has limitations on supporting numbers that have over 15 digits? If you try to work with numbers with over 15...
55 views0 comments
Raymond Tam
- Dec 8, 2020
- 1 min
How to Build a Password Checker API in 5 Minutes using Excel
Have you tried to build a password checker before? How long do you need to build a working API for password checker? In this how-to...
58 views0 comments
Raymond Tam
- Dec 3, 2020
- 1 min
Excel IF, IFS, SWITCH Function - A Subtle Difference
IF and IFS function in Excel are very useful decision-making functions. Do you know that IF and IFS function work differently? Although...
104 views0 comments
Raymond Tam
- Nov 18, 2020
- 1 min
How to Create a Real-Time Currency Converter API using Excel
Ever wonder how to create a real-time currency converter API using Excel? In this video, we will see how to create a REST API that...
155 views0 comments
Raymond Tam
- Oct 28, 2020
- 1 min
Build a Machine Learning Model API in Excel
Handwritten digit recognition is not something new, but what if the model is built using Excel? In this video, we will use the neural...
116 views0 comments
Raymond Tam
- Oct 13, 2020
- 1 min
Number to words in Excel and REST API
Do you know you can convert numbers to words in Excel without the use of VBA and macros? We can convert numbers to words with a formula...
617 views0 comments
Raymond Tam
- May 5, 2020
- 5 min
Perform CRUD Operation on Excel - Part 2 of 2
We will work on updating and deleting records in the database today with AlchemyJ. If you notice the pattern on both reading records and...
93 views0 comments
Raymond Tam
- May 4, 2020
- 6 min
Perform CRUD Operation on Excel - Part 1 of 2
This tutorial will show you how easy it is to perform CRUD operation to the database using AlchemyJ Our last post on executing SQL...
3,386 views0 comments
Raymond Tam
- Apr 30, 2020
- 3 min
Execute SQL Statement in Excel
In this tutorial, we will execute the SQL Statement in Excel using AlchemyJ. Before we begin, ensure you have your database installed....
188 views0 comments
Raymond Tam
- Apr 29, 2020
- 4 min
Generate OpenAPI (Swagger) Specification Automatically with AlchemyJ
In this tutorial, I'm going to show you how you can enable OpenAPI (Swagger) from API generated by AJ For this tutorial, we are going to...
1,774 views0 comments
bottom of page