In this tutorial, I will show you five simple ways to sum a column in Excel. You can use the autosum shortcut, use a formula, or convert data to Table.| Trump Excel
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
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
Learn all about the new Excel XLOOKUP Function. It's way better than VLOOKUP or INDEX/MATCH. Here you will find 10 XLOOKUP examples + download file| Trump Excel
One area that often troubles Microsoft Excel users is working with dates.| Trump Excel
Excel has some really useful features that can help you be a lot more efficient in your day-to-day work.| Trump Excel
Want to insert a check mark (Tick Mark) symbol in Excel? Here are some easy ways to do that. The methods include shortcuts, dialog box. formulas & VBA| Trump Excel
In this tutorial, you will how to quickly find and highlight blank cells in Excel. You can do this using conditional formatting, Go to Special, or VBA.| 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
Learn some simple ways to insert new columns in Excel (by using a keyboard shortcut and VBA). It also covers how to insert adjacent and non-adjacent columns| Trump Excel
Learn how to easily Compare two Excel sheets (in the same workbook or in different workbooks). You can compare sheets side by side or use formulas.| Trump Excel
In this tutorial, you'll learn about Excel Freeze Panes options. It makes the rows/columns headers visible all the time while working with large data sets| Trump Excel
Learn how to compare two columns in Excel using VLOOKUP. Find matches and differences in data, and highlight rows with matching or different values.| Spreadsheet Planet