Hello and welcome to our post on grouping rows in Excel. We will walk through the process of combining the values in multiple rows into a single cell (comma-separated list of values). The example we’ll use to demonstrate the steps is to combine multiple email addresses for each contact into a single cell. But, this… The post How To Group Rows (comma list of values) appeared first on Excel University ..read more

One of the highly effective ways to boost navigation in your workbooks is by inserting hyperlinks. You can create links in your Excel workbooks that link to files of any type, including PDF files, Excel workbooks, Word documents, images, and even specific cells in a workbook. When you click on a link to a non-Excel… The post Insert a Hyperlink appeared first on Excel University ..read more

My friend John Michaloudis does an annual survey of Excel MVPs and experts and asks for their best Excel tip. He compiles the tips into an audio podcast along with show notes and related links. This is a great resource and I love sharing it every year. This year, he rounded up tips from: You’ll… The post Excel Tips from 19 Experts appeared first on Excel University ..read more

We all love Excel, don’t we? But it’s just not that simple when it comes to creating a 4-4-5 Financial Calendar! Got questions about how it’s done? You’re not alone! Today, we will walk you through the creation of a 4-4-5 (4 weeks, 4 weeks, and 5 weeks) calendar in Excel. By the end of… The post Creating a 4-4-5 Financial Calendar appeared first on Excel University ..read more

Hello and welcome to another informative blog post from Excel University. Today, we’re diving into a somewhat unusual topic – using Excel to launder money. If you aren’t familiar with that term, it simply means taking cash received from an illegal enterprise and running it through a legitimate business. That way, the money appears as… The post How to Launder Money with Excel (Benford’s Law) appeared first on Excel University ..read more

In today’s post, we’ll be diving into an exciting topic that springs up occasionally among Excel users: “How can you combine worksheets from different workbooks while keeping all the sheets separate in the resulting combined workbook?” Sounds tricky, doesn’t it? But don’t worry! We’ll be navigating through this method together. We’ll go step by step… The post Combine Sheets From Workbooks as Separate Tabs (Not merged) appeared first on Excel University ..read more

Today, we’re diving into an exciting way to enhance your data organization skills using Excel. I was recently asked the following question: Is there a way to create a list of files so that the files in the list could be hyperlinked back to the source in the folder? I’m going to answer that question… The post Create Hyperlinks to Files in a Folder appeared first on Excel University ..read more

Learn how to handle conditional summing in Excel with these amazing but easy-to-understand tricks. These effective strategies will level-up your understanding and management of Excel functionalities. The post Conditional Summing Tricks appeared first on Excel University ..read more

In today’s Excel University blog post, we’re going to explore the incredible combination of the Conditional Formatting and Data Validation features in Excel. I was recently asked the following question: How do I highlight matching customers on one worksheet based on the customer selected in a data validation drop-down list on another? And I’ll answer… The post Conditional Formatting With Data Validation appeared first on Excel University ..read more

Today, we’re diving into conditional formatting rules. Why? Well, to answer a question I received recently, which is basically: “I want a cell to be conditionally formatted based on the value in another cell where the criteria is: if cell C7 is up to 10% less than D7 then have a yellow color and if… The post Excel How to Conditionally Format Variances appeared first on Excel University ..read more