Search Results

Here's what we found

57 results for: excel free tools
Excel VBA and macros course cover

Unlock Excel VBA & Excel Macros

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

Excel Essentials for the Real World

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

How to Properly Handle Dates in Excel Pivot Tables

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!

How to Properly Use the Excel TEXTSPLIT Function

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.

New Excel Functions in Office 365 (VSTACK, TEXTSPLIT, TOCOL, DROP, WRAPCOLS, CHOOSECOLS, TAKE)

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!).

Excel LAMBDAs Made Easy with the New Advanced Formula Environment (Editor)

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.

Forecasting in Excel Made Simple

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!

How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick

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.

How to Add Text to Cell values in Excel – Add Text to Beginning or End of Cell values

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.

Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values)

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.

How Remove Duplicates in Microsoft Excel (3 Ways)

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.

How to Create a Pivot Table from Multiple Sheets in Excel

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.

Free Guide!

The ONE Critical Excel Skill You Need in 2023

This free QuickStart guide will help you to:

  • Pinpoint the skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill