Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
If your work involves printing your excel worksheets, it’s a good idea to insert page numbers in it. Inserting page numbers in Excel takes a little more work as compared with other Microsoft applications such as Word or PowerPoint. Watch Video – How to Insert Page Numbers in Excel How to Insert Page Numbers in …
Watch Video – Using Excel Freeze Panes When working with large data sets, if you scroll down or to the right of the worksheet you would lose track of the row/column headings. In such situations, you can use the Excel Freeze Panes feature to freeze the rows or columns in your dataset – so that the headers always …
A drop-down list is an excellent way to give the user an option to select from a pre-defined list. It can be used while getting a user to fill a form, or while creating interactive Excel dashboards. Drop-down lists are quite common on websites/apps and are very intuitive for the user. Watch Video – Creating a Drop …
The ability to quickly group dates in Pivot Tables in Excel can be quite useful. It helps you analyze data by getting different views by dates, weeks, months, quarters, and years. For example, if you have credit card data, you may want to group it in different ways (such as grouping by months or quarters …
If you work with Excel Pivot Tables, Pivot Cache is something you should definitely know about. What is Pivot Cache? Pivot Cache is something that automatically gets generated when you create a Pivot Table. It is an object that holds a replica of the data source. While you can’t see it, it is a part …
Applying conditional formatting in a Pivot Table can be a bit tricky. Given that Pivot Tables are so dynamic and the data in the backend can change often, you need to know the right way to use conditional formatting in a pivot table in Excel. The Wrong Way to Apply Conditional Formatting to a Pivot …
Do you merge cells in Excel? If yes, you need to know a few drawbacks of merging cells. To begin with, if you try and sort cells that have been merged, it will refuse to do so and show you an error that says – To do this, all the merged cells need to be …
You have been working hard for months and finally, it’s time for that long awaited vacation. The build-up to vacation is often as exciting as the vacation itself. But a lot of time we get bogged down by the preparations and data management. Even for a short vacation or business trip, there is a lot …
Leading and trailing spaces in Excel often leads to a lot of frustration. I can’t think of a situation where you may need these extra spaces, but it often finds its way into the excel spreadsheets. There are many ways you can end up with these extra spaces – for example, as a part of …
©trumpexcel.com – Free Online Excel Training
