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.


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. 

Data Analysis and Reporting with Help of Pivot Tables

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.

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.

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.

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 

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.

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

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.

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. 

Hierarchy Charts in Excel- Tree Map & Sunburst

Hierarchy refers to different levels within a system. In an organization, hierarchy means the different levels at which people within the organization operate (juniors, mid-level and senior level).

Game Stopped for GameStop Traders – Case Study

Over the last one month we have heard this name quite frequently – GameStop. What is GameStop? Why has it become a famous name?

Online Learning Develops Soft Skills

Why do you choose an online program? Mostly because of its flexibility, convenience and cost-effectiveness.

Nanodegree and Online Learning

A breakthrough in the sector of education that emerged few years ago is the trend of micro credentials and nanodegrees.

Understanding the Unique Function in Excel

Microsoft Excel 365 has come with a series of new array functions. These functions are very useful & the Unique function is one of them.

Importance of Excel Analytics in Work Life

Appearance of Microsoft Excel in workplace dates back to 1985. Hearing about Microsoft Excel the first thing that comes to mind is the endless lists of numbers across the screen or the spreadsheet.