Summary
In this chapter, you have been taught how to use the pivot tools to structure data correctly for analysis by being shown how to transform rows in order to display them across columns and vice versa. We had a look at the theory behind the Refresh option to understand the sequence of refresh, how to refresh, and its pros and cons. In the column and row tools section, you learned how to clean data by removing top or bottom rows from a table, removing duplicate rows, and replacing null values in a table and adding a header row. You also learned how to remove certain columns if you do not require them for analysis purposes and how to add an index column to act as a row counter that aids in data analysis. You are now able to meet a set of query conditions by creating a conditional column using the if…then…else
statement. You consolidated your knowledge of filtering in Excel by learning how to sort and filter using the AND/OR
statements, as well as how to create a dynamic...