Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 28 of 30 · 270 articles
Function: LOWER
The LOWER function converts a text into lowercase. In this guide, we’re going to show you how to use the this function using examples.
Function: UPPER
The UPPER function converts a text to uppercase. In this guide, we’re going to show you how to use the UPPER function.
Function: IF
In this guide, we’re going to show you how to use the IF function along with some tips and error handling methods.
User Defined Functions in Excel
User Defined Functions (UDFs in short) are functions whose properties are custom defined and can be tailored to specific user needs.
Excel Database Functions
For data that is 'database' structure, you can use Excel database functions to manipulate and manage your tables much more efficiently.
Forecasting in Excel
Forecasting in Excel can help you establish relationships and trends which can be projected into the future.
All You Need to Know for Using Excel Iterative Calculation
You can reference a cell that contains a formula and use its result again. A better way to do this is using Excel iterative calculation.
How and Why of Running a Simulation in Excel
Excel is commonly used to create data models and simulations. Let's examine a simulation in Excel and the tools available for this purpose.
How to use DAX Functions in Pivot Tables
DAX functions help manage and transform your data in Microsoft's data analysis tools like PowerPivot and Power BI Desktop.