AlchemyJ

by Axisoft

  • Features

  • Rule Engine

  • Resource

    • AJ Video
    • AJ Sample Model
    • AJ Template
    • AJ Excel Template
  • Download

  • Support

    • Blog
    • Docs
  • Buy

  • Contact Us

  • More

    Use tab to navigate through the menu items.
    • All Posts
    • News
    • How-to
    • AJXF
    Search
    Basic Excel Function - Wildcards Function in Excel
    celsiushb.tan
    • Oct 15, 2021
    • 3 min

    Basic Excel Function - Wildcards Function in Excel

    For today’s Excel tutorial, you will be learning the Wildcard Excel Function. In our example, we are given a table of the biggest box...
    131 views0 comments
    Basic Excel Function - How to use SEARCH Function
    terrylin9
    • Oct 6, 2021
    • 3 min

    Basic Excel Function - How to use SEARCH Function

    For today’s Excel tutorial, You will be learning the SEARCH Function. In our example, we are given a list of emails addresses. First, I...
    91 views0 comments
    Basic Excel Function - How to use TEXTJOIN Function
    terrylin9
    • Sep 29, 2021
    • 3 min

    Basic Excel Function - How to use TEXTJOIN Function

    For today’s Excel tutorial, You will be learning the TEXTJOIN Function. Similar to the concatenate function, TEXTJOIN join strings from...
    72 views0 comments
    Basic Excel Function - How to use NUMBERVALUE Function
    celsiushb.tan
    • Sep 26, 2021
    • 3 min

    Basic Excel Function - How to use NUMBERVALUE Function

    For today’s Excel tutorial, I will be showing you how to use the NUMBERVALUE Function. The NUMBERVALUE Function converts a text value to...
    66 views0 comments
    Basic Excel Function - How to use MOD Function in Excel
    terrylin9
    • Sep 15, 2021
    • 3 min

    Basic Excel Function - How to use MOD Function in Excel

    For today’s Excel tutorial, I will be showing you an important function called MOD. The MOD function returns the remainder after a number...
    35 views0 comments
    Basic Excel Function - How to use SUM Function Across Multiple Tabs
    celsiushb.tan
    • Sep 9, 2021
    • 3 min

    Basic Excel Function - How to use SUM Function Across Multiple Tabs

    Do you know that SUM Function is not limited to a single sheet and can be used across multiple tabs? In our example, we are task to sum...
    32 views0 comments
    Basic Excel Function - How to use SUBSTITUTE Function
    terrylin9
    • Aug 31, 2021
    • 3 min

    Basic Excel Function - How to use SUBSTITUTE Function

    Today we will be learning the SUBSTITUTE Function. The function replaces existing text with new text in a text string. In our excel...
    43 views0 comments
    Basic Excel Function - How to use TRIM Function
    terrylin9
    • Aug 24, 2021
    • 3 min

    Basic Excel Function - How to use TRIM Function

    Today we will be learning the TRIM Function. The function removes all spaces from a text string except single spaces between words. In...
    40 views0 comments
    Basic Excel Function - How to use LEN Function
    terrylin9
    • Aug 17, 2021
    • 3 min

    Basic Excel Function - How to use LEN Function

    Today we will be learning the LEN Function. The function returns the number of characters in a text string. In other words, the function...
    44 views0 comments
    Basic Excel Function - How to use LEFT, RIGHT and MID Functions
    terrylin9
    • Aug 10, 2021
    • 3 min

    Basic Excel Function - How to use LEFT, RIGHT and MID Functions

    Today we will be learning a simple and helpful String Function. The Left, Right and Mid Functions. These functions enable us to select...
    24 views0 comments
    Basic Excel Function - How to use UPPER, LOWER and PROPER Functions
    terrylin9
    • Aug 3, 2021
    • 3 min

    Basic Excel Function - How to use UPPER, LOWER and PROPER Functions

    We will learn how to change to case of value in your Excel spreadsheet to UPPER, LOWER and PROPER Cases for today's tutorial. We will be...
    27 views0 comments
    Basic Excel Function - How to use SUMPRODUCT Function in Excel
    terrylin9
    • Jul 28, 2021
    • 3 min

    Basic Excel Function - How to use SUMPRODUCT Function in Excel

    For today's tutorial, we will be calculating the total cost of Espresso, Milk, Sugar for our café. We will be using the SUMPRODUCT...
    44 views0 comments
    Basic Excel Function - How to use CHOOSE Function in Excel
    celsiushb.tan
    • Jul 20, 2021
    • 3 min

    Basic Excel Function - How to use CHOOSE Function in Excel

    We will be using the CHOOSE Function for today's tutorial to determine each company we had Dollar-cost Averaging in. For the examples, we...
    48 views0 comments
    Basic Excel Function - How to use Standard Deviation Function in Excel
    terrylin9
    • Jul 13, 2021
    • 3 min

    Basic Excel Function - How to use Standard Deviation Function in Excel

    How to use the Standard Deviation Function in Excel to calculate the riskiness and the minimum needed return on an investment you wish to...
    47 views0 comments
    Basic Excel Function - How to use NETWORKDAYS Function in Excel
    celsiushb.tan
    • Jul 6, 2021
    • 3 min

    Basic Excel Function - How to use NETWORKDAYS Function in Excel

    We will be using the NETWORKDAYS Function for our Waterfall Web Development Process timeline example to calculate the number of workdays....
    41 views0 comments
    Basic Excel Function - How to use HLOOKUP Final Function in Excel
    celsiushb.tan
    • Jun 30, 2021
    • 3 min

    Basic Excel Function - How to use HLOOKUP Final Function in Excel

    I have created a staff COVID-19 vaccination program, and we will be using HLOOKUP to find out which staff is vaccinated. We will be using...
    32 views0 comments
    Basic Excel Function - How to use VLOOKUP Function in Excel
    celsiushb.tan
    • Jun 23, 2021
    • 3 min

    Basic Excel Function - How to use VLOOKUP Function in Excel

    How to use the VLOOKUP Function in Excel? For this tutorial, I have created a staff COVID-19 vaccination program and we will be using...
    45 views0 comments
    Basic Excel Function - How to use INDEX and MATCH Function in Excel
    celsiushb.tan
    • Jun 16, 2021
    • 3 min

    Basic Excel Function - How to use INDEX and MATCH Function in Excel

    Index and Match Function is an alternative method from VLOOKUP. For this tutorial, I have created an Excel Sheet of Steve's Laptop Store...
    39 views0 comments
    Basic Excel Function - How to use IFERROR Function in Excel
    celsiushb.tan
    • Jun 8, 2021
    • 3 min

    Basic Excel Function - How to use IFERROR Function in Excel

    For this tutorial, I have created an Investment Portfolio with some popular Stocks and Cryptocurrencies. These include Tesla, Facebook,...
    65 views0 comments
    Basic Excel Function - How to use SUMIFS Function in Excel
    celsiushb.tan
    • Jun 2, 2021
    • 3 min

    Basic Excel Function - How to use SUMIFS Function in Excel

    For this tutorial, I have created an Excel Sheet of Wallmart's Cost of Inventory Replenishment. These Fast-moving consumer goods include...
    51 views0 comments
    1
    234

    About    Contact    News    Partners    Privacy    Terms    Cookies Policy

    • LinkedIn
    • YouTube
    • Facebook
    • Twitter

    Copyright © 2022 Axisoft. All Rights Reserved.