# 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.

## Combine Lots of Tables in the Same Workbook

| July 9, 2024 |

Today we will tackle a common question: “How can we combine numerous tables that are in the same workbook?” Let’s dive right in and learn how to easily combine tables, even if they have different column orders! Video Step-by-step Process In this guide, we’ll explore how to use Power Query to combine several tables from…

## Skipping Excel 1

| November 22, 2022 |

Excel is used for many different tasks, such as budgeting, reporting, comparing bank statements, and other things. It can also be used to export, clean, and import data between two separate systems. For example, suppose you export transactions from an e-commerce system, open them in Excel, tidy up the information a little, and then transfer…

## How to Perform a Frequency Distribution in Excel (no formulas)

| September 13, 2022 |

Are you a school administrator who wants to see how student test scores are distributed, or maybe an accountant who needs to analyze trends in spending or accounts receivable? If so, creating a frequency distribution in Excel is one of the easiest ways to do it!  Essentially, frequency distributions come in handy whenever you need…

## Don’t Panic! Here’s How to Recover an Excel File Not Saved

| July 5, 2022 |

Have you ever worked on an Excel project for hours, only for all of that effort to be lost because of one power outage that shut down your system? Everyone knows the panic that sets in when they’ve accidentally deleted important work. But, the good news is that not all is lost! There are a…

## How to easily Automate Your Customized Excel Financial Statements

| May 3, 2022 |

Although Excel provides a great deal of flexibility in creating financial statements, it has several limitations: If you use Excel to create financial statements, you will want to read on. In this article, we’ll show how the patented FSM technology allows you to easily produce exactly the custom financial reports you need in Excel. They…

## Easily Create and Update Excel Reports from QuickBooks

| March 22, 2022 |

In this article, we’ll show how to easily create and update Excel reports from QuickBooks. But, let’s back up a second. When QuickBooks has the report you want, awesome! But, when it doesn’t, we often turn to Excel. This can happen when QuickBooks doesn’t have all of the data you need for the report, for…

## Retrieve QuickBooks Data with Genius Sheets

| September 15, 2021 |

This is the next post in the add-in series, where we are exploring various add-ins that expand the capabilities of Excel. In this post, we’ll take a look at the Genius Sheets add-in. In summary, it enables us to get QuickBooks Online data into our Excel workbooks. The add-in provides several custom functions that we…

## Public Company Financials with XBRL Filed Data

| August 11, 2021 |

This is the next post in the add-ins series, where we are exploring various add-ins that enhance and extend the capabilities of Excel. In this post, we’ll take a look at the XBRL Filed Data add-in. In summary, it enables us to get public company financial data (and more) into Excel. Objective Before we get…

## Excel to Word Document Automation

| August 3, 2021 |

This is the next post in the add-ins series, where we are exploring various add-ins that enhance and extend the capabilities of Excel. In this post, we’ll take a look at the Excel-to-Word Document Automation add-in. In summary, it enables us to get Excel data into a Word (or Power Point) document. It creates a…