# Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

# VSTACK

## Combine Tables with Different Column Order

| March 21, 2023 |

Combining data from multiple tables in Excel has historically been very manual … especially when the tables have different column orders. In this blog post, we’ll tackle this challenge by getting Excel to combine the tables with a formula that uses the VSTACK and CHOOSECOLS functions. Video Step by step Let’s use a basic example.…

## Excel How To Combine Tables with a Single Formula

| March 14, 2023 |

If you have ever tried to combine data from different tables manually, that is a lot of copy/paste! In this post, I’ll show you how to use Excel’s VSTACK function so you can do it instantly with a single formula. No copy/paste needed!! Video Step by Step Let’s say you have a table in Excel…

## 14 New Excel Functions CalCPA Article

| May 9, 2022 |

Microsoft recently introduced 14 new functions for Excel—they are sure to help you save some time. We’ll start with a short description of each and then jump into some demonstrations. TEXTSPLIT: splits text into columns and/or rows based on one or more delimiters. TEXTBEFORE: returns the text before the specified delimiter. TEXTAFTER: returns the text…

## Excel Formulas Tutorial: What are Formulas and How to Use Them

| April 19, 2022 |

Formulas are what make Excel, Excel. They’re how we perform both simple and complex calculations, and the possibilities are nearly endless as far as what they can do. Today, we’re going back to the basics with an overview of what formulas are and how to use them, as well as sharing our Excel formulas tutorial…