Blog : The Learning Hour

A unique knowledge sharing forum

The Power of Compounding

What are the most powerful forces of the world? When someone asks us this question, few of the universal powers like Gravity, Sun, Black Hole etc. come to our mind. The Power of compounding is also one of the most powerful forces in the world. Albert Einstein said Power of compounding as the...

READ MORE

Do Online Learning Benefit Your Career?

Every person's professional journey tale currently has changed. Earlier people would complete their studies or degrees and join office. They would either utilize their knowledge or learn things from their experience and continue doing their jobs until they retired .Then came the era of...

READ MORE

Understanding the Pareto Principle

What is Pareto Principle? The Pareto Principle is named after a famous Italian economist Vilfredo Pareto. The first time this principle was noted when he looked at the economic state of the Italian Population. He found that 80% of the wealth in Italy was owned by 20% of the people. This survey...

READ MORE

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