Search Results

Learn time-saving hacks to work smarter in Excel. Our members also consistently report a newfound enthusiasm for using Excel after taking our course.

Discover 10 pro hacks that will make creating pivot tables easier. Learn how to customize layouts, create dynamic reports, conduct in-depth analysis.

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

Learn time-saving hacks to work smarter in Excel. Our members also consistently report a newfound enthusiasm for using Excel after taking our course.

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.