Category: Excel Tutorials

  • Excel Tutorial – TODAY

    The TODAY function in Microsoft Excel is a function that returns the current date. This can be useful if you want to track when a cell was updated or if you want to create a timestamp for your data. To use the TODAY function, follow these steps: Open your Excel workbook and navigate to the…

    Read More: Excel Tutorial – TODAY
  • Excel Tutorial – NOW

    The NOW function in Microsoft Excel is a function that returns the current date and time. This can be useful if you want to track when a cell was updated or if you want to create a timestamp for your data. To use the NOW function, follow these steps: Open your Excel workbook and navigate…

    Read More: Excel Tutorial – NOW
  • Excel Tutorial – PROPER

    The PROPER function in Microsoft Excel is a function that converts the first letter of each word in a cell to uppercase and the remaining letters to lowercase. This can be useful if you want to standardize the formatting of your data or if you want to perform case-insensitive comparisons. To use the PROPER function,…

    Read More: Excel Tutorial – PROPER
  • Excel Tutorial – LOWER

    The LOWER function in Microsoft Excel is a function that converts all the characters in a cell to lowercase. This can be useful if you want to standardize the formatting of your data or if you want to perform case-insensitive comparisons. To use the LOWER function, follow these steps: Open your Excel workbook and navigate…

    Read More: Excel Tutorial – LOWER
  • Excel Tutorial – UPPER

    The UPPER function in Microsoft Excel is a function that converts all the characters in a cell to uppercase. This can be useful if you want to standardize the formatting of your data or if you want to perform case-insensitive comparisons. To use the UPPER function, follow these steps: Open your Excel workbook and navigate…

    Read More: Excel Tutorial – UPPER
  • Excel Tutorial – SUBSTITUTE

    The SUBSTITUTE function in Excel allows you to replace a specific set of characters within a text string with a different set of characters. This can be useful if you want to modify a text string by replacing certain words or phrases with different words or phrases. To use the SUBSTITUTE function, you will need…

    Read More: Excel Tutorial – SUBSTITUTE
  • Excel Tutorial – REPLACE

    The REPLACE function in Excel allows you to replace a specific set of characters within a text string with a different set of characters. This can be useful if you want to modify a text string by replacing certain words or phrases with different words or phrases. To use the REPLACE function, you will need…

    Read More: Excel Tutorial – REPLACE
  • Excel Tutorial – FLOOR

    The FLOOR function in Excel allows you to round a number down to the nearest multiple of a specified number. This can be useful if you want to round a number down to the nearest whole number, or if you want to round a number down to the nearest multiple of a specific number. To…

    Read More: Excel Tutorial – FLOOR
  • Excel Tutorial – CEILING

    The CEILING function in Excel allows you to round a number up to the nearest multiple of a specified number. This can be useful if you want to round a number up to the nearest whole number, or if you want to round a number up to the nearest multiple of a specific number. To…

    Read More: Excel Tutorial – CEILING
  • Excel Tutorial – POWER

    The POWER function in Excel allows you to calculate the result of raising a number to a specific power. This can be useful if you want to perform calculations involving exponents. To use the POWER function, you will need to follow these steps: Select the cell where you want the result of the POWER function…

    Read More: Excel Tutorial – POWER