Blog | AlchemyJ

All Posts
News
How-to
AJXF

3 days ago
1 min

Basic Excel Function - How to use Concatenate and Concat Function in Excel

How to use the Concatenate Function in Excel? There are 2 methods of doing it. If you are using Excel 2013 or 2016, there is only...

20 views0 comments

Basic Excel Function - How to use Average Function in Excel

celsiushb.tan

Apr 9
1 min

Basic Excel Function - How to use Average Function in Excel

I'll teach you how to calculate average in Excel. This function enables you to calculate the average value of any set of numbers.

29 views0 comments

Basic Excel Function - How to use Sum Function in Excel

celsiushb.tan

Mar 30
1 min

Basic Excel Function - How to use Sum Function in Excel

There are 2 ways of using Sum Function in Excel. 1) You can add values individually. 2) You can add values in ranges. Let me show you how...

36 views0 comments

Self Assessment - Can you be an Amazon Web Development Engineer?

celsiushb.tan

Mar 13
1 min

Self Assessment - Can you be an Amazon Web Development Engineer?

Are you part of the Amazon Ecosystem that use their product or services daily and was thinking to join Amazon to improve their Web...

19 views0 comments

Self Assessment - Are you an advance Excel user?

celsiushb.tan

Mar 5
1 min

Self Assessment - Are you an advance Excel user?

Microsoft Excel can execute both straightforward and sophisticated mathematical equations and functions. The basic function includes data...

55 views2 comments

Self Assessment - Are you a good programmer?

celsiushb.tan

Feb 26
1 min

Self Assessment - Are you a good programmer?

Being a good programmer is not just about writing error-free codes. Other intangible traits defer an good programmer to other average...

15 views0 comments

celsiushb.tan

Feb 19
1 min

Self Assessment - Is coding for you?

Coding is not complicated, with open online course platform like "Udemy","Coursera" and "YouTube" anyone can learn and pick-up coding....

22 views0 comments

Self Assessment - Can you be a Google software engineer?

celsiushb.tan

Feb 15
1 min

Self Assessment - Can you be a Google software engineer?

If you ever dreamt of being a Google software engineer, try this simple self-assessment Excel API "#AlchemyJ" today and check if you...

28 views0 comments

Self Assessment Tool - How Attractive Are You?

celsiushb.tan

Feb 5
1 min

Self Assessment Tool - How Attractive Are You?

Being attractive is not merely based on the physical appearance of an individual. Attributions such as your other four senses " hearing,...

41 views0 comments

Self Assessment - How Healthy is your Diet

celsiushb.tan

Jan 29
1 min

Self Assessment - How Healthy is your Diet

A poor diet does not just make you look out of shape but also increases the chance of developing health diseases, such as Cardiovascular...

29 views0 comments

Self Assessment - How Successful will You be in Life

celsiushb.tan

Jan 22
1 min

Self Assessment - How Successful will You be in Life

Do you know how well Elon Musk and Steve Jobs spend their time is a pointer to their great achievements and have you wondered if you will...

27 views0 comments

Patient Health Questionnaire API in Excel

Raymond Tam

Jan 13
1 min

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...

63 views0 comments

Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 3

Raymond Tam

Jan 5
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...

26 views0 comments

Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 2

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...

42 views0 comments

Unbeatable Tic Tac Toe AI in Excel (with No VBA) - Part 1

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...

62 views0 comments

Overcoming large number limitation in Excel

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...

21 views0 comments

How to Build a Password Checker API in 5 Minutes using Excel

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...

43 views0 comments

Excel IF, IFS, SWITCH Function - A Subtle Difference

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...

61 views0 comments

How to Create a Real-Time Currency Converter API using Excel

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...

65 views0 comments

Introducing the New AlchemyJ Excel Library

Raymond Tam

Nov 10, 2020
1 min

Introducing the New AlchemyJ Excel Library

We would like to introduce you to our latest addition to the AlchemyJ family, the AlchemyJ Excel Library. AlchemyJ allows you to create...

150 views0 comments

{"items":["60797164a5458f0057adab36","607010544225eb0015357cf8","6062edac13b2d80015be0aed","604c2963c4c7dc0057c1336f","60421501b49d6d00575a7a3d","6038d67deab36c001700b765","602f31bb250dcd00179c33c7","6029f80c1dc084005ac84e49","601d2c99c8e5aa001757574e","6013d2a5024f150017c39f80","600aa04522048700179addec","5ffec84c0aad3f0017d69e98","5ff3f8d7179c130017a6ed1a","5febd466e26e510017a17304","5fe171091b6016001746a101","5fd82298fab4510017b4c871","5fcdd7a4b315770017202c6d","5fc89e0836189f001710ba42","5fb485cc2eb0d50017367257","5fa5170f7d785b001759353d"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"fill","cubeRatio":1.3333333333333333,"isVertical":true,"gallerySize":30,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":32,"galleryMargin":0,"scatter":0,"rotatingScatter":"","chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":1,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCropRatios":"","columnWidths":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":1,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":1,"mobilePanorama":false,"placeGroupsLtr":true,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"bottomInfoHeight":0,"titlePlacement":"SHOW_ON_THE_RIGHT","galleryTextAlign":"center","scrollSnap":false,"itemClick":"nothing","fullscreen":true,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","slideAnimation":"SCROLL","scrollDirection":0,"scrollDuration":400,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","imagePlacementAnimation":"NO_EFFECT","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":0,"textBoxWidth":200,"textBoxWidthPercent":50,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":1,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"jsonStyleParams":"","gallerySizeType":"px","gallerySizePx":940,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"themeName":"color_12","value":"rgba(204,204,204,1)"},"showVideoPlayButton":true,"galleryLayout":2,"targetItemSize":940,"selectedLayout":"2|bottom|1|fill|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":false,"externalInfoHeight":0,"externalInfoWidth":0.5},"container":{"width":940,"galleryWidth":972,"galleryHeight":0,"scrollBase":0,"height":null}}