Subscribe
Tutorial search

Excel For Tutorials


Sort by:
Excel Solver
Excel Solver
Excel has a clever and handy tool called solver that helps you find optimal solutions for many decision-based problems in your spreadsheets.
Difficulty:
Excel What-If Analysis
Excel What-If Analysis
This tutorial teaches you how to perform what-if analysis in Excel.
Difficulty:
Excel formulas and functions.
Excel formulas and functions.
A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
Difficulty:
Excel Conditional Formatting
Excel Conditional Formatting
Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
Difficulty:
How to use a Scroll Bar in Excel
How to use a Scroll Bar in Excel
How to use a scroll bar in Excel to create a scrollable list. Great for dashboards.
Difficulty:
Excel Solver
Excel Solver
Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
Difficulty:
Excel What-If Analysis
Excel What-If Analysis
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas.
Difficulty:
Excel Sparklines
Excel Sparklines
Excel Sparklines are graphs that fit in one cell and give you information about the data.
Difficulty:
Create a Thermometer Chart in Excel
Create a Thermometer Chart in Excel
Thermometer charts in Excel are great for comparing actual figures against a target. This article looks at how to create a thermometer chart.
Difficulty:
Excel Vlookup
Excel Vlookup
The Vlookup function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column of the table.
Difficulty:
Find Payments Due this Week
Find Payments Due this Week
Use Excel to find payments due this week. Use an Excel formula in Conditional Formatting to alert you to payments due this week and next week.
Difficulty:
MMult Function
MMult Function
The MMULT function in Excel is used for matrix multiplication. It takes as inputs two arrays or matrices and outputs the matrix product of the two
Difficulty:
Array Formulas in Excel
Array Formulas in Excel
Arrays in Microsoft Excel are not a single function, but actually a variety of different formulas that you can use to simplify your work with arrays.
Difficulty:
Highlight Birthdays Due this Month in Excel
Highlight Birthdays Due this Month in Excel
Keep track of birthdays using Excel to automatically format the birthdays due this month. Never miss a birthday again.
Difficulty:
How To: Protect Your Excel Spreadsheet From Unauthorized Changes (Excel 2007)
How To: Protect Your Excel Spreadsheet From Unauthorized Changes (Excel 2007)
If you work with a team of people using Excel, you may want to protect your Excel Spreadsheet from changes. Adding a password in order for people to make changes does just that.
Difficulty:
Search Term(s) (1): for