Blog : The Learning Hour

A unique knowledge sharing forum

Dashboard design principles

A dashboard is a visual representation of data. Dashboards are prepared to communicate the insights from the data through charts and graphs and help the users make better and informed decisions. Normally analysts spend a lot of time in cleaning data, consolidating, summarizing, and analyzing...

READ MORE

Consolidating data with Pivot Table Wizard

In our earlier article, we discussed how we can do quick data analysis using Pivot Table functionality in Excel. In this article, we will discuss how we can consolidate data across multiple sheets and prepare quick reports with the help of Pivot Tables. Let us quickly understand with the help of...

READ MORE

How to Transpose Data in Excel

Transposing data means moving the row data to a column and a column data to a row. Transposing data is useful for data analysis. At times, we have to pull data from various files with different formats for analysis and preparing reports. In such circumstances, we may have to transpose some data...

READ MORE

How to Calculate Total Shareholder Returns (TSR)

In our earlier blog, Total Shareholder Return - Definition & Explanation we discussed about the meaning of Total Shareholder Returns and factors driving returns. In this blog, we will discuss how to calculate TSR if the investment period is more than one year. Example 1 – TSR calculation...

READ MORE

Data analysis and reporting with help of Pivot Tables

Do you know about Pivot Table? Pivot table is a great tool in excel. It helps prepare reports and get insights from huge data sets with just a few clicks. It can help summarize data, reorganize data, group, sort and filter data quickly. If we have a large data set and want to get quick...

READ MORE

POWERPOINT ZOOM – A GREAT WAY TO MAKE INTERACTIVE PRESENTATIONS

The PowerPoint zoom feature is a great way to make the presentation dynamic and interactive. When you use this feature, the slides are not presented in a usual order. This feature helps present slides in any order as one likes during the presentation making it more interactive. This feature is...

READ MORE

How to prepare a cash flow statement

The three financial statements – Income statement, balance sheet and cash flow statement are dependent and linked to each other. Many of our students know about the income statement and balance sheet but struggle to create a cash flow statement. A cash flow statement is a critical part of the...

READ MORE

Waterfall Charts in Excel - Example and Limitations

What is a Waterfall chart? A waterfall chart is a great way to show variance analysis from one point to the other. These charts help easily visualize the drivers which are responsible for the change. For Example. how the profit or revenue of a company grew from one period to the other. They can...

READ MORE

Data visualization with Excel Charts

What are Excel Charts? An Excel chart is a graphical representation of data. It helps provides an opportunity to tell a compelling story to the audience through data visualization. Data visualization helps to understand the data patterns and connections. It is important to focus on the...

READ MORE

Basics of Accounting - With Examples

What is Accounting? Accounting is the process of systematically recording financial transactions in a business. It also involves summarizing, analyzing, and reporting the financial information to its stakeholders. Accounting in simple terms is the language of business. It is very important to...

READ MORE