Raymond TamJan 13, 20211 minPatient Health Questionnaire API in ExcelIn this video, we created a PHQ-9 questionnaire together with the scoring function in Excel. Once we have done that, we turn this model...
Raymond TamJan 5, 20211 minUnbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 3In 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...
Raymond TamDec 30, 20201 minUnbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 2In this video, we will continue building the Tic Tac Toe game in Excel with an unbeatable AI player with Excel Functions. We were using...
Raymond TamDec 22, 20201 minUnbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 1In 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...
Raymond TamDec 15, 20201 minOvercoming large number limitation in ExcelDo you know that Excel has limitations on supporting numbers that have over 15 digits? If you try to work with numbers with over 15...
Raymond TamDec 8, 20201 minHow to Build a Password Checker API in 5 Minutes using ExcelHave 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...
Raymond TamNov 18, 20201 minHow to Create a Real-Time Currency Converter API using ExcelEver 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...
Raymond TamOct 28, 20201 minBuild a Machine Learning Model API in ExcelHandwritten digit recognition is not something new, but what if the model is built using Excel? In this video, we will use the neural...
Raymond TamOct 13, 20201 minNumber to words in Excel and REST APIDo 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...
Raymond TamSep 25, 20201 minCreate a Product Price List API using Excel in 90 secondsEver wonder how to create a Product Price List API? What about turning your Excel price list into API? In this how-to tutorial, we will...
Raymond TamSep 8, 20201 minImport a text file into ExcelDid you try to import a text file into Excel before? Sound simple but there's much more to it than just copy and paste. In this how-to...
Raymond TamSep 4, 20201 minConvert Excel Workbook to REST API (Web service)Have you ever wanted to turn your Excel spreadsheets into a web service or REST API? AlchemyJ allows you to turn excel to API easily. The...
Raymond TamMay 21, 20204 minData Validation and Record MergingWe cannot ensure that everyone will submit data according to the requirement we've set and sometimes we are not sure if the records were...
Raymond TamMay 5, 20205 minPerform CRUD Operation on Excel - Part 2 of 2We will work on updating and deleting records in the database today with AlchemyJ. If you notice the pattern on both reading records and...
Raymond TamMay 3, 20206 minPerform CRUD Operation on Excel - Part 1 of 2This tutorial will show you how easy it is to perform CRUD operation to the database using AlchemyJ Our last post on executing SQL...
Raymond TamApr 30, 20203 minExecute SQL Statement in ExcelIn this tutorial, we will execute the SQL Statement in Excel using AlchemyJ. Before we begin, ensure you have your database installed....
Raymond TamApr 29, 20204 minGenerate OpenAPI (Swagger) Specification Automatically with AlchemyJIn 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...
Raymond TamApr 16, 20203 minHow to write your first API with AlchemyJThis tutorial is going to start you off on how to use AlchemyJ as a tool to build your business model and turn it into API afterward. In...