Practical Excel knowledge to help you work faster and smarter.
For data reports, sometimes you want your data ranking in relation to each other visible. And sometimes, you don't want it visible.
Here's how to fix a periodic issue that comes up while using keyboards in Microsoft Excel: your keypad arrows start to scroll your screen from top to bottom or left to right, instead of moving your focus cell to the left or to the bottom.
So you have a workbook with several worksheets, maybe up to 30. And you need each worksheet exported one after the other, so that you now have 30 Excel workbooks instead of one. Is there a way to get this done in less than one minute...
When working with tables of data, the table set up usually encountered is the cross-tabulated or matrix data format. However, this dataset is not optimized for further analytics in Business Intelligen...
One of the standard Excel features available is the Text-to-Columns feature which enables users to separate content within a cell into several columns based on a specified delimiter. What if, however,...
Have you had to work with a folder containing lots of documents, and you wanted to get the list of all the documents? This may be a directory listing all the policy documents in the organization, or t...
Gauge charts are visualization tools used to show a KPI performance in relation to a gradient demonstrating the ranges of poor, medium, average, and excellent performance. Gauge charts have a reputati...
Here is how to set up your Excel worksheet with the flexibility to update the time unit as required. In the example below, the flexible timescale has been created for a Project Gantt Chart, and users ...
A dynamic calendar in Excel is set up to present the calendar for a selected month and year and automatically updates when the month and year are changed. There are preset Excel templates containing d...
Loading more…
Subscribe and follow for daily Excel tips, tutorials, and hacks delivered right to your feed.