All articles with 'advanced excel' Tag

Excel 365’s FILTER() function is great for getting a cut of data that meets your criteria. But what if you need to filter and then show non-adjacent columns? Something like below. In this article, let me show you a few options to get discrete columns after filtering with the FILTER function.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

Ladies & gentlemen… I have an exciting announcement. I am relaunching my podcast!!!

It only took me 7 years, but Chandoo.org podcast is now BACK! I am planning to make regular episodes on Excel, Power BI, SQL & Data Analytics.

In the 1st episode of Season 2 of Chandoo.org podcast I talk about, Top 5 Excel Skills you need to be a Successful Data Analyst in 2023.

Excel formulas acting slow? Today lets talk about optimizing & speeding up Excel formulas. Use these tips & ideas to super-charge your sluggish workbook. Use the best practices & formula guidelines described in this post to optimize your complex worksheet models & make them faster.

1. Use tables to hold the data
2. Use named ranges & named formulas
3. Use Dynamic Array formulas
4. Sort your data
5. Use manual calculation mode

… and more. Read on to learn these top 10 tips & ideas to improve performance of your excel formulas.

Recently I used an elegant and smart technique to simplify lengthy nested IF formulas and made them 80% shorter. In this article, let me explain the process and share the results.

Don’t feel like doing the Excel work yourself? You can ask the AI features of Excel ? to automatically do stuff for you. Save time and look like a hero at work ????????.

Advanced Excel Skills are highly sought after. Use this FREE Excel roadmap to learn and grow you Excel skills in 3 months.

I have an orders table and want to see only orders from a given list of products. We can use Excel’s FILTER function to do this.

Let’s face it. You already know how to use SUMs, COUNTs and IFs and want to level up. But there are 100s of functions in Excel and you are not sure which ones to focus on.

In this article, let me reveal the top 10 important functions in Excel for data analysis work.

Writing advanced formulas is a lot like LEGO. Use what you already have and combine them in creative ways. Let me demo with 5 examples.

IF is the most used Excel function out there. Here are 10 advanced IF tricks to take your formulas to next-level ?

Got some data in a calendar format and just wished you can get it in tabular format?

You can use Excel formulas or Power Query to do this. In this article, let’s review formula based approach with two excellent choices.

A stream graph or stream plot is an area chart that looks like a stream. In this post, let me show you how to create an interactive stream graph using Excel area charts. The original design for this graph is inspired from Cedric Scherer.

This week, I am running a contest on YouTube. One of the criteria for picking winners is that they must comment on my video. So far, I got more than 200 comments. To make my job easier, I want to export the video comments to an Excel file. Turns out this is easily done once you have a Google developer API key. In this article, let me explain the process for extracting Youtube video comments to Excel table.

Excel Pivot tables make data analysis and visualization easy. With the help of these advanced pivot table skills, you can create powerful data analytics and reports.   New to Pivot Tables? If you are new to Pivot Tables, check out this excellent introduction to Pivot Tables page. × Dismiss alert Table of Contents #1 – One Slicer, Two […]

Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this article is for you. In this page, learn how to,

• Introduction to IRR & XIRR functions
• Calculate rate of return from a set of cash-flows with XIRR
• Simulating purchase or terminal value changes with data tables
• Apply conditional formatting to visualize the outputs
• Common issues and challenges faced when using XIRR