Author Archives: Lamiya Mammadova

How to Create Timeline Chart in Excel Quickly and Easily

Timeline Chart in Excel

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. continue reading >>

How to Create Interactive Frequency Table in Excel

Interactive frequency table in Excel

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. continue reading >>

How to Visualize Time Series Data with Conditional Formatting in Excel

Visualize time series data with Conditional Formatting in Excel

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.
continue reading >>

How to Create Multi-Category Chart in Excel

Multi-category chart

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. continue reading >>

Calculation Order in Excel Formulas

Calculation order in Excel formulas – 7 small arrows one after another, the writing “left-to-right” with 2 small arrows below it and a pair of parentheses side by side in three cells

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. continue reading >>