Excel-related articles.
Filtering and sorting a dataset allows you to analyse it more effectively by hiding the surplus and putting column data in ascending or descending order. An Excel Table provides the tools to do this; however, clearing the filter and sort…
Combining tables has been notoriously difficult in Excel. In November 2020, I wrote an article called ‘Combining Multiple Excel Tables into One’, which demonstrated several methods that were clunky, cumbersome, and inflexible. There was no alternative. Thankfully, 17 months on…
Flash Fill is an Excel feature that intelligently spots patterns in your data to fill a range of cells. It can be used for things like: The process is: As an alternative to step 2, type a second entry for…
Excel Tables has a Banded Rows option that highlights rows in alternating colours. This enhances readability by making it easier to differentiate between them. What if you wanted to highlight blocks of rows though? A conditional formatting rule combining the…
3D references provide a simplified way of aggregating data by referring to the same cell or range across multiple worksheets. Say you had monthly sales figures stored in separate worksheets and wanted to summarise them. You might be tempted to…
Percentages are calculated for many things, such as interest rates, income tax, profit margins, restaurant bills, and possession in football matches. There are three main percentage calculations; each is shown in the document. Percentage of Total (Page 1) The exam…
End of content
End of content
