Blog : The Learning Hour

A unique knowledge sharing forum

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

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

10 MOST USED FINANCIAL FUNCTIONS IN EXCEL

Excel is a tool most commonly used for data analysis, building financial models for efficient decision making. It is used by people with diverse back grounds (ie; bankers, analysts, professionals, students etc.). In excel there are a lot of inbuilt functions which can be used for quick data...

READ MORE

100+ useful excel Keyboard short cuts

Using Excel short cuts help work much faster and improve efficiency. Here is a list of 100+ keyboard shortcuts for commonly used functions. Practicing these short cuts would help you to memorize them, thus improving the productivity drastically while working on complex data analysis or financial...

READ MORE

Understanding XLOOKUP with Examples

XLOOKUP is a function which is newly introduced function in MS Office 365. It can be used in place of VLOOKUP as well as HLOOKUP, Index, Match and much more. Here are a few advantages of using a XLOOKUP function. Lookups in both vertical and horizontal ranges XLOOKUP does not break...

READ MORE

Why You Need Valuation Analyst Skills?

Yes Bank is the fifth largest private lender in India. It accounts for approximately 2.3% of total bank loans and 1.6% of banks deposits domestically. RBI has recently imposed a moratorium on the bank. It has imposed a withdrawal limit of Rs 50,000/- for depositors. This has led to several...

READ MORE

Selecting good companies for investment?

Equity markets have generated highest returns for decades as compared to gold, fixed deposits, debt and other financial instruments. All of us want to generate high returns from our portfolio. Quite often, while looking at stock prices of different companies, we find the valuation of one...

READ MORE

Measures of financial performance

There are a number of financial metrics used frequently to measure performance of a company. To name a few; EBITDA margin, EBIT or operating margin, Net income margin, earnings per share, return on equity, return on invested capital or Return on capital etc. While going through analyst reports,...

READ MORE

Online Education: How Can It Change the World?

There is a lot of talk about the student debt crisis in the United States. An average graduate in the U.S. has a student loan of $35,000 still to be paid off. That is just insane! The high cost of college education is an issue not only in America, where student loan debt has reached an...

READ MORE

Freelancing Careers in Financial Services

Is it possible to have a freelancing career in financial services? Yes, certainly – the financial services industry has undergone a radical transformation in recent years, thanks to the internet and cloud computing. There are today a number of jobs in the financial industry that can be done...

READ MORE