Blog : The Learning Hour

A unique knowledge sharing forum

Excel Hack: Using the DATE functionalities

The Learning Hour* - Week 8: Using the DATES functionality in Excel 1. A date in Excel is also a number Every date on an Excel sheet can be converted into its corresponding number. For example, the number 1 represents the date January 1, 1990 Let us see how we can find that: Let us say we...

READ MORE

Data Analyst vs Data Scientist

The Learning Hour* - Week 7 : Data Analyst vs Data Scientist Data is the new oil and a lot of new job profiles revolve around it. This is a trend that is hard to reverse in the near future. There are two job profiles in this domain that seem to cause some bit of confusion in our minds. Most...

READ MORE

Future of Workplaces

There are a lot of technological innovations happening in the world today that will radically change how the workplaces of the future will look like. One school of thought is a completely decentralized work-place where every individual will be seen offering their expertise or skill as a...

READ MORE

PowerPoint hack: Using the SLIDE MASTER

Lets say you are creating a PowerPoint presentation for a meeting. The meeting is about to start in next 5 mins. You review the final presentation once before putting it up on the big screen. And guess what – you realize there is something that you forgot to do. In the heat of things, you...

READ MORE

Minority Interests vs Minority Investors

If you have ever looked at the Balance sheet of large companies, you would often find this line item Minority Interest on the liabilities section. They look something like below: Ever wondered what are these? Well these are equity-equivalent liabilities of a company. But they are NOT really...

READ MORE

Excel Shortcuts for handling Large Datasets

All of us use Microsoft Excel for one thing or the other. We spend so much time looking at rows and rows of data. However, browsing through data, navigating between sheets or even basic formatting can be very time consuming. So how about, we look at some simple yet powerful Excel keyboard...

READ MORE

The Pyramid Principle of Communication

One of the most powerful and frequently used frameworks in business communication is the Pyramid Principle. It is very effective especially with the senior management of a company. It is a TOP-DOWN as well as very DIRECT mode of communication tailored for executives who are busy and want to get...

READ MORE

Valuation fundamentals

As a financial/business/valuation analyst, many times we have to spend a considerable amount of time trying to find the VALUE of companies. There are many different aspects of value – different terms get used synonymously and often causes a lot of confusion. We thought we will help to end the...

READ MORE

Credit Analyst careers

To learn the specific credit analysis skills, you can check out our online course here. Please log in to provide your comments!

READ MORE

New to corporate life: What to focus on and why?

James joined his dream company, directly after graduation. He was full of energy and enthusiasm and proud to be working for such a reputed name. However, all of this died down as he started struggling to complete the tasks that he was assigned with. He wasn’t given time to learn on the ground...

READ MORE