Giving a name to your columns can be quite useful if you want to use these in the formulas.| Spreadsheet Point
Excel autocorrect allows you to automatically correct mispelled words. You can also use this feature to insert symbols quickly or to write formulas faster.| Trump Excel
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
Excel is an amazing tool to store and analyze data. And many of the times, you will have to deal with text data types such as names, regions, departments, or| Trump Excel
Power Query can be of great help when you want to combine data from multiple workbooks into one single worksheet. Here is a step-by-step guide on how to do this in Excel. You can combine data when it's stored in an Excel table, or even when it's not formatted as a table.| 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
Deleting a row or deleting multiple rows is a regular part of most Excel users.| Trump Excel
If you want to count filtered rows in Excel, you can do that using the SUBTOTAL function.| Trump Excel
In this tutorial, you'll learn how to refresh pivot table in Excel. You can either refresh the data, change the data source, or use a macro to do this.| Trump Excel
Conditional formatting in Excel highlights cells that meet a specified condition. Here is a guide on using conditional formatting in Excel.| Trump Excel
Learn how to quickly remove table formatting in Excel. You can remove the formatting from an existing table to convert the table to range.| 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 create amazing Excel dashboards. It covers the best dashboard practices, useful tools, and do's & don'ts (with Examples & Templates)| Trump Excel
Want to delete rows based on a cell value or a condition? In this tutorial, I cover multiple ways to do this - including filters, sorting, and VBA| Trump Excel
Working with Excel means working with cells and ranges in the rows and columns in it.| Trump Excel
Here is a list of 24 Excel tricks that will save you a lot of time and energy. These simple Excel Tricks will make sure you get out of office in time.| Trump Excel
In case you're prepping up for your next job interview and have listed Excel on your resume, here are 100+ Excel interview questions to make you ready.| 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