'Features' category
Subcategories
- Drop down lists (25)
How to solve simultaneous linear equations in Excel
This article demonstrates how to solve simultaneous linear equations using formulas and Solver. The variables have the same value in […]
This article demonstrates how to solve simultaneous linear equations using formulas and Solver. The variables have the same value in […]
How to use the COMBIN function
The COMBIN function returns the number of combinations for a specific number of elements out of a larger number of […]
The COMBIN function returns the number of combinations for a specific number of elements out of a larger number of […]
How to use Excel Tables
An Excel table allows you to easily sort, filter and sum values in a data set where values are related.
An Excel table allows you to easily sort, filter and sum values in a data set where values are related.
How to use Pivot Tables – Excel’s most powerful feature and also least known
A pivot table allows you to examine data more efficiently, it can summarize large amounts of data very quickly and is very easy to use.
A pivot table allows you to examine data more efficiently, it can summarize large amounts of data very quickly and is very easy to use.
Working with Excel tables programmatically
The image above demonstrates a macro linked to a button. Press with left mouse button on the button and the […]
The image above demonstrates a macro linked to a button. Press with left mouse button on the button and the […]
How to use the Subtotal tool
The Subtotal feature lets you insert totals and grand totals automatically, this feature was added to Excel 2010 and is […]
The Subtotal feature lets you insert totals and grand totals automatically, this feature was added to Excel 2010 and is […]
Lookup with any number of criteria
This article demonstrates a formula that allows you to search a data set using any number of conditions, however, one […]
This article demonstrates a formula that allows you to search a data set using any number of conditions, however, one […]
How to use the Scroll Bar
This article demonstrates how to insert and use a scroll bar (Form Control) in Excel. It allows the user to […]
This article demonstrates how to insert and use a scroll bar (Form Control) in Excel. It allows the user to […]
Prevent duplicate records in a worksheet
This article demonstrates how to set up Data Validation in order to control what the Excel user is allowed to […]
This article demonstrates how to set up Data Validation in order to control what the Excel user is allowed to […]
How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
I will in this article demonstrate three different techniques to sort a data set in Excel. The first method sorts […]
I will in this article demonstrate three different techniques to sort a data set in Excel. The first method sorts […]
Run a Macro from a Drop Down list [VBA]
This article demonstrates how to run a VBA macro using a Drop Down list. The Drop Down list contains two […]
This article demonstrates how to run a VBA macro using a Drop Down list. The Drop Down list contains two […]
Advanced Techniques for Conditional Formatting
Table of contents How to change cell formatting using a Drop Down list Highlight cells based on coordinates Highlight every […]
Table of contents How to change cell formatting using a Drop Down list Highlight cells based on coordinates Highlight every […]
How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges
This article demonstrates different ways to reference an Excel defined Table in a drop-down list and Conditional Formatting. There are […]
This article demonstrates different ways to reference an Excel defined Table in a drop-down list and Conditional Formatting. There are […]
Use a drop down list to search and return multiple values
Table of Contents Use a drop down list to search and return multiple values How to automatically add new items […]
Table of Contents Use a drop down list to search and return multiple values How to automatically add new items […]
Extract unique distinct values from an Excel Table filtered list
This article demonstrates two formulas that extract distinct values from a filtered Excel Table, one formula for Excel 365 subscribers […]
This article demonstrates two formulas that extract distinct values from a filtered Excel Table, one formula for Excel 365 subscribers […]
How to compare two data sets
Table of Contents How to compare two data sets - Excel Table and autofilter Filter shared records from two tables […]
Table of Contents How to compare two data sets - Excel Table and autofilter Filter shared records from two tables […]
Create a dynamic named range
A dynamic named range grows automatically when new values are added and also shrinks if values are deleted. This saves […]
A dynamic named range grows automatically when new values are added and also shrinks if values are deleted. This saves […]
Create dependent drop down lists containing unique distinct values
Table of Contents Create dependent drop down lists containing unique distinct values - Excel 365 Create dependent drop down lists […]
Table of Contents Create dependent drop down lists containing unique distinct values - Excel 365 Create dependent drop down lists […]
Excel solver examples
This article demonstrates ways to use solver in Excel. Table of Contents Introduction Using Excel Solver to schedule employees Cash […]
This article demonstrates ways to use solver in Excel. Table of Contents Introduction Using Excel Solver to schedule employees Cash […]
Identify numbers in sum using Excel solver
Table of Contents Identify numbers in sum using Excel solver Find numbers in sum - UDF Find positive and […]
Table of Contents Identify numbers in sum using Excel solver Find numbers in sum - UDF Find positive and […]
Populate drop down list with unique distinct values sorted from A to Z
Question: How do I create a drop-down list with unique distinct alphabetically sorted values? Table of contents Sort values using […]
Question: How do I create a drop-down list with unique distinct alphabetically sorted values? Table of contents Sort values using […]
5 easy ways to extract Unique Distinct Values
First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]
First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]