Bytes

Using keyboard short cut keys while working on Power Point documents help improve efficiency. Here is a list of 80+ keyboard shortcuts for commonly used functions. 

Description : Understand the basic difference between fundamental and technical analysis of stocks to determine the quality of long-term investments

Total shareholder return is rate of return earned by an investor by investing in stocks of Companies during the investment period. An investor investing in stocks makes money in two ways;

Cash flow statement is a statement reported by Corporates in their filings along with the Income Statement and the Balance Sheet.

“IF YOU WERE BORN POOR ITS NOT YOUR FAULT. BUT IF YOU DIE POOR ITS YOUR FAULT.”This is a famous quote from Bill Gates.

Net present value is the difference between present value of cash inflows and present value of cash outflows. It is a technique used to evaluate potential investment decisions. 

Market capitalization means the market value of equity shares of the Company. It is an important component of a Company’s valuation.

Excel is a tool most commonly used for data analysis, building financial models for efficient decision making. 

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.

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.

The three financial statements – Income statement, balance sheet and cash flow statement are dependent and linked to each other.

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. 

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.

In our earlier blog, Total Shareholder Return - Definition & Explanation we discussed about the meaning of Total Shareholder Returns and factors driving returns.

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.

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