Sensitivity Analysis in Excel
Sensitivity analysis gives you insight into how the optimal solution changes when you change the coefficients of the model. After the Excel solver found a solution you can create a sensitivity report.
How to use Excel
Learn how to use Excel like a pro with easy-to-follow tutorials and tips — spreadsheets, charts, pivot tables, and macros.
ROWS: 506UPDATED: OCT 2024SECTION: 01 · PAGE 18/22
October 8, 2024
Find Features in Excel
This page illustrates useful find features in Excel. Learn how to perform workbook-wide searches case-sensitive searches find exact cell content and use wildcards.
How to use the Excel AND function
The AND function in Excel evaluates multiple conditions and returns TRUE only if all conditions are TRUE. This guide provides a comprehensive understanding of the AND function starting with basic usage and progressing to more advanced formulas.
Randomize a List in Excel
This article teaches you how to randomize (shuffle) a list in Excel. For example let's randomize the list in column A below.
How to use the Excel IF function
The IF function in Excel checks whether a condition is met and returns one value if true and another value if false. This page contains many easy to follow IF examples.
Import Access Data into Excel
This example teaches you how to import data from a Microsoft Access database. In Excel when you import data you make a permanent connection that can be refreshed.
Knapsack Problem in Excel VBA
Below we will look at a program in Excel VBA that solves a small instance of a knapsack problem.
FormulaR1C1 Property in Excel VBA
This example illustrates the difference between A1 R1C1 and R[1]C[1] style in Excel VBA.
Select Case in Excel VBA
Instead of multiple If Then statements in Excel VBA you can use the Select Case structure. Let's explore this through two examples.
Text Box in Excel VBA
A text box is an empty field where a user can fill in a piece of text. To create a text box in Excel VBA execute the following steps.
From Active Cell to Last Entry in Excel VBA
This example illustrates the End property of the Range object in Excel VBA. We will use this property to select the range from the Active Cell to the last entry in a column.
Create a Pareto Chart in Excel
This example teaches you how to create a Pareto chart in Excel. The Pareto principle states that for many events roughly 80% of the effects come from 20% of the causes.
Percentiles and Quartiles in Excel
This example teaches you how to use PERCENTILE and QUARTILE in Excel. Below you can find a list of scores.
Logical Functions in Excel
Learn how to use Excel's logical functions such as IF AND OR and NOT.
Convert to Proper Case in Excel VBA
Below we will look at a program in Excel VBA that converts text to proper case. That is the first letter in each word in uppercase and all other letters in lowercase.
Exponential Smoothing in Excel
This example teaches you how to apply exponential smoothing to a time series in Excel. Exponential smoothing is used to smooth out irregularities (peaks and valleys) to easily recognize trends.
INDEX and MATCH in Excel
Use INDEX and MATCH in Excel and impress your boss. Instead of using VLOOKUP use INDEX and MATCH. To perform advanced lookups you'll need INDEX and MATCH.
Error Handling in Excel VBA
Below we will look at two programs in Excel VBA. One program simply ignores errors. The other program continues execution at a specified line upon hitting an error.
How to use the Excel FILTER function
Use the magic FILTER function in Excel 365/2021 to extract records that meet certain criteria. The FILTER function is quite versatile.
How to Sort by Date in Excel
This guide walks you through the steps to sort by date in Excel. It starts with how to convert text-formatted dates to actual date values followed by basic sorting methods and advanced techniques like sorting dates by month and sorting birthdays.
Create SUM formulas in Excel
Use the SUM function in Excel to sum a range of cells an entire column or non-contiguous cells. To create awesome SUM formulas combine the SUM function with other Excel functions.
Excel VBA Tutorial
VBA (Visual Basic for Applications) is the programming language of Excel. If you're an Excel VBA beginner these 16 chapters are a great way to start. Excel VBA is easy and fun! With Excel VBA you can automate tasks in Excel by writing so called macros.
View Multiple Workbooks in Excel
If you want to view multiple Excel workbooks at the same time execute the following steps.
Statistical Functions in Excel
This chapter gives an overview of some very useful statistical functions in Excel.