Month: December 2022

  • Excel Tutorial – MINUTE

    The MINUTE function in Microsoft Excel is a built-in function that allows you to extract the minute component from a given time value. It takes a single argument, which is the time value that you want to extract the minutes from, and returns the minute component as a number between 0 and 59. To use…

    Read More: Excel Tutorial – MINUTE
  • Excel Tutorial – HOUR

    The HOUR function in Microsoft Excel is a function that extracts the hour from a time or date/time value. This can be useful if you want to perform calculations based on the hour or if you want to extract specific hours from a list of times. To use the HOUR function, follow these steps: Open…

    Read More: Excel Tutorial – HOUR
  • Excel Tutorial – TIME

    The TIME function in Microsoft Excel is a function that returns the current 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 TIME function, follow these steps: Open your Excel workbook and navigate to the…

    Read More: Excel Tutorial – TIME
  • Excel Tutorial – YEAR

    The YEAR function in Microsoft Excel is a function that extracts the year from a date. This can be useful if you want to perform calculations based on the year or if you want to extract specific years from a list of dates. To use the YEAR function, follow these steps: Open your Excel workbook…

    Read More: Excel Tutorial – YEAR
  • Excel Tutorial – MONTH

    The MONTH function in Microsoft Excel is a function that extracts the month from a date. This can be useful if you want to perform calculations based on the month or if you want to extract specific months from a list of dates. To use the MONTH function, follow these steps: Open your Excel workbook…

    Read More: Excel Tutorial – MONTH
  • Excel Tutorial – DAY

    The DAY function in Microsoft Excel is a function that extracts the day of the month from a date. This can be useful if you want to perform calculations based on the day of the month or if you want to extract specific days from a list of dates. To use the DAY function, follow…

    Read More: Excel Tutorial – DAY
  • 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