Excel’s VSTACK Function
Combining or appending data from multiple sheets is a common task in Excel. We’ll show you how you […]
Excel
Excel Unique Function
The Excel UNIQUE function gives you all of the distinct values of a given range. All you need […]
Excel Agenda Template
Do you have an event or meeting that you would like to enter into Excel and have Excel […]
Excel Spilled Ranges
What is an Excel spilled range? First of all, a range in Excel is a collection of two […]
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 […]