Problem Solving with Excel!
It’s not unusual for Solver to report that it can’t find a solution, even when you know that one should exist. Often, you can…
How to Extend Rows & Columns Right (in Excel)
A list can be extended to the right and down using the EXPAND function. You’ll need to come up with a creative solution to add…
How to Customize Sparkline Graphics
Designing attractive and useful Sparklines in Excel can seem like a daunting task, but it doesn’t have to be! By following a few…
How to Use Excel’s Subtotal Function
Excel’s SUBTOTAL function returns an aggregation of the specified values. Despite its name, SUBTOTAL can perform numerous…
How to Wrap Values into Separate Columns (Excel)
Wrapping values into separate columns, the WRAPCOLS function transforms a list. The length of each column is set by the…
How to Lookup the Top 3, 4, 5…Scores
The XLOOKUP function is a relatively new addition to Microsoft Excel that allows you to search for a value in a range or…
How to Remove Characters From Text with Excel
The VALUE function can be used to convert simple text values to numbers. Here’s the formula…
How to Add Upper Case to First Word with Excel
You can capitalize the first letter of a word or text by using a formula based on the LEFT, MID, and LEN functions. Here’s…
How to Markup a Rolex Watch 200%
If you need to calculate percentages in Microsoft Excel, there are a few different ways that you can do so. You can use…
Turn Excel Columns or Rows into a Single Row
With 2 Lists Place Rows 1-2 and Rows 1-2 into a New Single Row (by row) Using the HSTACK or
How to Add Relative Row Numbers with Excel
A formula based on the ROW function can be used to automatically add row numbers to an Excel Table. Here’s the…
How to Design a Tracking Schedule (Excel)
To calculate the number of days a book has been checked out, you can use a formula based on the IF function, along with the…
How to Remove or Replace Every Unique Value (automakers) in Excel
The UNIQUE function makes it simple to obtain unique values from a single column or row. But it is unable to handle lists with…
How to Sum Inventory by Region (east & west)
This formula appears to be using the SUMIF function to add up values from the “total_118” column based on certain criteria in…
How to Edit Data in Excel
To replace the contents of a cell with something else, just activate the cell and type your new entry, which replaces the
How to Design an Outline using Excel
Formulas based on the Excel functions COUNTA, IF, MID, FIND, and LEN can be used to generate basic outline numbering. Here’s…
How to Track Deliveries using Excel
Using the COUNTIFS function and an expanding list in an assist column, you can identify the first delivery of fruit in a…
Lookup “anything” Horizontally in Excel
In Excel, the =HLOOKUP() and =XLOOKUP() function can be used to look up values horizontally. This is useful when you…
How to Check if a Blue Hoodie’s in Stock
This is a formula using the Excel FILTER function to filter a range of data from B5:E16 based on four criteria…
How to Add a Header & Footer (Excel)
Adding a footer and header to your Excel reports can help add professionalism and style. Here’s how to do it…
How to Place Pivottable Data into Manageable Groups
When you have a lot of information in an Excel PivotTable, it can be helpful to group that information into smaller, more…
