Timeline chart is a type of chart that visually shows the chronological sequence of past or future events on a timescale. The chart’s timescale can be in days, weeks, months, quarters, years or other units of time depending on the type of events shown on it.
Frequency table is one of the commonly used methods to summarize both qualitative and quantitative data. It provides frequencies and relative frequencies for data by class. Frequency table usually consists of the following three columns: 1) Class – one of the categories into which data can be classified; 2) Class frequency – the number of observations in the data set falling into a particular class; 3) Relative frequency – the class frequency divided by the total number of observations in the data set, usually expressed as a percentage. You can create an interactive frequency table in Excel with the PivotTable tool where you can interactively change the variable by which the data is summarized.
If you have time series data in your worksheet, visually showing changes over time can be useful. This will make it easy to look for any patterns, trends or other useful information in your data and make decisions based on them. You can visualize time series data with Conditional Formatting in Excel, where rules are applied to data to show increases in green and decreases in red.
Multi-category chart or multi-level category chart is a chart type that has both main category and subcategory labels. This type of chart is useful when you have figures for items that belong to different categories.
When calculating formulas, Excel follows a certain calculation order. This calculation order is determined by 3 rules: 1) precedence rule; 2) left-to-right rule; 3) parentheses rule.