How To Use Number and Text Filters In Excel

Oct 27, 2020

This example teaches you how to apply a number filter and a text filter to only display records that meet certain criteria.

#Tutorial#How To#Data Analysis#Filter

How to Use Quadratic Equation In Excel

A quadratic equation is of the form ax^{2} + bx + c = 0 where a ≠ 0.

#Tutorial#How To#Data Analysis#What-If Analysis

How To Use Randomize List In Excel

This article teaches you how to randomize (shuffle) a list in Excel.

#Tutorial#How To#Data Analysis#Sort

How To Use Regression Analysis in Excel

This example teaches you how to run a linear regression analysis in Excel and how to interpret the Summary Output.

#Tutorial#How To#Data Analysis#Analysis ToolPak

How To Use Reverse List In Excel

This article teaches you how to reverse a list in Excel. For example, we want to reverse the list in column A below.

How to Use Sensitivity Analysis In Excel

Sensitivity analysis gives you insight in how the optimal solution changes when you change the coefficients of the model.

#Tutorial#How To#Data Analysis#Solver

How to Use Shade Every Other Row in Excel

This example shows you how to use conditional formatting to shade alternate rows.

#Tutorial#How To#Data Analysis#Conditional Formatting

How To Use Shortest Path Problem In Excel

Use the solver in Excel to find the shortest path from node S to node T in an undirected network.

How To Use Slicers In Excel

You can insert slicers in Excel to quickly and easily filter pivot tables.

#Tutorial#How To#Data Analysis#Pivot Tables

How To Use Sort data in a range by Color In Excel

This example teaches you how to sort data by color in Excel.