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.

Features

Count Occurrences between Dates

By Jeff Lenning | October 8, 2024 |

Hello, Excel enthusiasts! Welcome back! Today, we’re diving into an interesting question I received recently: “How do I count occurrences between two dates in Excel?” As with most things in Excel, there are multiple ways to accomplish this task. In this post, I’ll focus on how to achieve our goal with a PivotTable. If you’re…

Read More

Sum if Checked

By Jeff Lenning | October 1, 2024 |

Today, I’ll tackle a question I received recently about checkboxes. The question was essentially about how to add two values in Excel when a checkbox is checked. I’ll walk though the answer with you in this short post. Let’s jump right in! Video Step-by-Step Guide Exercise 1: Getting Started with Checkboxes To get started, we…

Read More

Copilot 3

By Jeff Lenning | September 24, 2024 |

This is the third post in the Copilot in Excel series. In this series, we’re diving into some exciting features of Excel’s Copilot and how it can help us streamline our workbooks. If you’ve ever found yourself needing assistance with editing or wanting to ask Excel a quick question, Copilot has your back. In this…

Read More

Copilot 2

By Jeff Lenning | September 17, 2024 |

How to Use Excel Copilot to Understand Your Data Welcome to the second post in the Copilot in Excel series. In this post, we’re diving into the world of Excel Copilot to help us understand and analyze our data. In this post, we’ll explore how Copilot can help us make sense of the data in…

Read More

Copilot 1

By Jeff Lenning | September 10, 2024 |

Hello, and welcome to this guide on using Copilot in Excel! This post explores how to use Copilot in Excel to execute commands and automate tasks directly within your workbook. We’ll dive into several exercises that show how Copilot can assist us in creating calculated columns, extracting values, and much more. Let’s get started! Video…

Read More

Any value in A also in B

By Jeff Lenning | August 20, 2024 |

I recently received a question: “I have two columns of numbers and want one cell at the top to tell me if any values in column A exist in column B.” In this blog post, we’ll walk through how to accomplish this using some essential Excel functions. Video Objective The question asked how to write…

Read More

Split Amount into Annual Columns

By Jeff Lenning | August 13, 2024 |

Hello and welcome to our guide on how to split amounts into annual columns! We will tackle this using a built-in tool called Power Query. If you’ve never used Power Query in Excel before, no worries, I’ll guide you through the process one step at a time! Video Objective We are trying to split a…

Read More

Format Items Found in a List

By Jeff Lenning | August 6, 2024 |

In this post, we’ll learn how to format a range to automatically highlight any items found in a list. In other words, we will learn how to highlight transactions that have a status value that matches any of the status values in a specific list, such as Pending or Processing. This illustration uses status values,…

Read More

Formatting Condition is a Calculated Value

By Jeff Lenning | July 30, 2024 |

Hello and welcome to this tutorial on how to use conditional formatting with a calculated value in Excel! Today, we’re going to dive into the following question: How do you conditionally format a cell when the condition is based on a calculated value? Let’s jump right in! Video Tutorial Let’s work through the concepts sequentially…

Read More

Turn a Table of Events into a Graphical Calendar

By Jeff Lenning | July 16, 2024 |

Today, we’re tackling the following question: How do you create a calendar that can show multiple events per day in Excel? We’re going to transform a simple table of events into a dynamic, graphical calendar. Let’s dive right in! Objective In summary, we have a list of events stored in a Table named Table1, like…

Read More