Mandatory Trainings: Are we doing them? [Data Analysis Challenge – 002]
This week, let’s try something new. I have a spreadsheet challenge for you. Solve it, post your answers by leaving a comment. No cheating or no AI help on this one. Mandatory Training at Awesome Chocolates You are the head of L&D department at Awesome Chocolates. As part of employee induction, every new hire at […]
How to Merge Multiple CSV Files in Excel (Step-by-Step Guide)
Have a bunch of CSV files in a folder and want to merge or combine them to one big file? Follow these simple instructions to combine multiple CSV files in to one spreadssheet using Microsoft Excel (2016 or above). What you need? Method 1: Merge CSV Files using Power Query (Recommended) This is by far […]
How to get non-adjacent columns with FILTER function in Excel
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.
Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)
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.
Speed up your Excel Formulas [10 Practical Tips]
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.
A clever technique to simplify your long, nested IF 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.
Top AI features in Excel – a round up
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 ????????.