In this tutorial, you'll learn the techniques to transpose data in Excel. You can use the Paste Special option, Transpose Function or a Custom Macro.| Trump Excel
Search and Highlight Data in Excel with Conditional Formatting - highlight matching cells, rows, and even make it dynamic (highlight as you type).| Trump Excel
Learn how to number rows in Excel in a few easy steps. In this tutorial, I'll show you 7 methods to insert rows numbers (aka serial numbers) in a dataset.| Trump Excel
Most of the time, when working with Excel, you need to restructure your data before you can start any kind of analysis.| Trump Excel
In this tutorial, you will learn how to use Excel TRIM function to remove extra spaces in Excel. It is one of the best ways to clean data in Excel.| Trump Excel
There are a lot of option to sort data in Excel. In this in-depth tutorial, I will show you all these option to sort in Excel (by date, text, number, color)| Trump Excel
In this tutorial, you'll learn how to quickly delete blank rows in Excel. I have covered multiple methods, including Formulas, Go To Special, and VBA| Trump Excel
Learn how to create amazing Excel dashboards. It covers the best dashboard practices, useful tools, and do's & don'ts (with Examples & Templates)| Trump Excel
In this tutorial, you will learn how to use Excel Text to Columns feature. It also covers 7 different cases where text to columns can be used.| Trump Excel
In this tutorial, you'll learn how to unhide columns in Excel. You can use the keyboard shortcut, options on the ribbons or change the column width.| Trump Excel
In this tutorial, I'll show you various ways to compare two columns in Excel. The techniques shown can be used to find/highlight matches and differences.| Trump Excel
Learn how to create a custom list in Excel that can be used to create your own sorting criteria or save time by using it with fill handle.| Trump Excel