Click on the "Follow" button below and you'll get the latest news from Excel University via email, mobile or you can read them on your personal news page on this site.
You can unsubscribe anytime you want easily.
You can also choose the topics or keywords that you're interested in, so you receive only what you want.
Excel University title: Home - Excel University
Is this your feed? Claim it!
Microsoft Excel continues to evolve, and one of the most impressive additions to the Excel formula family is the GROUPBY function. With it, we now have the power to create fully dynamic and flexible summary reports—all with a single formula. If you’ve relied on pivot tables or manual formulas for reporting, you’re going to love…
The post
When working with tabular data in Excel, there are often times we need to extract specific rows or columns based on custom logic. This is where the CHOOSEROWS and CHOOSECOLS functions come into play. These recently introduced dynamic array functions are powerful alternatives to functions like TAKE and DROP, offering more flexibility by letting us…
The post
Bringing external data into Excel used to mean a lot of clicking: opening files, copy/pasting, or launching Power Query. But with Excel’s newer IMPORTCSV and IMPORTTEXT functions, you can now load external data directly into your sheet with a simple formula. Video Tutorial These functions are lightweight, fast, and flexible—great for quick access to structured…
The pos...
Sometimes when we copy data into Excel—from websites, reports, or bank statements—it doesn’t arrive in a nice, neat table. Instead, it comes in as one long line of values, either in a row or a column. That’s where WRAPROWS and WRAPCOLS come in. Video Tutorial In this post, we’ll explore how to use these functions…
The post