'Features' category


Subcategories

  • Advanced filter (6)
  • Data validation (28)
  • Excel table (21)
  • Named range (5)
  • Pivot table (16)
  • Solver (7)

  • 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 […]
    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 […]
    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.
    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.
    How to automatically add new items to a drop down list
    A drop-down list in Excel prevents a user from entering an invalid value in a cell. Entering a value that […]
    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 […]
    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 […]
    How to filter chart data
    What if you want to show a selection of a data set on a chart and easily change that selection? […]
    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 […]
    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 […]
    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 […]
    Pivot Table calendar
    This article demonstrates how to build a calendar in Excel. The calendar is created as a Pivot Table which makes […]
    Compare data in an Excel chart using drop down lists
    I will in this article demonstrate how to set up two drop down lists linked to an Excel chart, the […]
    How to build an interactive map in Excel
    This article describes how to create a map in Excel, the map is an x y scatter chart with an […]
    Highlight duplicates in a filtered Excel Table
    The image above demonstrates a conditional formatting formula applied to an Excel Table containing random data. The Excel Table has […]
    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 […]
    Highlight group of values in an x y scatter chart programmatically
    I will in this article demonstrate how to highlight a group of values plotted in an x y scatter chart […]
    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 […]
    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 […]
    Prevent overlapping date and time ranges using data validation
    The picture above shows an Excel Table with Data Validation applied. An error dialog box appears if a user tries […]
    Analyze trends using pivot tables
    Table of Contents Introduction to pivot tables Create pivot table Group data Analyze data (pivot table) Compare performance, year to […]
    How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
    This article demonstrates different ways to reference an Excel defined Table in a drop-down list and Conditional Formatting. There are […]
    Populate drop down list with filtered Excel Table values
    This article demonstrates how to populate a drop down list with filtered values from an Excel defined Table. The animated […]
    Macro creates links to all sheets, tables, pivot tables and named ranges
    This article demonstrates a macro that automatically populates a worksheet with a Table of Contents, it contains hyperlinks to worksheets, […]
    Count unique distinct values in a filtered Excel defined Table
    This article demonstrates a formula that counts unique distinct values filtered from an Excel defined Table. Debra Dalgleish described in […]
    Prepare data for Pivot Table – How to split concatenated values?
    This article demonstrates a macro that allows you to rearrange and distribute concatenated values across multiple rows in order to […]
    Use a drop down list to filter and concatenate unique distinct values
    Question: Is there a way to have a unique list generated from a list? Meaning I have a sheet that […]
    Add or remove a value in a drop down list programmatically
    This article demonstrates how to add or remove a value in a regular drop down list based on a list […]
    Auto populate a worksheet
    Rodney Schmidt asks: I am a convenience store owner that is looking to make a spreadsheet formula. I want this […]
    Use a drop down list to display data in worksheet header [VBA]
    Aynsley Wall asks: I have a spreadsheet that I use for 3 different companies. What I would really like to […]
    Apply drop-down lists dynamically
    This article demonstrates how to automatically create drop-down lists if adjacent data grows, there are two methods explained here. The […]
    Dependent drop-down lists in multiple rows
    This article demonstrates how to set up dependent drop-down lists in multiple cells. The drop-down lists are populated based on […]
    Use a drop down list to search and return multiple values
    I will in this article demonstrate how to use a value from a drop-down list and use it to do […]
    Extract unique distinct values in a filtered list
    This article demonstrates two formulas that extract distinct values from a filtered Excel Table, one formula for Excel 365 subscribers […]
    Extract unique distinct values based on a filtered Excel defined Table
    This blog post demonstrates how to filter unique distinct values from an Excel table dynamically. When you change or add […]
    Remove common records between two data sets
    This article demonstrates how to filter records occurring in only one out of two Excel defined tables. It also shows […]
    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 […]
    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 […]
    How to create a dynamic pivot table and refresh automatically
    Table of Contents How to create a dynamic pivot table and refresh automatically Auto refresh a pivot table 1. How […]
    Create a drop down calendar
    The┬ádrop down calendar in the image above uses a "calculation" sheet and a named range. You can copy the drop-down […]
    Apply dependent combo box selections to a filter
    Josh asks: now if i only knew how to apply these dependent dropdown selections to a filter, i'd be set. […]
    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 […]
    Excel solver examples
    This article demonstrates ways to use solver in Excel. Table of Contents Using Excel Solver to schedule employees Cash drawer […]
    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 […]
    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 […]
    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 […]

    Excel categories