Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
What do you do when you have to enter a sequence of serial numbers in a column in Excel? For example, entering numbers 1 to 1000 in cell A1:A1000. The regular way of doing this is: Sometimes it may get a bit irritating to drag the fill handle to the last cell which can be …
Excel Pivot Table is a great tool. It only takes a few clicks to create a Pivot table and you can easily analyze huge datasets without worrying about human errors. One of the default settings in Pivot Tables is to show a blank cell when there is no data for the given row/column label. In …
If you need to print your work in Excel, this tip would save you some papers. Using this, you can set the print area in Excel worksheets, so that only that part of the worksheet is printed. This technique could be useful if you want to print only a part of a report or there is …
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 …
If you want people to pick a value from a fixed list instead of typing it, a drop-down list is the way to do it. It takes only a few seconds to set up. It’s useful when you’re getting someone to fill a form or a tracker, or when you’re building interactive Excel dashboards. Drop-down …
If you want to see your sales by month, quarter, or year in a Pivot Table, you don’t need to add any helper columns to your data. You can group the dates right inside the Pivot Table. It helps you analyze data by getting different views by dates, weeks, months, quarters, and years. In this …
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 …
©trumpexcel.com – Free Online Excel Training
