Function: LOWER
The LOWER function converts a text to lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax Arguments text...
Function: UPPER
The UPPER function converts a text into uppercase. In this guide, we’re going to show you how to use this function and cover some tips and error handling methods.Supported versionsAll Excel versionsSyntaxArgumentstextThe...
Function: IF
The IF function performs a logical test (specified from its first argument), and returns either one of its second or third argument depending on the result of the test. If the test returns TRUE, the result will be the second argument, otherwise it will be the third....
User Defined Functions in Excel
User Defined Functions (UDFs in short) are, as the name suggests, functions whose properties are custom defined by the user. They can be tailored to specific user needs and greatly improve productivity as they can help you do things built-in Excel features can’t. For...
Excel Database Functions
Database functions are designed to perform simple operations on data that is in a “database-like structure”. Database-like structure means that the data must be in a table structure that has organized records with labels and appropriate separation. In this model, each...
Forecasting in Excel
What is Forecasting? Forecasting is a technique to establish relationships and trends which can be projected into the future, based on historical data and certain assumptions. This method can be utilized to better understand and make an educated guess on how to adjust...
All You Need to Know for Using Excel Iterative Calculation
Iterative calculations can help find the solution to mathematical problems by running calculations over and over using previous results. This is made possible by computers that can run calculations repeatedly to find the likelihood of possible answers by getting...
How and Why of Running a Simulation in Excel
A simulation is commonly defined as an imitation of a situation or process. This typically entails creating a mathematical model that represents the characteristics and other features of a system. The model then can be used to simulate how the system will respond in...
How to use DAX Functions in Pivot Tables
Microsoft's data analysis tools PowerPivot, Power BI Desktop, and SQL Server Analysis Services (SSAS) Tabular models empower Excel users by allowing them better manage and transform their data. Data Analysis Expressions (DAX) is essentially a formula and query...