Excel Spilled Ranges
What is an Excel spilled range? First of all, a range in Excel is a collection of two […]
Blog
Excel Add or Remove Table Rows and Columns
Rows If you have an Excel table, you can easily add rows to that table. One way is […]
Excel Totals in Tables
When you are working with a table in Excel you can have the aggregations calculate automatically. How can […]
Power Query Transform Phone Number
Do you need to split a column of imported Excel telephone number data into two columns so that […]
Import a Text File into Excel
How do you import a text file of data into Microsoft Excel? Let’s discuss two different ways of […]
Excel Index and Match
Excel’s Index and match functions used together can solve complex lookup problems. Let’s jump right into an example […]
Excel Find Nth Occurrence of Char in a String
In Microsoft Excel, what formula would you use to find the Nth occurrence of a character (or string) […]
Excel Extract Nth Word from a Text String
In Microsoft Excel, how would you extract the Nth word in a string? If you are using Excel […]
Pivot Table Example
Here is a simple example of how to create a pivot table in Excel that is based on […]
Why Use Excel Tables?
Why would you want to use Excel tables? Why not just stick with Excel ranges or just leave […]
Excel Power Query Introduction
What is Power Query? This is what Microsoft says: “Power Query is a data transformation and data preparation […]
Excel Dynamic Data Validation
What do we mean by dynamic data validation? Suppose we are asking users to enter a product (or […]