The AVERAGE function in Microsoft Excel is one of the most commonly used statistical functions, designed to calculate the mean of a set of numbers. What is the AVERAGE Function? The AVERAGE function returns the arithmetic mean of a set of numbers. It is a straightforward yet powerful tool for summarizing data, making it easier…
Author: ilyar126
Excel function AVEDEV
Ever wanted to write AVERAGE() function in Excel and accidentally hit tab too soon to get AVEDEV? No worries, such function also exists. The AVEDEV function in Microsoft Excel is a statistical function designed to calculate the average of the absolute deviations of data points from their mean. This function is particularly useful for professionals…
ARRAYTOTEXT Excel Function
One super useful function when you are working with bunch of text and want to convert it into a long array string is by using ARRAYTOTEXT() function. What is the ARRAYTOTEXT Function? The ARRAYTOTEXT function returns an array of text values from any specified range. It passes text values unchanged and converts non-text values to…
ARABIC and ROMAN Excel function
The ARABIC and ROMAN functions in Microsoft Excel are powerful tools designed to convert between Roman and Arabic numerals. These functions are particularly useful for professionals dealing with historical data, legal documents, or business reports that utilize Roman numerals. What are the ARABIC and ROMAN Functions? The ARABIC function converts a Roman numeral to an…
Excel Function – AMORDEGRC
The AMORDEGRC function in Microsoft Excel is a financial function designed to calculate the depreciation of an asset for each accounting period using a depreciation coefficient. Unlike the AMORLINC function, AMORDEGRC applies a depreciation coefficient based on the life of the asset. This function is particularly tailored for the French accounting system, where it is…
Excel Function – AMORLINC
The AMORLINC function in Microsoft Excel is a specialized financial function designed to calculate the linear depreciation of an asset for each accounting period. It is similar to AMORDEGRC function, but is linearly calculated, while the later is calculated using depreciation coefficient based on the life of the asset. This function is particularly tailored for…
The Mantra of AI in today’s Tech World.
If you listen to Microsoft’s Satya Nadella, OpenAI’s Sam Altman, Google’s Sundar Pinchai or any other Tech CEOs you would probably hear the term “AI” used as a sort of mantra that starts and ends every sentence and sometimes in between. Besides these big guys, everybody else is also talking about AI nowadays, but few…
FabCon Las Vegas 2025: The Ultimate Microsoft Fabric Conference
What a Fabulous News: FabCon is in the house! (FabCon stands for Fabric Conference) As the data landscape continues to evolve, staying updated with the latest tools and technologies is essential for data professionals. FabCon Las Vegas 2025, the premier conference for Microsoft Fabric enthusiasts, promises to be an unforgettable event. Scheduled to take place…
Creating user-friendly connection names for long SQL strings (Fabric Endpoint)
Ever wondered how to remember 54 character long, cryptic connection string to a SQL Warehouse in Fabric? It could become challenging when using SSMS to choose the right connection when you have a drop down of few Fabric SQL Endpoint connections. Who knows by heart 54 random character strings? Well, there is no direct way…
Test: ChatGPT vs Microsoft Copilot on image creation
ChatGPT Image Creation I tried comparing the quality of ChatGPT and Microsoft Copilot when it comes to creating an image. I learned that they both use DALL-E tool, but the results are still different as you will see the article. I chose the topic of chihuahua dog, since I find it amusing. The prompt engineering…