Search Results

Automate ANYTHING you need done in Excel with VBA and macros. Go from Beginner to VBA Expert and design automations with confidence.

Become Confident. Learn Excel from Scratch or Fill in the Gaps.

Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

Excel’s TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.

Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).

The new Microsoft Excel Advanced Formula Add-in makes it easy to write and manage LAMBDAs in Excel.
It’s a “new” version of Name Manager and hopefully it could replace Name Manager in the future.

Learn how to easily create a forecast in Excel – even if you have seasonality. It just takes one click and Excel can forecast the next months for you!

With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.

You can easily add text to your cell values in Excel. You don’t have to do this manually. You have 3 easy options to choose from. The 3rd one will surprise you. You can use it in many other circumstances as well.

Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You’ll have to combine these multiple values into one cell. I’ll show you 3 methods to get this done.

These are 3 easy ways to remove duplicates in your data to create a unique or distinct list of values in Microsoft Excel. It’s a very common task for data cleaning and also a very common job interview question… BUT one of the methods returns a different result. Make sure you understand why.

Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to “merge” the data and sometimes you have to “append” data from multiple sheets for your Pivot Table. Don’t use formulas! Instead use this method.