Task 6 Conditional Formating a Matrix
This walks through how we can use conditional formating within a Mtrix (Table) visualisation to enable us to present numbers in a more engaging way and tell our story. Including,
Overview of Conditional Formatting in a Matrix/Table Visualization: The video discusses how to use conditional formatting within a matrix or table visualization to present data in a visually engaging way, moving beyond just numerical formats.
Setting Up the Matrix: The speaker explains the process of selecting a matrix from the visual gallery and inputting data such as years and house prices. They also discuss removing row totals for better visualization.
Using Conditional Formatting Options: The video covers the use of conditional formatting options like data bars to format the information, providing visual indicators from the data.
Decision-Making in Formatting: The author talks about the decision-making process in selecting formatting options, such as choosing colors for the bars and comparing numerical values to determine positive or negative trends.
Analyzing Mortgage Rates: The speaker expresses interest in the changes in mortgage rates, particularly whether they are positive or negative, and how this impacts borrowing for housing.
Manipulating Data with Filters and Icons: The video shows how to use filters and conditional formatting to manipulate data, focusing on whether values are increasing or decreasing.
Setting Rules and Conditions: The author discusses the need to set rules and decide on conditions based on the data, adjusting numbers and percentages accordingly.
Customizing Spreadsheets: The video explains how to convert percentages to actual numbers, make negative numbers appear clearly, and use icons for organization. The speaker also mentions the possibility of further customizing the spreadsheet.
Enhancing Visual Representation: The speaker talks about making the rows larger, adding different backgrounds and colors for readability, and positioning specific columns for ease of reading.
Creating a Visual Representation of Data: The video concludes with the speaker expressing satisfaction with the visual representation of data in the table, suggesting the use of a correlation coefficient to determine the strength of the relationship between data points.
Engaging the Audience: The speaker believes that this visual representation is an effective way to engage the audience with the information.
Closing Remarks: The video ends with the speaker asking the audience to give a thumbs up to the video and saying goodbye.